Re: Prepared Statement Issues. - Mailing list pgsql-jdbc

From Paul Thomas
Subject Re: Prepared Statement Issues.
Date
Msg-id 20031025005338.C15949@bacon
Whole thread Raw
In response to Prepared Statement Issues.  (Greg Johnson <gregj@interprose.com>)
List pgsql-jdbc
On 23/10/2003 16:33 Greg Johnson wrote:
> 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 (?) (?)

Placeholders are for values not names. If it worked in a previous version
of the driver then that sounds like a bug which has been fixed.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-jdbc by date:

Previous
From: Paul Thomas
Date:
Subject: Re: No suitable driver
Next
From: "Jordan S. Jones"
Date:
Subject: Re: Unable to run Applets with appletviewer