This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes is this SQL Stament correct ??? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "is this SQL Stament correct ???" Watch "is this SQL Stament correct ???" New topic

is this SQL Stament correct ???

vikas de
Ranch Hand

Joined: Feb 07, 2001
Posts: 39
hi guys,
stmt=conn.prepareStatement("select * from klasseFaecher"+" where Klasse like'"+klasse+"'"+"where '"+kfach+"'=ja");
this statement displays a "missing operator" error...
please urgent
Frank Carver

Joined: Jan 07, 1999
Posts: 6920
to group two "where" clauses like that you really need a relation; I assume you mean "AND" in this case. You should also be careful to quote all text constants but not column names (is ja really a column name or does kfach contain the column name and 'ja' the value?), and make sure there are spaces round each keyword.
A rewritten version might therefore be:

I also strongly recommend that you get in the habit of specifying the columns to return in your SQL. It makes your software much more robust if the order of the columns in the table changes, or if new columns are added for other purposes. It also makes it much easier for reviewers and other helpers to understand

Read about me at ~ Raspberry Alpha Omega ~ Frank's Punchbarrel Blog
vikas de
Ranch Hand

Joined: Feb 07, 2001
Posts: 39
Thanx a lot...
It is sorta covered in the JavaRanch Style Guide.
subject: is this SQL Stament correct ???
jQuery in Action, 3rd edition