How would be the best way to use DBIx::Recordset to insert multiple records
of data like such:
I have a textarea that will contain a list of items, one per line, separated
by newlines...the other data on the page (category, etc...) will remain the
same, but I need to insert a record for every row of items...how should I do
this using DBIx::Recordset??
I've tried several methods, including split()ing the $fdat{'items'} field on
newlines and doing an Insert{\%fdat}in a foreach $item (@items) loop...this
just succeeds in putting NULL's and 0's in every field...once for every item
:-)
Any suggestions or help would be appreciated! :-)
Jon Brisbin
of data like such:
I have a textarea that will contain a list of items, one per line, separated
by newlines...the other data on the page (category, etc...) will remain the
same, but I need to insert a record for every row of items...how should I do
this using DBIx::Recordset??
I've tried several methods, including split()ing the $fdat{'items'} field on
newlines and doing an Insert{\%fdat}in a foreach $item (@items) loop...this
just succeeds in putting NULL's and 0's in every field...once for every item
:-)
Any suggestions or help would be appreciated! :-)
Jon Brisbin