<CFIF myvariable is "" or myvariable is " ">
of <CFIF trim(myvariable) is "">
At 12:28 PM 6/27/00 +0100, you wrote:
>This works fine except when empty string values are also present as data in
>the column (field). The SQL ISNULL() function should help resolve this
>issue if you are experiencing this problem (assuming you are using SQL ;-) )
>Regards,
>Anthony Geoghegan,
>IFTN
>Lead developer
>www.wow.ie
>
>-----Original Message-----
>From: Justin v0.9 MacCarthy [mailto:[EMAIL PROTECTED]]
>Sent: 27 June 2000 12:24
>To: [EMAIL PROTECTED]
>Subject: Re: NULL using it in CF
>
>
>Use
>
>
><CFIF #myvariable# IS "">do something</CFIF>
>----- Original Message -----
>From: Colin Robinson <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Tuesday, June 27, 2000 12:14 PM
>Subject: NULL using it in CF
>------------------------------------------------------------------------------
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
