Skip site navigation (1) Skip section navigation (2)

Re: Prepared Statement Issues.

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: Greg Johnson <gregj(at)interprose(dot)com>
Cc: "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Prepared Statement Issues.
Date: 2003-10-24 23:53:38
Message-ID: 20031025005338.C15949@bacon (view raw or flat)
Thread:
Lists: 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   |
+------------------------------+---------------------------------------------+

In response to

pgsql-jdbc by date

Next:From: Jordan S. JonesDate: 2003-10-25 00:07:17
Subject: Re: Unable to run Applets with appletviewer
Previous:From: Paul ThomasDate: 2003-10-24 23:45:36
Subject: Re: No suitable driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group