column index is out of range

Document created by rich_patterson Employee on Jul 16, 2014
Version 1Show Document
  • View in full screen mode
When doing a DB select, each field in your DB profile must be paired with SQL statement.  You must have the same number of fields in your profile, as you do in your select statement.

The same holds true for the parameters in your DB profile.  There must be a corresponding "?" used in the select statement.

Make sure, that when you use parameters, that you do not enclose the ?s in quotation marks.  You may need to format your command differently.  For example: 'dbname=' + ? + ' user=' + ? + ' ....'