This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem in  meta character into data" Watch "Problem in  meta character into data" New topic
Author

Problem in meta character into data

prriya pratheep
Greenhorn

Joined: Jun 10, 2008
Posts: 22
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

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: http://aspose.com/file-tools
 
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?