wood burning stoves 2.0*
The moose likes JDBC and the fly likes Whats wrong with Syntax Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Whats wrong with Syntax" Watch "Whats wrong with Syntax" New topic
Author

Whats wrong with Syntax

Laurel Hardy
Greenhorn

Joined: Feb 19, 2004
Posts: 3
tmpsql="Select st,ed from Queens "
+"Where Pr=" + lPr + "and SSN=" + lssn;

where lpr and lssn are of Type Int.
The Columns Pr and SSN are also of the Type int.
Murat Balkan
Ranch Hand

Joined: Sep 10, 2002
Posts: 127
tmpsql="Select st,ed from Queens "
+"Where Pr=" + lPr + " and SSN=" + lssn;
(there must be a space before and)
Laurel Hardy
Greenhorn

Joined: Feb 19, 2004
Posts: 3
Thanks.....Balakan..It worked Man....What a catch...
 
jQuery in Action, 2nd edition
 
subject: Whats wrong with Syntax
 
Similar Threads
problem reading the mail Attachment
help on Licence Plate Recognition
values are repeated in pdf
Printing a text file to a printer
Printing a file using Shell Script in Unix env called from a Java Application