4.2 limitation...

Michael Peppler mpeppler at peppler.org
Tue Jan 2 14:51:49 EST 2001


mjn writes:
 > >   As has been mentioned, single quoted strings are not expanded.  That is
 > > just the way Perl works.
 > 
 > I was trying to change the quotes but I just hadn't thought to change the
 > quotes on the /whole/ string.
 > 
 > >   Plus, you aren't quoting the string.  It must be a valid SQL statement,
 > > and SQL strings must be quoted:
 > > 
 > > $state="ca";
 > > my $sth = $dbh->prepare("SELECT * FROM authors WHERE state = \"$state\"");
 > 
 > I actually got it to work this way too:
 > 
 > $state='"ca"';
 > my $sth = $dbh->prepare("SELECT * FROM authors WHERE state = $state")
 > 
 > Which is better, I don't really know.  Probably yours.

You can also do:

    $state = 'ca';
    my $sth = $dbh->prepare("SELECT * FROM authors WHERE state = '$state'");


or use the q() and qq() operators, like so:

    my $sth = $dbh->prepare(qq(SELECT * FROM authors WHERE state = "$state"));

Michael
-- 
Michael Peppler - Data Migrations Inc. - mpeppler at peppler.org
http://www.mbay.net/~mpeppler - mpeppler at mbay.net - AIM MPpplr
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: ase-linux-list at isug.com



More information about the FreeTDS mailing list