| View previous topic :: View next topic |
| Author |
Message |
fooz
Joined: 08 Jan 2006 Posts: 8
|
Posted: Thu Jan 19, 2006 8:09 pm Post subject: looking for a (postgre) SQL API |
|
|
Hi,
I have a pretty simple SQL call I want to make to my postgreSQL db, and I'm looking for any direction you can give. I'm guessing some sort of api (hopefully already written) is what I need.
thx,
fooz |
|
| Back to top |
|
 |
Chris Site Admin
Joined: 02 Mar 2004 Posts: 10480
|
Posted: Sat Jan 21, 2006 1:12 pm Post subject: |
|
|
| I haven't seen any posts yet that offer a way to do it directly, but you could use FileAppend to create a .sql or .php file to query the database. Then use RunWait to run it (and it would write is results to a file). Then use a file-reading loop to read the results, row by row. |
|
| Back to top |
|
 |
fooz
Joined: 08 Jan 2006 Posts: 8
|
Posted: Sat Jan 21, 2006 8:25 pm Post subject: |
|
|
Thanks.
I've actually gone the PHP route and needing only an integer value from the database returned, I'm able to pass it from the PHP to AHK via the exit code. |
|
| Back to top |
|
 |
|