[Chicago-talk] perl DBI ?
andy at petdance.com
Wed Mar 16 09:12:47 PST 2005
On Wed, Mar 16, 2005 at 09:01:17AM -0800, Richard Reina (richard at rushlogistics.com) wrote:
> when I run these lines of code :
> my $T_NO = 12569;
> use DBI;
> my $dbh =
> my $q = "CREATE TABLE IF NOT EXISTS CS_? (
You're trying to bind a variable to a table name somehow? So it's
CREATE TABLE IF NOT EXISTS CS_12569
I don't think that's legal. Bind variables are only valid for fields.
Instead, embed the $T_NO directly into the SQL.
I'm concerned that you're making a bunch of identical tables, though.
Why is that?
Andy Lester => andy at petdance.com => www.petdance.com => AIM:petdance
More information about the Chicago-talk