in reply to Re: Re: DBD::Pg INSERT enlightenment
in thread DBD::Pg INSERT enlightenment
I've slightly modified the code you posted for the array, and it's working pretty well. Here's what I've done...
print "\nEnter a brief description: "; my $desc = join('', <STDIN>); my $pg_array = join ('', map {split ' '} $desc); $pg_array =~ s/, $//; $pg_array = "{$pg_array}"; print "$pg_array\n\n"; $sth = $dbh->prepare(" INSERT INTO $tbl_name (product_id, model_number, description) VALUES (?, ?, ?) "); $sth->execute($prod_id, $mod_num, $pg_array); $sth->finish();
I really cannot afford seperate columns, as the description will contain more than just CPU and MHZ. My plan is to use only ONE table for CPU, RAM, HD, Monitor, case, NIC, MB, and videocard.
Thanks.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: DBD::Pg INSERT enlightenment
by beppu (Hermit) on Feb 06, 2001 at 12:30 UTC |