[Chicago-talk] perl DBI ?

[Andy Lester]

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 =
> DBI->connect("DBI:mysql:database=carr_search;192.168.0.1",user,password);
> 
> 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?

xoa

-- 
Andy Lester => andy at petdance.com => www.petdance.com => AIM:petdance