Hi Chris,

I will try prepared statements with parameters. Thanks for sharing your idea
and to Helen B. as well.

Cheers,
Eric

----- Original Message -----
From: "Chris Donges" <chrisd@...>
To: <Firebird-Java@yahoogroups.com>
Sent: Tuesday, March 23, 2004 11:59 AM
Subject: RE: [Firebird-Java] value with an apostrophe


>
> 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]
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>