File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Problem in  meta character into data 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 "Problem in  meta character into data" Watch "Problem in  meta character into data" New topic

Problem in meta character into data

prriya pratheep

Joined: Jun 10, 2008
Posts: 22

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

Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

Use a PreparedStatement. That way you don't have to worry about special characters.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
I agree. Here's the link:
subject: Problem in meta character into data
It's not a secret anymore!