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 Incorrect syntax near ','. 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 "Incorrect syntax near Watch "Incorrect syntax near New topic
Author

Incorrect syntax near ','.

R Naijat
Ranch Hand

Joined: Nov 01, 2011
Posts: 40
Hi all,
I use MS SQL Server. I don't know what I'm doing wrong in the following query.

I receive this error:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ','.


select (table.isNegative, matchType.code, keyword.id, status.code, keyword.lastUpdate, syncStatus.code)
from table kwd, matchType, keyword k, status, syncStatus
where k.id=65648093
and kwd.umbrellaId=1080
and matchType.code='P'
and status.code='A'
and syncStatus.code='B';

Any help would be greatly appreciated.

Paul Clapham
Sheriff

Joined: Oct 14, 2005
Posts: 19726
    
  10

I'm going to guess that "table" is a reserved word in your database. (Do you really have a table named "table"?)
R Naijat
Ranch Hand

Joined: Nov 01, 2011
Posts: 40
Found the problem! Needed to remove the open and close () from the beginning and end of SELECT statement which got rid of the first error. Then I got "cannot be bound" error which I resolved when I replaced the actual table names with the names which was defined in from statement: kwd for table and k for keyword.

Thanks anyway.
 
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: Incorrect syntax near ','.
 
It's not a secret anymore!