Andrew Because CF is typeless, meaning that you dont have to declare if a variable is a number or a string, NULL does not really apply.
If the variable is defined, then it has a value. easy ----------- <cfif myVar EQ ""> Check for length ---------------- <cfif Len(myVar) EQ 0> or <cfif NOT Len(myVar)> check for a number -------------- <cfif Val(myVar) EQ 0> or <cfif NOT Val(myVar)> trim spaces ------------ <cfif Trim(myVar) EQ ""> <cfif Len(Trim(myVar)) EQ 0> or <cfif NOT Len(Trim(myVar))> then <cfif Val(Trim(myVar)) EQ 0> or <cfif NOT Val(Trim(myVar))> If you wanting to see if the var has a value, I would use <cfif Len(Trim(myVar))> Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew Dickinson Sent: Monday, June 30, 2003 4:24 PM To: CFAussie Mailing List Subject: [cfaussie] Using IS NULL in CFIF I don't think I covered this question last time I asked about Is Null. How can I express a command like <CFIF Var IS NULL> ? This syntax is allowed inside SQL, but I need to do this or something like it in CF. I'm still playing around with the results of left/right joins. And while I'm at it, will someone please tell me how to search/access the CFAussie archives ? I've had several goes at it, and never managed a non-nil result. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
