This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Cattle Drive and the fly likes jdbc and apostrophes 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 » This Site » Cattle Drive
Bookmark "jdbc and apostrophes " Watch "jdbc and apostrophes " New topic
Author

jdbc and apostrophes

Pauline McNamara
Sheriff

Joined: Jan 19, 2001
Posts: 4012
    
    6
For the jdbc assignments is it considered overkill to deal with titles, stars or descriptions with ' in the text? For example, a title like My Best Friend's Dog or a star like Rosie O'Donnell breaks the SQL. Should those ' be escaped first or does one KISS it off?


Thanks,
Pauline
Marilyn de Queiroz
Sheriff

Joined: Jul 22, 2000
Posts: 9044
    
  10
I think it is a good thing if your code can handle that situation, but it's not required to pass the assignment.


JavaBeginnersFaq
"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
 
Consider Paul's rocket mass heater.
 
subject: jdbc and apostrophes
 
Similar Threads
Loading file data into a DB2 table using java
Need guidance for SCJD exam preparation
"Invalid Packet length" Error
java sql parser
Need help to write a bot to collect data from internet.