Re: Number searching/formats
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16535
interpreted = N
texte = >I have made no attempts to research this because I am tired (lazy?) So I >thought I will give the WCAT talk list a late night shout.... > >I have a search criteria such as a price range.... I compare the low & high >price range as 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 replace 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 ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>I have made no attempts to research this because I am tired (lazy?) So I >thought I will give the WCAT
Talk List a late night shout.... > >I have a search criteria such as a price range.... I compare the low & high >price range as 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 replace 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 ... :)Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
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:
more on my bbs (1997)
unable to launch acgi in WebCat (1997)
[WebDNA] TCPconnect code snippet needed (2008)
Summing fields (1997)
Calculating multiple shipping... (1997)
1st Comparison inside [fileinfo] broken. = bug? (2004)
[WebDNA] WebDNA FastCGI (2012)
Deleting associated records from 2 different databases (2001)
Install webcat on intel/linux box. (2000)
placement of ? (2000)
webcatalog [date] bug...not (1999)
WebCommerce: Folder organization ? (1997)
[WebDNA] WebDNA on PowerPC Leopard Server (2009)
Order not created error (1997)
Hosting (UK preferable) (2003)
can you reassign loop index? (1998)
inetinfo.exe (1999)
No luck with taxes (1997)
[shell] oddity (2002)
[WebDNA] Credit card processing (2012)