From: | Greg Johnson <gregj(at)interprose(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Prepared Statement Issues. |
Date: | 2003-10-23 15:33:50 |
Message-ID: | 1066923229.28266.912.camel@watto.interprose.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I recently have been trying to update to the 113 build of jdbc drivers,
but I am having some problems. I have several prepared statements where
I pass in order by column and the order of the sort.
select id, name, address, state from people order by (?) (?)
However, with the 113 build I cant seem to set the column name to order
by or the sort direction anymore. With the 112 build I just set the SQL
type to INTEGER and it passed through. I also used the same "hack" to
pass an array of values to IN statements.
select id, name, address, state from people where id in (?);
What java sql type do I need to use for these types of queries?
Thanks For you Help!
________________________________________________________________________
Greg Johnson
The InterProse
Consulting Group, Inc.
http://www.interprose.com
t (360) 604-3531 x225
f (360) 604-3579
From | Date | Subject | |
---|---|---|---|
Next Message | FERNANDA M. | 2003-10-23 23:19:35 | Retrieving bytes error!! |
Previous Message | ni3india | 2003-10-23 14:40:21 | Source code JDBC driver |