So then you write your own method called isValueNumeric() that will return true for an empty string. you will then just need to set the type to any and then check on the inside of your methods. Sucks, but its about the only way I know... at the end of the day its going to be some sort of logic...
On 5/11/06, Cutter (CFRelated) <[EMAIL PROTECTED]> wrote: > 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:240283 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
