The default null value for dates is already 1/1/100, so you don't need to explicitley set it.
But the default value for a TransferObject when it is created in Now(), so if you want it to be inserted as null, you need to explicitley set it. See: http://docs.transfer-orm.com/wiki/Handling_Null_Values.cfm Mark On Tue, Sep 21, 2010 at 1:53 PM, spiraldev <[email protected]> wrote: > I having issues with the Nullvalue I have tried adding the nullvalue > attribute I set it to 1/1/0100 but when I insert into the DB it's > setting the column to now() > Here is my object > <object name="Event" table="tblRegistrationEvent" > decorator="lib.com.ER.data.bean.transfer.registration.Event"> > <id name="registrationEventID" type="UUID" > generate="true" /> > <property name="registrationIDFK" > type="string" > column="registrationIDFK" /> > <property name="eventIDFK" type="string" > column="eventIDFK" /> > <property name="eventRoleIDFK" type="string" > column="eventRoleIDFK" /> > <property name="accessCode" type="string" > column="accessCode" /> > <property name="Cost" type="numeric" > column="Cost" /> > <property name="completeDate" > nullable='true' nullvalue='1/1/0100' > type="date" column="completeDate" /> > <property name="createdBy" > ignore-update='true' type="string" > column="createdBy" /> > <property name="createDate" > ignore-update='true' type="date" > column="createDate" /> > <property name="updatedBy" type="string" > column="updatedBy" /> > <property name="updateDate" type="date" > column="updateDate" /> > </object> > > Any thoughts? > > -- > Before posting questions to the group please read: > > http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer > > Try out the new Transfer ORM Custom Google Search: > http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 > > You received this message because you are subscribed to the Google Groups > "transfer-dev" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected]<transfer-dev%[email protected]> > For more options, visit this group at > http://groups.google.com/group/transfer-dev?hl=en > -- E: [email protected] T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) - Nov 18, 19 - Melbourne Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com -- Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer Try out the new Transfer ORM Custom Google Search: http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8 You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en
