Actually, if your using the expr3 variable on <cfoutput query="queryname"> , just be mindful of where the var is coming from- either from a query column or as locally cfset var... always helps to be a little bit more explicit.
-----Original Message----- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 1:35 PM To: CF-Talk Subject: RE: CFIF and null values For the record, this worked. Apparently, changing the variable name is required of CF can't keep track ot it. -----Original Message----- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 1:12 PM To: CF-Talk Subject: RE: CFIF and null values Try this, works for me all the time <cfif trim(queryname.expr3) is ""> <cfset newvar = 0> <cfelse> <cfset newvar = queryname.expr3> </cfif> <cfoutput>#newvar#<cfoutput> -----Original Message----- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 12:58 PM To: CF-Talk Subject: RE: CFIF and null values <cfif NOT len(trim(expr3))><CFSET expr3 = 10></cfif> <cfoutput>expr3=[#expr3#]<br></cfoutput> Results in: expr3=[] on the web page. I can see the NULL in the database. Datatype is SQL-Server numeric. I am mystified why this does not work???? Maybe a typo?? -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, March 24, 2006 12:49 PM To: CF-Talk Subject: Re: CFIF and null values <cfif NOT len(trim(expr3))> will ctach NULLs Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236191 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
