How about using the TRIM function?

<cfif LEN(TRIM(fieldname)) LTE 0>

-----Original Message-----
From: cc [mailto:[EMAIL PROTECTED]] 
Sent: Friday, September 06, 2002 8:52 PM
To: CF-Talk
Subject: testing for nulls

we are using a <cfif len(fieldname) LTE 0> to test for null values but
it's
proving unreliable.  Any ingenious ideas or thought on this dilemma?

Thank you

Chris Christianson




______________________________________________________________________
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to