FreeTDS Development Group

[Michael Peppler <mpeppler AT peppler.org>]

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