Re: 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")");
}
[download]

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)

Comment on Re: DBI question Download Code

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')"` [download] Cheers....	[reply] [d/l]