Subject | Re: [firebird-support] Escape Character for apostrophe? |
---|---|
Author | Milan Babuskov |
Post date | 2004-05-05T14:12:14Z |
barfingdog_2004 wrote:
insert into player values ('Shaquille O''neal');
Or just use parameterized statement like this:
st->Prepare("insert into players values (?)");
st->Set(1, "Shaquille O\'neal");
firebird-support@yahoogroups.com
--
Milan Babuskov
http://fbexport.sourceforge.net
> How do you escape an apostrophe, so it can beUse another apostrophe, like this:
> part of the text in an insertion operation?
insert into player values ('Shaquille O''neal');
Or just use parameterized statement like this:
st->Prepare("insert into players values (?)");
st->Set(1, "Shaquille O\'neal");
> I can read articles on the support news serverYou can use any e-mail client to post messages. Just send them to
> mirror, but I have to go through Yahoo's inferior
> interface (no spell checker, no indentation when
> reading posts, no grouping with stepped
> indentation of related posts) in order to post.
firebird-support@yahoogroups.com
--
Milan Babuskov
http://fbexport.sourceforge.net