List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:March 25 1999 2:41pm
Subject:Re: Extracting a given row using Perl API
View as plain text  
>>>>> "WRM" == William R Mattil <wrmattil@stripped> writes:

WRM> works while the following does not;

WRM> my $sth = $dbh->prepare("SELECT first,last,phone FROM $table WHERE
WRM> phone_book.last=$FOO");

WRM> Where $FOO = 'Blow'; And the error message returned is as follows:


Try this:

print "SELECT first,last,phone FROM $table WHERE phone_book.last=$FOO";

and see if you think that's a valid SQL statement to do what you
want.  I don't think it will be.


								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/
Thread
Extracting a given row using Perl APIWilliam R. Mattil25 Mar
  • Re: Extracting a given row using Perl APIAldrian Gintingsuka25 Mar
  • Re: Extracting a given row using Perl APIVivek Khera25 Mar
  • Re: Extracting a given row using Perl APIChris25 Mar
  • Re: Bug reportFred van Engen16 Feb
Re: Extracting a given row using Perl APIDerick H Siddoway25 Mar
Re: Extracting a given row using Perl APIVivek Khera25 Mar