Shouldn't you be using prepared statements with parameters?


Christoph

-----Original Message-----
From: Eric B. Espares [mailto:eric-cdr@...]
Sent: Tuesday, 23 March 2004 11:25 AM
To: Firebird - Java
Subject: [Firebird-Java] value with an apostrophe
Importance: High


Hi,

Maybe some of you have experience / encounter this problem. I try to insert an employee name into my database (interbase 6.0) for example Marina O'Reili (note the apostrophe ' ) will not be accepted as employee name. I think this is becuase Interbase will mix up the single and double quotes in insert and update statements. Any input on how to solve this problem?

Thanks,
Eric

[Non-text portions of this message have been removed]




_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/Firebird-Java/


* To unsubscribe from this group, send an email to:
Firebird-Java-unsubscribe@yahoogroups.com <mailto:Firebird-Java-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]