Did that, no spaces ... -----Original Message----- From: Rob Wilkerson [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 12:48 PM To: CF-Talk Subject: Re: CFIF and null values
I use len ( trim ( the_null_value ) ) often and it's never failed. Any chance the value returned is actually 'NULL'? Try dumping expr3, but wrap the output with some sort of delimiter so you can tell whether there's any space, maybe... On 3/24/06, Richard Colman <[EMAIL PROTECTED]> wrote: > I have a null value being returned from a query. I would like to catch > it and give it a value before proceeding. > > So, assuming that CF returns a null value as a null string, I tried > the > following: > > <cfif len(expr3) eq 0> > <CFSET expr3 = 0> > </cfif> > > Also > > <cfif expr3 = ""> > <CFSET expr3 = 0> > </cfif> > > However, neither of these are working. > > Any suggestions appreciated. > > Rick Colman > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236173 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
