in reply to DBI question

Hope I understood your question rigth..but here it goes:
foreach $tmpline (@lines) { $tmpline=~s/[\012\015]//; $dbh->do("INSERT INTO foo VALUES (1, "$tmpline")"); }

if you could provide the format the info is being returned in would help. I assume its in list format ("\n" at end of each)

Replies are listed 'Best First'.
Re^2: DBI question
by cool_jr256 (Acolyte) on Jun 01, 2005 at 19:46 UTC
    As a side note to this, you could have the database handle the incrementation of your first field in the query.
    Hence you'd only need to do this:
    "INSERT INTO foo VALUES('$tmpline')"
    Cheers....