Helen- There is a separate JDBC list for related questions that I suggest you use in the future.
A code sample is needed for a really good answer, but I'll make a guess. This message is probably telling you that you are either trying to set a value in a where clause that has a higher index than the number you prepared. (eg: you have two columns constrained and tried to set a third.) Or, you are trying to read a column from the resultset that has a higher index than those you defined when preparing the statement. (eg: your query returns two fields and you're asking for a third.) Your SQL statement may look fine, but you're either setting or getting something that it doesn't have. -Nick -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of helen liu Sent: Monday, January 13, 2003 11:44 AM To: [EMAIL PROTECTED] Subject: [ADMIN] query probelm Hello, I am new in postgresql. sorry if I may ask simple question. I got error message when I pass sql statement into database through JDBC. the error msg is: "connect and execute query: The column index is out of range." I check the sql statement string passed into db, it looks fine. I have no idea what is going wrong. any help is highly appreciated. Helen Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
