Hi Brian, What you need to do is to set an integer value that represents the null value in coldfusion. You can do this by setting the nullvalue attribute in your property. In your case:
<property name="milliseconds" type="numeric" nullable="true" nullvalue="-9999" /> This tells transfer that it should insert a null value in the database if and only if the property's value is -9999. The default nullvalue for integers is 0, and that's why transfer inserts a null in the database when you have 0 milliseconds. You need to have nullable set to true in order for nullvalue to have any effect. Does you milliseconds property need to have nulls? You may be interested in the following documentation also: http://docs.transfer-orm.com/wiki/Default_Property_Values.cfm http://docs.transfer-orm.com/wiki/Custom_Methods.cfm HTH, Pedro. On Aug 4, 9:37 pm, Brian FitzGerald <bmfitzgera...@gmail.com> wrote: > Hey Jason, > > Thanks a lot for chiming in. Unfortunately after setting nullable to false > on that property in the transfer config, it still inserts NULL. This is > what my config node looks like: > > <object name="CourseScript" table="courseScript" > decorator="model.businessObjects.CourseScriptDecorator"> > <id name="courseScriptId" type="numeric" /> > <property name="courseId" type="numeric" /> > <property name="scriptId" type="numeric" /> > <property name="milliseconds" type="numeric" nullable="false" /> > </object> > > Any other thoughts? > > Thanks, > Brian -- 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 transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en