From: Shashank Date <shanko_date@...>
Date: 2004-12-31T09:00:03+09:00
Subject: Re: Finding out what row DBI chokes on?

Hi Francis,

--- Francis Hwang <sera@fhwang.net> wrote:

> Some times I deal with a legacy table with screwy
> datetime info, so you 
> get fields that in MySQL are '0000-00-00' or other
> kinds of invalid 
> values ... I pull this out with DBI I get an
> ArgumentError that simply 
> says "argument out of range", which I believe is
> being caused by DBI 
> calling Time.gm( 0, 0, 0, 0, 0, 0 ) or something
> like that.

Is it possible to do validation at the SQL level
itself? What does the SQL generates the result look
like?

-- shanko




		
__________________________________ 
Do you Yahoo!? 
Dress up your holiday email, Hollywood style. Learn more. 
http://celebrity.mail.yahoo.com