lookin for help on getting autoit v3 to get info from a database list

[Desker]

lookin for help on getting autoit v3 to get info from a database list

any help would be helpful

thx

[Zithen]

what kinda of database? access, sql, txt?

[Desker]

lookin for help on getting autoit v3 to get info from a database list

any help would be helpful

thx

lookin 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

[Francis Lennert (France)]

I do use AutoIt with Mysql. Do you need help to connect ?

Or to create a text file from a SQL Table ?

[Desker]

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

[ivan]

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

[ivan]

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

[Francis Lennert (France)]

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)

[Desker]

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