Numeric Formatting

[REdSta]

Has anyone figured out a way to get numeric formatting with CDML.

For example, a numeric field for currency in FileMaker is formatted to display as "$1,234.50". CDML displays it as "1234.5".

I know I can simply put the "$" in HTML, but I haven't found a simple way to get the two decimal places to display correctly.

[This message has been edited by REdSta (edited May 30, 2000).]

[Keith M. Davie]

Yes. "Database publishing with FileMaker Pro on the Web" by Maria Langer (Peachpit Press) discusses preparing one's db to allow display of the decimal rounded and the $-sign inserted, though there is an error in her calculation algorithm. Following "...If(Round(Unit Price, 2)..." she uses ">", which will keep the "1" from appearing if the amount is "1,000". To fix this use "*" (Macintosh). I'm not sure, but I think with Windows you would use ">=" or "=>", but if you are a Windows user, you will know.

Hope you find this useful.

Peace

Keith M. Davie

[Keith M. Davie]

I forgot to mention that (in addition to the error already mentioned) this book has perhaps the most inadequate index I've ever encountered. So with that in mind, you will want to look on page 317.

Peace

Keith M. Davie

[Keith M. Davie]

In the reply, I don't know how the asterisk appeared, as it formated correctly as "less-than equals" (option-period Macintosh) when I wrote it.

Peace

Keith M. Davie