Re: SQL Error??

[Patrick Conner <PWConner@xxxxxxxxxxx>]

You are forgetting the 'AND'/'OR' before the CSTRET variable.

Take a 10 minute break and a deep breath.

RPower@xxxxxxxxxx wrote:

> I'm running this statement against a DB2 file:
> getProps = conn.prepareStatement("SELECT CPROP1 FROM TAXES.CAPMSTR WHERE 
> CRECA <> 'D' AND CPROP1 <> '   ' CSTRET = " + rs.getInt("CSTRET") + " 
> ORDER BY CPROP1");
> and I'm getting the following error when I run the java program:
> [3/29/05 11:04:16:906 NST] 5c2ab602 SystemErr     R java.sql.SQLException: 
> [SQL0104] Token CSTRET was not valid. Valid tokens: FOR WITH FETCH ORDER 
> UNION OPTIMIZE.
> What am I doing wrong?
>
> Ron Power
> Programmer
> Information Services
> City Of St. John's, NL
> P.O. Box 908
> St. John's, NL
> A1C 5M2
> Tel: 709-576-8132
> Email: rpower@xxxxxxxxxx
> Website: http://www.stjohns.ca/
> ___________________________________________________________________________
> Success is going from failure to failure without a loss of enthusiasm. - 
> Sir Winston Churchill

--
Privileged and Confidential.  This e-mail, and any attachments there to, 
is intended only for use by the addressee(s) named herein and may 
contain legally privileged or confidential information.  If you have 
received this e-mail in error, please notify me immediately by a return 
e-mail and delete this e-mail.  You are hereby notified that any 
dissemination, distribution or copying of this e-mail and/or any 
attachments thereto, is strictly prohibited.