Re: [GENERAL] Prepared statement parameters for an 'IN ()' clause

2007-10-17 Thread Albe Laurenz
Jason L. Buberel wrote: > Can someone point me to an example of creating a prepared > statement for a query with an 'IN' clause? > > The query looks like this: > > select value from table where > state = $1 and city = $2 and zip = $3 and > date in ( $4 ); > > For the prepared statement, I have

Re: [GENERAL] Prepared statement parameters for an 'IN ()' clause

2007-10-17 Thread Sam Mason
On Wed, Oct 17, 2007 at 07:37:15AM -0700, Jason L. Buberel wrote: > Can someone point me to an example of creating a prepared statement for a > query with an 'IN' clause? > > The query looks like this: > > select value from table where > state = $1 and city = $2 and zip = $3 and > date in ( $4 );

[GENERAL] Prepared statement parameters for an 'IN ()' clause

2007-10-17 Thread Jason L. Buberel
Can someone point me to an example of creating a prepared statement for a query with an 'IN' clause? The query looks like this: select value from table where state = $1 and city = $2 and zip = $3 and date in ( $4 ); For the prepared statement, I have tried: prepare st1(text, text, text, text[