That's cool, unless the argument of your set function is numeric (as one of mine is), in which case I get an error "The argument [arg] passed to function Set[arg]() is not of type numeric." I could set the argument's type attribute to 'any', but then there's no catch for the wrong data type being passed into the var.
Ben Nadel wrote: > I believe that CF will treat SQL nulls as empty strings. > > > ....................... > Ben Nadel > Web Developer > Nylon Technology > 350 7th Avenue > Floor 10 > New York, NY 10001 > 212.691.1134 > 212.691.3477 fax > www.nylontechnology.com > > "You know, like nunchuck skills, bowhunting skills, computer hacking > skills... Girls only want boyfriends who have great skills." > - Napoleon Dynamite > -----Original Message----- > From: Cutter (CFRelated) [mailto:[EMAIL PROTECTED] > Sent: Thursday, May 11, 2006 3:55 PM > To: CF-Talk > Subject: DAO CFC and NULL values > > I've seen the following code used in 'read' methods of a DAO CFC: > > <cfif myquery.recordCount> > <cfloop index="col" list="#getit.columnlist#"> > <cfinvoke component="#bean#" method="Set#col#"> > <cfinvokeargument name="#col#" value="#getit[col][1]#"> > </cfinvoke> > </cfloop> > </cfif> > > What do you do if the value returned for that column is sql NULL? > > Cutter > ________ > http://blog.cutterscrossing.com > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240278 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54