Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Help with prepared statment for crosstab
- From: Kris Jurka <books(at)ejurka(dot)com>
- To: Carl Shelbourne <Carl(dot)Shelbourne(at)stanleybet(dot)com>
- Cc: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
- Subject: Re: Help with prepared statment for crosstab
- Date: Tue, 3 Nov 2009 13:21:50 -0500 (EST)
- Message-id: <alpine.BSO.2.00.0911031317580.29390@leary.csoft.net> <text/plain>
On Tue, 3 Nov 2009, Carl Shelbourne wrote:
The SQL shown below works if I do not have any parameters, but when I add the parameters, I get: Caused by: org.postgresql.util.PSQLException: The column index is out of ra nge: 1, number of columns: 0.
The ? parameters you've used are inside a string literal, so they are not considered parameters. Consider:
SELECT 'Does this work?'; The question mark is part of the literal, not a parameter. Kris Jurka
- References:
- Help with prepared statment for crosstab
- From: Carl Shelbourne
- Help with prepared statment for crosstab
- Prev by Date: Re: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
- Next by Date: Re: [NOVICE] Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
- Previous by thread: Help with prepared statment for crosstab
- Next by thread: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list
- Indexes: