AutoHotkey Homepage AutoHotkey Community
Let's help each other out
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

looking for a (postgre) SQL API

 
Post new topic   Reply to topic    AutoHotkey Community Forum Index -> Ask for Help
View previous topic :: View next topic  
Author Message
fooz



Joined: 08 Jan 2006
Posts: 8

PostPosted: Thu Jan 19, 2006 8:09 pm    Post subject: looking for a (postgre) SQL API Reply with quote

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
View user's profile Send private message
Chris
Site Admin


Joined: 02 Mar 2004
Posts: 10480

PostPosted: Sat Jan 21, 2006 1:12 pm    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
fooz



Joined: 08 Jan 2006
Posts: 8

PostPosted: Sat Jan 21, 2006 8:25 pm    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    AutoHotkey Community Forum Index -> Ask for Help All times are GMT
Page 1 of 1

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum


Powered by phpBB © 2001, 2005 phpBB Group