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