[Chicago-talk] perl DBI ?
richard at rushlogistics.com
Wed Mar 16 09:01:17 PST 2005
when I run these lines of code :
my $T_NO = 12569;
my $dbh =
my $q = "CREATE TABLE IF NOT EXISTS CS_? (
my $sth = $dbh->prepare($q);
from w/in a program I get:
DBD:mysql::st execute failed: You have an error in
your SQL syntax near '12569 (
TYP' at line 2 at ./carr_s.pl line 36.
However if I cut and paste the exact same code and
make it it's own program then execute it, it works
perfectly. Can anyone tell me what's happening and how
I can fix it?
More information about the Chicago-talk