All Apps and Add-ons

DB Connect - No value specified for parameter 1

Path Finder

Hello.

Currently, we are trying to get a new SQL query to function within DB Connect.  The SQL query runs against a Postgres database.  Although the SQL query runs fine in batch mode, it is not running so well when setting up the same in rising mode.  Attached is a screenshot of the error message we are receiving.

created_at.png

We tried setting the rising column as "created_at".  Also, we tried adding the following lines to the SQL query:

  • AND created_at > ?
  • ORDER BY created_at ASC

But we receive error messages:

  • org.postgresql.util.PSQLException: No value specified for parameter 1.
  • org.postgresql.util.PSQLException: The column index is out of range: 1, number of columns: 0.

Can someone suggest the best approach to resolving this?

Regards,
Max

 

Labels (2)
0 Karma