aspose file tools*
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 Soft Skills this week in the Jobs Discussion 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...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Whats wrong with Syntax