Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

quick SQL help please

 
Amanda Leigh
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am getting the error "Identifier or Quoted Identifier Expected" when i try to execute this in my code, however it works fine in SQL Plus or SQL Worksheet. What am I missing?



[edited to add code tags]
[ December 12, 2004: Message edited by: Jeanne Boyarsky ]
 
Jim Cheng
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You need to handle special characters properly in Java like single/double quotes.

Could you post the java code which actually embed the SQL statement?

Jim
 
Stefan Wagner
Ranch Hand
Posts: 1923
Linux Postgres Database Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you ever thought about indentation?


I never saw that syntax before:

but I'm not an SQL-Expert, nor do I know every RDBMS.
[ December 11, 2004: Message edited by: Stefan Wagner ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I added the code tags as suggested by Stephen. (The indentation was already there.)

Amanda, for the future, code tags are one of the UBB buttons directly below the edit window.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic