in reply to DBI:mysql

I would try using placeholders. Especially when you know that you're inserting four data fields every time. Makes it easy. Check out this

peppiv

Replies are listed 'Best First'.
Re: Re: DBI:mysql
by Dalin (Sexton) on Apr 15, 2002 at 13:15 UTC
    If you check out the q_marks sub, you'll see that I'm inserting the proper amount of place holders for each data line. the $dbh->trace is confirming that the sub is working correctly. I'm not including column names in the insert statement because each data line has the proper amount of fields for each table I'm inserting into. I know this because the data files are direct dumps from a previous dbase.