I always use Len(Trim()) There can be whitespace thrown in there, I think IE on Mac when the form is multipart/form-data throws line feeds in the form field values.
I also find it good practice to liberally use Trim() when dealing with any outside data - form or legacy DB, especially when inserting into a DB. >>> [EMAIL PROTECTED] 09/07/02 12:08PM >>> > 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? What's unreliable about it? Are there potentially spaces in that field that throw it off? I'd suggest trying this instead: <cfif NOT Len(Trim(form.fieldname))> Do Something. </cfif> Regards, Dave. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
