Re: [GENERAL] stored queries and quoted strings

2007-04-02 Thread Ragnar
On fös, 2007-03-30 at 00:31 -0700, filippo wrote: > Hello, > > I have a strange problem with stored queries like this > > $sql = qq/ > SELECT city, country > FROM countries > WHERE city LIKE ? > ORDER BY city >/; > $sthCity= $dbh->prepare($sql);

[GENERAL] stored queries and quoted strings

2007-04-02 Thread filippo
Hello, I have a strange problem with stored queries like this $sql = qq/ SELECT city, country FROM countries WHERE city LIKE ? ORDER BY city /; $sthCity= $dbh->prepare($sql); my $tempCity = $dbh->quote("n%"); $sthCity->execute($tempCity); m