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
i just don't know how to resolve it - other than changing 'K O'Trevan' to
'K O Trevan'
Any ideas appreciated
Steve
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
