Not knowing what your data is, but could it potentially contain something like a line feed or a carriage return? That would come up as a 0 length string that still has length...
Eric -----Original Message----- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Thursday, July 19, 2007 12:14 PM To: CF-Talk Subject: Re: How do I properly check for an empty string? I tried <cfif Len(trim(instructorid)) AND Len(trim(lastname)) AND Len(trim(firstname)) And rows of empty strings still get thru to <cfelse> and added to the query. There's somethin I'm not seeing here... Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284168 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
