Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
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

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
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