File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

What is error in query

 
Pradeep
Ranch Hand
Posts: 49
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
update wk_share set deleted='Y',where fund_id="" and share_id="";
please tell me error in above query
[ November 23, 2006: Message edited by: Bear Bibeault ]
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33694
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Pradeep,
For the future, note that we have a JDBC forum for SQL questions.

What error do you get? Do you want to check for empty strings or nulls?
 
A knibbs
Ranch Hand
Posts: 158
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
this is more of an sql problem, but I think the problem is the comma before the word where. (You should use an sql forum for this, not to mention including details about which db etc etc)
 
Merrill Higginson
Ranch Hand
Posts: 4864
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Also, you've used single quotes for one comparison and double quotes for two other comparisons. Some databases only accept single quotes to denote literals.

If you're trying to check for null, you should use the expression:

fund_id is null
[ November 23, 2006: Message edited by: Merrill Higginson ]
 
Pradeep
Ranch Hand
Posts: 49
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks it helped me
 
Pradeep
Ranch Hand
Posts: 49
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks it helped me
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic