tn04462

I was able to fill in google's search, but i can't fill this in. Can someone help please? here my code. this is google search: #include <IE.au3> $oIE = _IECreate ("http://www.google.com") $oForm = _IEFormGetObjByName ($oIE, "gbqf") $oQuery = _IEFormElementGetObjByName ($oForm, "q") _IEFormElementSetValue ($oQuery, "AutoIt IE.au3") _IEFormSubmit ($oForm) and this is the site i wanted to do: #include <IE.au3> $oIE = _IECreate ("http://owmdeals.com/FAB/FAB-Under-Construction.html") $oForm = _IEFormGetObjByName ($oIE, "upl_form") $oQuery = _IEFormElementGetObjByName ($oForm, "item") _IEFormElementSetValue ($oQuery, "AutoIt IE.au3") _IEFormSubmit ($oForm) with this being the html code: <form id="upl_form" style="margin: 0;" name="upl_form" method="post" action="speedy_blogger.php"> <input type="hidden" value="X" name="bms"> <input type="hidden" value="" name="maxmet"> <img class="twisty " role="presentation" /><table width="0px" cellspacing="0" cellpadding="0" bgcolor="#ffffff"> <img class="twisty " role="presentation" /><tbody> <img class="twisty " role="presentation" /><tr> <img class="twisty " role="presentation" /><td class="speedy_form" colspan="2"> <img width="100" height="30" border="0" alt="eBay item number" src="speedy_images/itemnumber.png"> </td> <img class="twisty " role="presentation" /><td class="speedy_form"> <input type="text" value="" maxlength="12" size="12" name="item"> </td>

found the answer to this . thank you .

I been trying to use imagemagick to put an image on top of another image but i have no clue why I can't get anything to create. I don't really understand the syntax of the compose.. i have been able to resize and crop images with convert. can anyone help me with the syntax please? here's the code for the syntax for convert Func fiximage($filename) $B1=0 $D1=0 $M1=0 $var = StringLeft($filename, 11) $var2 = StringRight($filename,16) $B1 = StringInStr($filename, "B1") If $B1 > 0 Then $newfilename = $var & "-2.png" $img = ObjCreate("ImageMagickObject.MagickImage.1") $ret = $img.Convert($filename, _ "-resize", "378x392", _ "-crop", "282x392+48+0", _ $OD & $newfilename ) Return EndIf this is making my head spin thank you.

hmm never knew about UTF... thanks alot!

I made a script to get the source of a site but in the description has characters like — or ” it will print — and †ex: hint of shimmer—for will show: hint of shimmer—for can anyone point me in the right direction please. Ty in advance.

is it possible to select a subquery? i can't find any post that had an example . any help please?

>"C:Program Files (x86)AutoIt3SciTE..autoit3.exe" /ErrorStdOut "C:Scriptsturbolisterpulldesc.au3" We intercepted a COM Error!! err.description is: Syntax error in FROM clause. err.windescription is: err.lastdllerror is: 0 err.scriptline is: 7 err.number is: 80020009 err.source is: Microsoft Office Access Database Engine err.helpfile is: err.helpcontext is: 5003131 C:Scriptsturbolisterpulldesc.au3 (8) : ==> Object referenced outside a "With" statement.: MsgBox(0,"",$result.Fields( "8el" ).Value ) MsgBox(0,"",$result.Fields( "8el" )^ ERROR >Exit code: 1 Time: 2.942

i been trying to select a query in my script because it contains the modified version of the description from ms database but I can't run the query for some reason. the query name : sub-desc2 - i've tried with and without brackets [] the field is: 8el #include <access.au3> $adSource = "data.accdb" $oADO = _dbOpen($adSource) $sQuery="select * from sub-desc2" $result= $oADO.Execute($sQuery) MsgBox(0,"",$result.Fields( "8el" ).Value ) $result= $oADO.Execute($sQuery)^error

ah sorry for not replying, it's because i didn't understand what you meant. it's to attach to access database,, but i read about it increasing the size of the database if we attach the image to the database.. i read about linking it like you said and calling it when we need it... i'll look more into it. thanks for the concept. I think i misinformed u as well.. I'm not using sql , I'm using ADO with auto it to do this. what i'm doing is basically adding new inventory records to an access database. We have it were there's a part for image attachments so when we scann over the database we can see what the items look like as well. I've got the whole importing records working already but I'm a little confused how to attach the images. I use the Access.au3 that was made by geosoft.

i was going to link each image with its specific product. I'm sort of maintaining a small database. and I was able to add new records and update records but part of it is adding images with that product.

I tried using addrecord, and accessupdaterecord from the access UDF but i had an error.. so i tried this method #include <Access.au3> $adSource = "C:\Scripts\dbadev.accdb" $adTable = "[dba-item images]" $rData = "testdata" $adCol = 'owner' $adData="C:\Scripts\blue.png" $objErr = ObjEvent("AutoIt.Error","MyErrFunc") $Numeric = "141" $SQL = "UPDATE [dba-item images] SET Image1 = '" & $adData & "' WHERE ID = " & $Numeric & ";" $oMyError = ObjEvent("AutoIt.Error","MyErrFunc") $adCursorType=3 $oADO = _dbOpen($adSource) $oRec = ObjCreate ("ADODB.Recordset") $oRec.Open("SELECT * FROM " & $adTable, $oADO, $adOpenStatic, $adLockOptimistic) $oADO.Execute($sql) Func MyErrFunc() $hexnum=hex($objErr.number,8) Msgbox(0,"","We intercepted a COM Error!!" & @CRLF & @CRLF & _ "err.description is: " & $objErr.description & @CRLF & _ "err.windescription is: " & $objErr.windescription & @CRLF & _ "err.lastdllerror is: " & $objErr.lastdllerror & @CRLF & _ "err.scriptline is: " & $objErr.scriptline & @CRLF & _ "err.number is: " & $hexnum & @CRLF & _ "err.source is: " & $objErr.source & @CRLF & _ "err.helpfile is: " & $objErr.helpfile & @CRLF & _ "err.helpcontext is: " & $objErr.helpcontext _ ) ConsoleWrite ("We intercepted a COM Error!!" & @CRLF) ConsoleWrite ("err.description is: " & $objErr.description & @CRLF) ConsoleWrite ("err.windescription is: " & $objErr.windescription & @CRLF) ConsoleWrite ("err.lastdllerror is: " & $objErr.lastdllerror & @CRLF) ConsoleWrite ("err.scriptline is: " & $objErr.scriptline & @CRLF) ConsoleWrite ("err.number is: " & $hexnum & @CRLF) ConsoleWrite ("err.source is: " & $objErr.source & @CRLF) ConsoleWrite ("err.helpfile is: " & $objErr.helpfile & @CRLF) ConsoleWrite ("err.helpcontext is: " & $objErr.helpcontext & @CRLF) ConsoleWrite (@CRLF) SetError(1) EndFunc and i got : We intercepted a COM Error!! err.description is: An UPDATE or DELETE query cannot contain a multi-valued field. fields are key|name|image1|image2 is there any method to adding an image attachment using SQL?

Got it to work.. it was an issue with the table name. instead of dba-inventory use [dba-inventory]..

ok here's another finding .. when i rename the table... i can edit it as well... does that reset relationships? i read something about being connected to queries might not let you select the table? does that ring any bells? because when you rename the table.. the queries doesn't redirect to the new table name. changing the name also reset the relationship of that table.. I'm thinking it has to be with the relationship to other tables.. does anyone know how relationship within a table affect if we can SELECT a table or not? or is there a different approach to how we can open the database?

ok i added a error handler .. and this is what i got We intercepted a COM Error!! err.description is: Syntax error in FROM clause. err.windescription is: err.lastdllerror is: 0 err.scriptline is: 87 err.number is: 80020009 err.source is: Microsoft Office Access Database Engine err.helpfile is: err.helpcontext is: 5003131 We intercepted a COM Error!! err.description is: Operation is not allowed when the object is closed. err.windescription is: err.lastdllerror is: 0 err.scriptline is: 88 err.number is: 80020009 err.source is: ADODB.Recordset err.helpfile is: C:WindowsHELPADO270.CHM err.helpcontext is: 1240653

Okay i've tested this every possible way i could think. I'm new to msaccess so hopefully someone with more experience can catch my flaw. side note: the database was made by my friend I was able to add records to different tables in the database using the following code: but for the table dba-inventory I received an error saying: .Open ("SELECT * FROM " & $adTable , $oADO, $adOpenStatic, $adLockOptimistic)^ ERROR So i tried to duplicate the table in every way possible and I was able to edit the "duplicate." Can anyone please help me? Thank you in advance. #include <Access.au3> $adSource = "C:\Scripts\DbAs.accdb" $adTable = "dba-inventory" $adCol="Owner" $adQuery="test" $adcCol="Owner" $adData="2000|1|the name of the item12|description nana" $maxid=_accessMaxID($adSource, $adTable) ConsoleWrite($maxid) _accessAddRecord($adSource, $adTable, $adData)