From: Vivek Khera
Date: March 25 1999 4:32pm
Subject: Re: Extracting a given row using Perl API
List-Archive: http://lists.mysql.com/mysql/964
Message-Id: <14074.25877.10304.159771@kci.kciLink.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

>>>>> "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       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/