Re: Extracting a given row using Perl API

[Vivek Khera]

>>>>> "DHS" == Derick H Siddoway <Derick.H.Siddoway@stripped>
> writes:

DHS> What you probably want to do is something like this:
DHS> 	my $sth = $dbh->prepare("SELECT first,last,phone FROM $table WHERE
DHS> 	phone_book.last='$FOO'");

DHS> OR store the value in $FOO like this

DHS> 	$FOO = "'Blow'";

Or better,

 $FOO = $dbh->quote("Blow");

which will work for any value of "Blow", including those that contain
embedded ' characters and backslashes.


								v.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       [phone]
PGP & MIME spoken here            http://www.kciLink.com/home/khera/