Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

missing equal sign

 
Aniruddha Dhar
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


i am new at this and trying to understand different things.can't get this one right.please help....
thanks in advance...
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34973
379
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Try putting a System.out.println() that writes out the sql and run it against the sql command line. This will tell you which part of the SQL has an error.

Also, consider using a Prepared Statement so you don't have so much string concatenation and the query is safer.
 
Bill Clar
Ranch Hand
Posts: 163
Eclipse IDE Java Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is "c/o" a valid database field name?
 
Rob Spoor
Sheriff
Pie
Posts: 20669
65
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It is if you enclose it properly. MS SQL Server and Access use [], MySQL uses ``, most others use "".
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic