perl DBI: problems searching text strings with ' symbol (es d'ambrose)
hello,
if I try to insert text like
$dbh->quote(qq/d'ambrose/);
when I try to search names with character lile ', I get this error
DBD::PgPP::st execute failed: Unknown message type: '' at C:/Perl/
site/lib/DBD/
PgPP.pm line 730
I really need to store and select names with ' character, how can I
do?
Thanks,
Filippo
On 7 Apr, 01:26, "filippo" <filippo2...@virgilio.it> wrote:
hello,
if I try to insert text like
$dbh->quote(qq/d'ambrose/);
when I try to search names with character lile ', I get this error
I forgot to say that I need LIKE and %. I tried to use placeholders
but nothing changes.
On 7 Apr, 01:47, "filippo" <filippo2...@virgilio.it> wrote:
On 7 Apr, 01:26, "filippo" <filippo2...@virgilio.it> wrote:
just to clarify:
I can insert text into database. My problem are the SELECT query like
this
WHERE name LIKE $name
$name = $dbh->quote(qq/ d'am% / )