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