Hi,
I am passing the correct arguments to dump_results, but it appears that
the records are not getting separated with new line.
$maxlen = 500;
$lsep = '\n';
$fsep = '|';
$fh = \*FH;
$rows = $sth-dump_results($maxlen, $lsep, $fsep, $fh);
The records are getting output with the line feed and
Please let me know what you come up with for a final patch and I will
try to incorporate this weekend...
-Original Message-
From: Alexander Foken [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 21, 2006 2:56 AM
To: Martin J. Evans
Cc: dbi-users@perl.org
Subject: Re: [dbi]
Jeffrey Seger schreef:
Dr.Ruud:
JupiterHost.Net:
Dr.Ruud:
Jeffrey Seger:
perl -MData::Dumper -e' print Dumper @INC'
Alternative:
perl -MData::Dumper -e' print Data::Dumper-Dump([EMAIL PROTECTED],
[qw(*INC)])'
Oi, why not much cleaner (code and output):
perl -MData::Dumper -e'
Loo, Peter # PHX [mailto:[EMAIL PROTECTED]:
I am passing the correct arguments to dump_results, but it appears that
the records are not getting separated with new line.
$maxlen = 500;
$lsep = '\n';
$fsep = '|';
$fh = \*FH;
$rows = $sth-dump_results($maxlen, $lsep, $fsep, $fh);
Single
Ok, you're right. Let's stop now as we are not adding to anyone's
knowledge of DBI or DBD::*.
On 4/14/06, Dr.Ruud [EMAIL PROTECTED] wrote:
Jeffrey Seger schreef:
Dr.Ruud:
JupiterHost.Net:
Dr.Ruud:
Jeffrey Seger:
perl -MData::Dumper -e' print Dumper @INC'
Alternative:
perl
Jeffrey Seger schreef:
Ok, you're right. Let's stop now as we are not adding to anyone's
knowledge of DBI or DBD::*.
You keep messing up, so I'll see no more of you.
here were 30+ lines that you should have cut
--
Affijn, Ruud
Gewoon is een tijger.
Hi All,
I am reading in a pipe delimited file and using the while loop and
$sth-execute, I am trying to insert into a table, but am getting the
following error:
Bad int8 external representation (SQL-HY000) (DBD:
st_execute/SQL_Execute err=-1
Here is my sub-routine:
sub
Thanks Ronald.
Peter Loo
Wolters Kluwer Health
(602) 381-9553
-Original Message-
From: Ronald J Kimball [mailto:[EMAIL PROTECTED]
Sent: Friday, April 14, 2006 6:51 AM
To: Loo, Peter # PHX; dbi-users@perl.org
Subject: RE: dump_results
Loo, Peter # PHX [mailto:[EMAIL PROTECTED]:
I am
Single quoted strings do not do backslash substitution (except for \\
and \'). You meant $lsep = \n;
Also, how can I force it so that the output does not have the quotes
for every field?
DBI::neat() won't quote the value if it knows it's a number.
Unfortunately, I'm not sure how to
Hi Jeffrey,
But why does this work when I select the rows into memory and insert
them to the same table? I must be missing something.
Thanks.
Peter
--- Jeffrey Seger [EMAIL PROTECTED] wrote:
Single quoted strings do not do backslash substitution (except for
\\
and \'). You meant
On Fri, 14 Apr 2006 12:13:40 -0700 (PDT), Peter Loo wrote:
Hi Peter
Bad int8 external representation (SQL-HY000) (DBD:
st_execute/SQL_Execute err=-1
You need better diagnostic skills.
Print the data before you insert it.
Print a message saying that it has been inserted.
That way, we know
11 matches
Mail list logo