Thanks for the info.  I will save that for a later date
  ----- Original Message -----
  From: Ubqtous
  To: CF-Talk
  Sent: Wednesday, January 21, 2004 1:43 PM
  Subject: Re: Problems with Text in Access

  Mickael,

  On 1/21/2004 at 13:33, you wrote:

  M> Should there be some sort of argument in the cfif ?  Like =0?

  The result of len() can be treated like a boolean, so if the length of
  the string is 0:

  len(string) equates to 'false'

  Or if there is a length to the string:

  len(string) equates to 'true'

  Using <cfif len(string) neq 0> is valid, but <cfif len(string)>
  saves typing and is even evaluated a little quicker by the server.

  In your case, isnumeric() makes more sense:

  <cfif isnumeric(yourdollarfield)>
          #dollarformat(yourdollarfield)#
  <cfelse>
          $0.00
  </cfif>

  ~ Ubqtous ~
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to