On Wed, 15 Jul 2009, Peter Hopfgartner wrote: > I've upgraded to the current ezComponets. PersistentObject is at 1.6. > > I have some problems writing data back to the database. In some cases I > get the following a stack trace, as that appended to the end of the > mail. Oracle is complaining that for a given value for a numeric field > is not numeric or a string not parseable as a string. > > If I echo the query, as it in persistent_session.php:689, it is > > UPDATE "REQUISITION_ITEM" SET "RQI_QTY" = :ezcValue1, "ORP_ID" = > :ezcValue2, "ORS_ID" = :ezcValue3 WHERE > "RQI_ID" = :ezcValue4 > > and the content of ezcQuery::boundValues is > > ( > [:ezcValue1] => 3 > [:ezcValue2] => 25 > [:ezcValue3] => 20 > [:ezcValue4] => 41 > ) > > The database table is > > CREATE TABLE "PLANTMAP"."REQUISITION_ITEM" > ( "RQI_ID" NUMBER(*,0) NOT NULL ENABLE, > "RQI_QTY" NUMBER NOT NULL ENABLE, > "ORP_ID" NUMBER DEFAULT 40, > "ORS_ID" NUMBER DEFAULT 20 NOT NULL ENABLE, > .... > ) > > > As said before, for some of the load saves on other objects everything > works fine.
The trick is to figure out for which information it doesn't work. Are you sure you always have numbers in those fields? Perhaps it's a string containing a number sometimes. Instead of print_r() you could use var_dump() as that will show you the type as well. with kind regrds, -- Derick Rethans eZ components Product Manager eZ systems | http://ez.no -- Components mailing list Components@lists.ez.no http://lists.ez.no/mailman/listinfo/components
