> The cfparam tag was trying to set default values (like > zero) for columns that may not always be returned from the > query. That did not work, but the IsDefined did work.
So what code did you end up using to "set this default"? I ask because nothing I am envisioning works under CF9. No error, just that attempts to modify the query object (without using query functions, ..) are essentially ignored ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346005 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
