Desker Posted December 4, 2005 Share Posted December 4, 2005 lookin for help on getting autoit v3 to get info from a database list any help would be helpful thx Link to comment Share on other sites More sharing options...
Zithen Posted December 4, 2005 Share Posted December 4, 2005 what kinda of database? access, sql, txt? Link to comment Share on other sites More sharing options...
Desker Posted December 4, 2005 Author Share Posted December 4, 2005 lookin for help on getting autoit v3 to get info from a database list any help would be helpful thxlookin for getting info from mysql or sql server then replying back with the nfo or a txt file would work if I can search in the file then report back the nfo of the line in the txt file Link to comment Share on other sites More sharing options...
Francis Lennert (France) Posted December 5, 2005 Share Posted December 5, 2005 I do use AutoIt with Mysql. Do you need help to connect ? Or to create a text file from a SQL Table ? Link to comment Share on other sites More sharing options...
Desker Posted December 5, 2005 Author Share Posted December 5, 2005 I do use AutoIt with Mysql. Do you need help to connect ?Or to create a text file from a SQL Table ?thx for the help Was just lookin for the commands to use. I've been lookin all over to find them Link to comment Share on other sites More sharing options...
ivan Posted December 5, 2005 Share Posted December 5, 2005 look at sql.au3 and sqllite.au3, which are 2 functions that might suit your needs. You'll find them in the scripts and scraps forums. ivan Think out of the boxGrabber: Yet another WinInfo tool_CSVLib (still alpha)Dynamic html in au3 Link to comment Share on other sites More sharing options...
ivan Posted December 5, 2005 Share Posted December 5, 2005 forgot to ask, is your server remote or local? in both cases you'll get useful functions, but I find dealing with remote servers less secure as you can have proxies listening for connections. ivan Think out of the boxGrabber: Yet another WinInfo tool_CSVLib (still alpha)Dynamic html in au3 Link to comment Share on other sites More sharing options...
Francis Lennert (France) Posted December 5, 2005 Share Posted December 5, 2005 (edited) Hello, A simple which uses : - An odbc Connection. - Mysql (but this kind of very simple SQL Statement will work with others databases). - The Beta Version of AutoIt which handles COM. $ado = ObjCreate( "ADODB.Connection" ) ; Create a COM ADODB Object with the Beta version $ado.Open( "DSN=My_ODBC_DSN" ) ; Must exists in your odbc links. $adors = ObjCreate( "ADODB.RecordSet" ) ; Create a Record Set to handles SQL Records $adors.Open( " Select * from MyTable", $ado ); Execute a SQL Select While not $adors.EOF ; ConsoleWrite( $adors.Fields( 1 ).Value&@CRlf ) ; First Column in th AutoIt console $adors.MoveNext ; Go to the next WEnd HTH, Francis Edited December 5, 2005 by Francis Lennert (France) Link to comment Share on other sites More sharing options...
Desker Posted December 5, 2005 Author Share Posted December 5, 2005 thx to both of you Francis Lennert & ivan for your help. The nfo both have gaven me has put me on the right path. thx Desker Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now