Re: libpq prepared statement

2008-03-31 Thread Scott Ribe
These are _very_ basic C (and Objective-C) questions. 1) An NSString is a Cocoa Objective-C class. It is not a char* C string. Whether you need to have your UUID as a char* throughout the code, or whether you need to start with an NSString* and extract a char* for use with libpq depends on the big

Re: libpq prepared statement

2008-03-31 Thread Andrew Farmer
On 31 Mar 08, at 12:44, Justin Giboney wrote: p.s. why is it that Apple has no documentation on having Cocoa work with Databases? Try typing in "mysql" or "postgresql" in the search box of this page http://developer.apple.com/cocoa/ while restricting it to cocoa. Do they not want business to

Re: libpq prepared statement

2008-03-31 Thread Keary Suska
on 3/31/08 1:44 PM, [EMAIL PROTECTED] purportedly said: > PQprepare *statement = PQPrepare(theConnection, "stmtname", "SELECT * > FROM admin WHERE id = %s", 1, [theUUID]); Yes--it not even close. The libpq prototype is: PGresult *PQprepare(PGconn *conn, const char *stmtName, const char *query, i

Re: libpq prepared statement

2008-03-31 Thread stephen joseph butler
On Mon, Mar 31, 2008 at 2:44 PM, Justin Giboney < [EMAIL PROTECTED]> wrote: > PQprepare *statement = PQPrepare(theConnection, "stmtname", "SELECT * > FROM admin WHERE id = %s", 1, [theUUID]); > http://developer.apple.com/documentation/Cocoa/Reference/Foundation/Classes/NSString_Class/Reference/NS

libpq prepared statement

2008-03-31 Thread Justin Giboney
I am trying to get a libpq prepared statement to compile (not actually work) in my app. I am having difficulty finding an example of one on the internet somewhere. I don't really understand the documentation ( http://www.postgresql.org/docs/8.1/static/libpq-exec.html#LIBPQ-EXEC-SELECT