Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose)

Поиск
Список
Период
Сортировка
Искать

Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose)

От:
"filippo" <filippo2991@virgilio.it>
Дата:
On 7 Apr, 01:26, "filippo"  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.

Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose)

От:
"filippo" <filippo2991@virgilio.it>
Дата:
On 7 Apr, 01:47, "filippo"  wrote:
> On 7 Apr, 01:26, "filippo"  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% / )

Re: perl DBI: problems searching text strings with ' symbol (es d'ambrose)

От:
"filippo" <filippo2991@virgilio.it>
Дата:
On 7 Apr, 10:13, "filippo"  wrote:

solved, it is a DBD::PgPP bug. I changed to DBD::Pg, now it works fine.
FAQ