Hi Ron,
Do you mean plug in the work undef before doing the INSERT?
Thanks.
Peter Loo
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 19, 2006 9:39 PM
To: List - DBI users
Subject: Re: Bad int8 external representation (SQL-HY000)(DBD:
st_execute
]; List - DBI users
Subject: Re: Bad int8 external representation (SQL-HY000)(DBD:
st_execute/SQLExecute err=-1)
It's a numeric field and you are trying to insert an empty string rather
than undef (equivalent to null).
When you queried the other database and had the values in memorynot
written
On Thu, 20 Apr 2006 07:51:24 -0700, Loo, Peter # PHX wrote:
Hi Peter
Do you mean plug in the work undef before doing the INSERT?
Yes. Off the top of my head (add error checks!):
$sql = 'insert into table_x (column_y, column_z) values (?, 99)';
$sth = $dbh - prepare($sql);
$sth -
.
Peter Loo
Wolters Kluwer Health
(602) 381-9553
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 20, 2006 4:14 PM
To: List - DBI users
Subject: RE: Bad int8 external representation (SQL-HY000)(DBD:
st_execute/SQLExecute err=-1)
On Thu, 20 Apr 2006 07:51:24
Ron Savage said:
On Thu, 20 Apr 2006 07:51:24 -0700, Loo, Peter # PHX wrote:
Hi Peter
Do you mean plug in the work undef before doing the INSERT?
Yes. Off the top of my head (add error checks!):
$sql = 'insert into table_x (column_y, column_z) values (?, 99)';
$sth = $dbh -
On Thu, 20 Apr 2006 16:33:14 -0700 (PDT), William R. Mussatto wrote:
Hi William
$sql = 'insert into table_x (column_y, column_z) values (?, 99)';
$sth = $dbh - prepare($sql); $sth - execute(undef); -- Cheers
Minior change: should it not be:
$sth - execute((undef));
Well, no. Firstly I
On Thu, 20 Apr 2006 16:21:29 -0700, Loo, Peter # PHX wrote:
Hi Peter
Yes, thanks. I have it working now. Now I am working on the
UPDATE from a SELECT. I am having problem with char columns. I am
working on a routine that will identify the columns that require
quotes and dynamically plug
testing with one record.
Thanks.
Peter
--- Ron Savage [EMAIL PROTECTED] wrote:
On Tue, 18 Apr 2006 11:44:50 -0700, Loo, Peter # PHX wrote:
Hi Peter
[unixODBC]ERROR: copy: line 1, Bad int8 external representation
(SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
Line 1, eh? First attempt
external representation
(SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
Line 1, eh? First attempt to insert data? Did you try chomp-ing the
line?
--
Cheers
Ron Savage, [EMAIL PROTECTED] on 19/04/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian
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
Hello All,
I am attempting to INSERT into a table while reading in from a piped
delimited file and am getting the following error:
[unixODBC]ERROR: copy: line 1, Bad int8 external representation
(SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
The destination table (Netezza) layout is (38
On Tue, 18 Apr 2006 11:44:50 -0700, Loo, Peter # PHX wrote:
Hi Peter
[unixODBC]ERROR: copy: line 1, Bad int8 external representation
(SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
Line 1, eh? First attempt to insert data? Did you try chomp-ing the line?
--
Cheers
Ron Savage, [EMAIL
12 matches
Mail list logo