| 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: | 2009-11-03 18:21:50 |
| Message-ID: | alpine.BSO.2.00.0911031317580.29390@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Wood | 2009-11-03 18:29:08 | Re: [NOVICE] Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list |
| Previous Message | Kris Jurka | 2009-11-03 18:16:15 | Re: Bug - DatabaseMetaData.getCatalogs() was [Novice] Can't get list of databases with \list |