AutoHotkey Community

[ahk_man]

Hi chris, I would like to write a clean script to retrieve the value within the fields of a database. For example, I have an oracle database that has one row with three columns. The first column is call "name", second is call "address", and third column is call "city". I would like to write a script that will collect the name,address, and city values from the database and post on a webpage that has the field for "name", "address" and "city". Basically, this script would grab information from the database and would be smart enough to know where to place itself in the appropriate field that it belong to. Like, if it's a name it will copy itself to a name field on the webpage. It's like feeling out an automated registration webpage.

[Chris]

I believe there are some free command-line utilities to access various databases. If anyone here knows a good one, please post it.

I believe there is an ODBC access utility here: http://www.dmst.aueb.gr/dds/sw/outwit/

There are probably some more elaborate ones. You could try searching the newgroups for candidates.

Once you can access the database (maybe you already have a way to do this), filling out a web form can usually be automated by navigating it with the TAB key. In some browsers, using MouseGetPos or StatusBarGetText might be helpful to discover which control the mouse is hovering over.

Edit: fixed typo