Re: Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
- From: ron@xxxxxxxxxxxxx (Ron Savage)
- Date: Thu, 20 Apr 2006 14:39:00 +1000
On Wed, 19 Apr 2006 20:56:39 -0700 (PDT), Peter Loo wrote:
Hi Peter
No Ron. I did not chomp the record, but I am quite certain that it
is not the issue. The field it is complaining about is blank. The
odd thing is that the column it is going into is allowed for NULL
values. I don't know what else to do, but will certainly give chomp
a try.
OK.
You do realize a blank field (empty string) in Perl is /not/ a database null,
right?
To get a null use Perl's undef.
Yes, I am only testing with one record.
I guessed chomp may be relevant as soon as I thought it died on the first line.
--
Ron Savage
ron@xxxxxxxxxxxxx
http://savage.net.au/index.html
.
- References:
- Prev by Date: Re: Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
- Next by Date: Tiny typo in docs for DBI.parse_dsn()
- Previous by thread: Re: Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
- Next by thread: RE: Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
- Index(es):
Relevant Pages
|
