Re: WebCat2 - [format thousands]
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10516
interpreted = N
texte = >>Is [format thousands] smart enough to know when the data it's formatting >>has been preformatted? > >No. You have to feed it a true number without any commas. Apologies to >non-US customers, but for now any numbers you store in your database that >you want to work inside [math] and [format] contexts must be stored using >a decimal point . for fractions rather than a comma. > >You are allowed to _output_ the number with European-style decimal >delimiters by using the [format] context, but the original must be >American-style.Grant, I have a [price] field that I tell my users to enter only numbers into. I put extra instructions on the page to remind them of this. I also put a big bold dollar sign immediately in front of that field on the input form so they will NOT enter a dollar sign themselves. But guess what? They still insist on entering that dollar sign! Some of them also like to enter commas as thousands separators, which I have also told them not to do - but they do it anyways.What would you think of a new function that would remove all non-numeric characters ... except for one or more predefined characters which we as webmasters can set in the WebCatalog Prefs file? This would give us more control over numeric formatting, similar to the way we can preformat the date and time entries now.If I could simply get WebCat2 to strip away all the non-numeric characters except for the decimal point (or if I were European, the comma) for example, then it wouldn't matter what my users insist on placing into my numeric input fields, because everything except the decimal points (or commas) would be stripped away before any other formatting or displaying of those numbers would take place.This would be universally useful for both European and American number systems, because the webmaster could choose the delimiter to leave in - either a period or a comma - and all other non-numeric characters would be stripped away, including dollar signs, etc.Sincerely, Ken ------------------------------------ To leave this talk list send an email to macjordomo@smithmicro.com with BODY unsubscribe WebDNA-Talk ------------------------------------
Associated Messages, from the most recent to the oldest:
>>Is [format thousands] smart enough to know when the data it's formatting >>has been preformatted? > >No. You have to feed it a true number without any commas. Apologies to >non-US customers, but for now any numbers you store in your database that >you want to work inside
[math] and
[format] contexts must be stored using >a decimal point . for fractions rather than a comma. > >You are allowed to _output_ the number with European-style decimal >delimiters by using the
[format] context, but the original must be >American-style.Grant, I have a [price] field that I tell my users to enter only numbers into. I put extra instructions on the page to remind them of this. I also put a big bold dollar sign immediately in front of that field on the input form so they will NOT enter a dollar sign themselves. But guess what? They still insist on entering that dollar sign! Some of them also like to enter commas as thousands separators, which I have also told them not to do - but they do it anyways.What would you think of a new function that would remove all non-numeric characters ... except for one or more predefined characters which we as webmasters can set in the WebCatalog Prefs file? This would give us more control over numeric formatting, similar to the way we can preformat the date and time entries now.If I could simply get WebCat2 to strip away all the non-numeric characters except for the decimal point (or if I were European, the comma) for example, then it wouldn't matter what my users insist on placing into my numeric input fields, because everything except the decimal points (or commas) would be stripped away before any other formatting or displaying of those numbers would take place.This would be universally useful for both European and American number systems, because the webmaster could choose the delimiter to leave in - either a period or a comma - and all other non-numeric characters would be stripped away, including dollar signs, etc.Sincerely, Ken ------------------------------------ To leave this
Talk List send an email to macjordomo@smithmicro.com with BODY unsubscribe WebDNA-Talk ------------------------------------
Kenneth Grome
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
page chokes on hideif when false and ignored (1998)
Only charge card when product shipped ? (1997)
Upload Maximum (2003)
Confused about Grep Syntax (2004)
Displaying photo attached to first record (1997)
RE: Languages (1997)
WebCat2 as a chat server? (1997)
Emailer (1997)
Almost a there but..bye bye NetCloak (1997)
Add - optional parameters textA=.... (1997)
2 questions (2000)
Interesting speed comparison .. (2003)
Great product and great job ! (1997)
Menu to select product variations (1997)
General WebCatalog Questions (1997)
Include a big block of text (1997)
why .HTML pages no processing? (2000)
Attn: Bug in GeneralStore example b15 (1997)
[ShowNext] (1997)
Signal Raised Error (Part III) (1997)