This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes Whats wrong with Syntax Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
It's not a secret anymore!