Re: Re: Number searching/formats
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16546
interpreted = N
texte = >>-------------------- Original Message Follows -------------------->>>rnpricedata=[form.minprice] [form.maxprice]&pricetype=num>>>>>>works great... No problem! However, it does not display records with the>>>price format including a comma. i.e. 2,999 etc.... if the format is>>>2999.00, 2999, no problem.>>>>>>Is it possible to format the numeric value at the point of input????>>>>>>No, your visitor has complete control over the value that gets entered>into the form. You have to pass that value to the next page, where you can>perform your append or replace. Then, instead of putting a simple>[form.price] tag inside the append or rep>>>>lace context, you can put that tag inside a [format] context first. The>format context can be used to change the form value into the proper format>*before* it gets placed into the database. Then your comparisons will work>fine ... :)>>>I played with the format feature right after sending the email, however theresults were:price=[format 10.2f][form.price][/format] if the value entered was 19,000. the value saved would be 19.00. (BAD)if the value entered was 19000 the value saved would be 19000.00. (GOOD)Any ideas???Vince
Associated Messages, from the most recent to the oldest:
>>-------------------- Original Message Follows -------------------->>>rnpricedata=[form.minprice] [form.maxprice]&pricetype=num>>>>>>works great... No problem! However, it does not display records with the>>>price format including a comma. i.e. 2,999 etc.... if the format is>>>2999.00, 2999, no problem.>>>>>>Is it possible to format the numeric value at the point of input????>>>>>>No, your visitor has complete control over the value that gets entered>into the form. You have to pass that value to the next page, where you can>perform your append or replace. Then, instead of putting a simple>[form.price] tag inside the append or rep>>>>lace context, you can put that tag inside a
[format] context first. The>format context can be used to change the form value into the proper format>*before* it gets placed into the database. Then your comparisons will work>fine ... :)>>>I played with the format feature right after sending the email, however theresults were:price=[format 10.2f][form.price][/format] if the value entered was 19,000. the value saved would be 19.00. (BAD)if the value entered was 19000 the value saved would be 19000.00. (GOOD)Any ideas???Vince
apc Information
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:
Emailer 1.01 bombs (1997)
Sku numbers (1997)
[WebDNA] Bug reporting (2009)
More questions about serial number dishing (1997)
[LOOKUP] (1997)
Can't Update records (1997)
AccountAuthorizer doesn't seem to work (1997)
[include file=filename.inc&strip=t] (2002)
MasterCounter Weirdness (1997)
Server slowing down. (1997)
Multiple prices (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
[OT] Stock price charts (2006)
rotating thumbnails (1997)
Redirect (2003)
taxTotal, grandTotal (1997)
boldwords (2001)
Only charge card when product shipped ? (1997)
Email encryption (1998)
WebCat2b13MacPlugIn - syntax to convert date (1997)