Re: Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)



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.

Yes, I am only testing with one record.

Thanks.

Peter

--- Ron Savage <ron@xxxxxxxxxxxxx> 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 to insert data? Did you try chomp-ing the
line?

--
Cheers
Ron Savage, ron@xxxxxxxxxxxxx on 19/04/2006
http://savage.net.au/index.html
Let the record show: Microsoft is not an Australian company





Peter Loo
Worldwide Consulting, Inc.
Phoenix, Arizona
U.S.A.
.



Relevant Pages

  • Re: Alonso Whinging....
    ... turned it into some kind>>> of shock horror driver whinge story. ... emphasized he wasnt complaining and thinks he can still win the ... Until we see minutes of a meeting with Ron Dennis or Alonso throws his ...
    (rec.autos.sport.f1)
  • Re: Alonso Whinging....
    ... drivers want to be N01 right now, and youve turned it into some kind ... wasnt complaining and thinks he can still win the DWC. ... Until we see minutes of a meeting with Ron Dennis or Alonso throws his ...
    (rec.autos.sport.f1)
  • Re: [9fans] sources down?
    ... warning: complaining about something you get for free is ... Unless, of course, you are also offering to help ...
    (comp.os.plan9)
  • Re: is this the same letter from singer everyone got?
    ... Apparently this woman has a group of friends that she talked into ... also complaining about Ron to Singer and several other companies ...
    (alt.sewing)
  • Re: how many bugs do you find and correct during TDD?
    ... Ilja Preuß wrote: ... > I didn't understand Ron to be complaining, ... I would reference studies where people who think they ...
    (comp.object)