[Dbix-class] row update error

Michael Blanco blanco217 at gmail.com
Fri Mar 5 17:06:10 GMT 2010


I am not using the latest DBIx::Class but i can get that installed and try
again.
However we do alter the session and set the format of Dates to
YYYY-MM-DD

----------------------------
Michael Blanco




On Fri, Mar 5, 2010 at 11:10 AM, Ronald Straight <quinnfazigu at gmail.com>wro=
te:

> On Fri, Mar 5, 2010 at 10:57 AM, Michael Blanco <blanco217 at gmail.com>wrot=
e:
>
>> Hi,
>>  I received the error below running this update:
>> $lineitem->update({
>>             'last_mod_date' =3D> $now,
>>             'creative_rcpt_date' =3D> $now,
>>         });
>>
>> Error with 1239848: DBIx::Class::Relationship::
>> CascadeActions::update(): DBI Exception: DBD::Oracle::st execute failed:
>> ORA-01858: a non-numeric character was found where a numeric was expecte=
d (
>>
>
> You're passing the date in a format (the default "YYYY-MM-DD" from
> DateTime) that Oracle does not expect.
>
> Are you using the latest DBIx::Class and including the
> InflateColumn::DateTime component in your base result class?
>
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive:
> http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20100305/fca=
fab9d/attachment.htm


More information about the DBIx-Class mailing list