| Subject | Re: [firebird-support] using a parameter containing a single quote |
|---|---|
| Author | Woody |
| Post date | 2013-10-15T19:20:43Z |
I think Delphi has a quoted string function which you can
use when setting the parameter. However, all of the database components I’ve
ever used should automatically provide that when you set a parameter to a quoted
string. Which components are you using to run the query and how are you setting
the parameter?
Woody (TMW)
From: russell@...
Sent: Tuesday, October 15, 2013 12:17 PM
Subject: [firebird-support] using a parameter containing a single
quote
running inside Delphi if I use the query
select * from person where email = :email
if the email address is a@... then it is fine, but if the email contains
an apostrophe a'oneill@b,com then it fails to locate the record. Even if I use a
string replace rather than a parameter it fails.
In FlameRobin
select * from person where email = 'a''oneill@...'
is fine.
any ideas?