FreeTDS Development Group

[mjn <mjn AT umn.edu>]

Is there a way to sidestep the limitation of 4.2 and dynamic SQL
placeholders?

Or is there a way to use a variable in an SQL statement like this:

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

All of the variable syntax itterations that I know have failed...

Thanks again...

____________________________
Mike Neuharth
ADCS Technology Specialist
http://www.umn.edu/adcs

E-Mail          : mjn AT umn.edu
Page Mail       : 6126486512 AT page.metrocall.com
http://nifty.dsl.visi.com/
____________________________