On Wed, Oct 02, 2002 at 09:25:43AM -0700, nkuipers wrote:
> Could you also use quote() for this?
Yes, $dbh->quote() can also be used for quoting strings. I generally don't
suggest it because it's more awkward and makes for less readable code than
placeholders.
Michael
--
Administrator
>Use placeholders:
Could you also use quote() for this?
"Ain't no blood in my body, it's liquid soul in my veins"
~Roots Manuva
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Subject: Re: mysql syntax problem
10/02/02 09:33
On Wed, Oct 02, 2002 at 09:06:16AM +0100, [EMAIL PROTECTED] wrote:
> when i query a mysql db within a perl script
> this works fine...
> $sth = $dbh->prepare ("SELECT venue from base1 WHERE op = 'K Trevan'");
>
> this doesn't..
> $sth = $dbh->prepare ("SELECT venue from base1 WHERE op = 'K O'Trev
Hi all
when i query a mysql db within a perl script
this works fine...
$sth = $dbh->prepare ("SELECT venue from base1 WHERE op = 'K Trevan'");
this doesn't..
$sth = $dbh->prepare ("SELECT venue from base1 WHERE op = 'K O'Trevan'");
i know the issue is 'K O'Trevan' in that the 2nd ' completes
