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