Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in meta character into data

 
prriya pratheep
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I want to check against meta data in my query

I have one table with one record with single quote.I want to select all the records without this record contains single quote value

i wrote select * from tab where filename='xxx'' so i am getting error.can anybody help me to sort out this prob

thanks
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Use a PreparedStatement. That way you don't have to worry about special characters.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic