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:236170 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
