Hi Phil,

Whilst not a cfif... Not far off..

<cfset thisVar = 0>
#IIF(val(thisVar),thisVar,de(""))#

Seeya,
Adam

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Phil Evans
Sent: Friday, 28 February 2003 2:52 PM
To: CFAussie Mailing List
Subject: [cfaussie] Zero suppression


Hi All,

The other day we had some very clever methods for converting negatives
to zero.
Any one care to have a crack at converting zero to null, prior to
displaying on a form?
(Aside from using an IF statement).

Thanks,
Phil.


---
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/

Reply via email to