Hi
I'm trying to write a script that reads the data below, parses it, and
then inserts it into the "info" table.
1:Karl Heiz:1:444-555-:441-551-6661:5:1:1:1
2:Helmut Schmidt:1:222-333-1234:222-555-4321:2:1:1:1
3:Udo Lindenberg:3:111-555-1234:111-556-4321:3:0:0:1
4:Peter Frech:2:333-111-1234:33
[>>] ...
Please try (not tested). Placeholders help me a lot:
my $sth_insert = $dbh->prepare('Insert into info (id, name, grade,
phone, cell, house, car)
values (?,?,?,?,?,?,?)')
or die DBI->errstr;
while (){
#---#
#
On Jan 7, 1:50 pm, [EMAIL PROTECTED] (John Moon) wrote:
> [>>] ...
>
> Please try (not tested). Placeholders help me a lot:
>
> my $sth_insert = $dbh->prepare('Insert into info (id, name, grade,
> phone, cell, house, car)
>values (?,?,?,?,?,?,?)')
> or die DBI->errstr;
On Jan 10, 2008 10:50 PM, <[EMAIL PROTECTED]> wrote:
> Only the content of the first 2 fields is displayed:
In your shoes, I would check that 'use warnings' and 'use strict' are
in place, and other basics, then I'd start debugging at the database.
Check out the tracing facility, documented in th
On Jan 7, 12:31 am, [EMAIL PROTECTED] wrote:
> Hi
> I'm trying to write a script that reads the data below, parses it, and
> then inserts it into the "info" table.
>
> 1:Karl Heiz:1:444-555-:441-551-6661:5:1:1:1
> 2:Helmut Schmidt:1:222-333-1234:222-555-4321:2:1:1:1
> 3:Udo Lindenberg:3:111-555