File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC 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

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
Multiple or Single updates from JTABLE?
How to save value from ResultSet as a single value in database
Joining Two Tables
Need help in GUI
B&S: RandomAccessFile contains one file pointer?