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:
[SearchString] problem with [search] context (1997)
Search (1997)
[WebDNA] [data] and RETS (2009)
Error Lob.db records error message not name (1997)
Nested tags count question (1997)
looping table rows (1999)
Sandboxes & Kitty Litter trays (2003)
Don't know if this is a sily question... (2003)
Buying sans cart (1997)
Export database record - append to other database (2005)
BBEdit/HTMLcomments/WebCat/[/FONT] (1999)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
&FieldNametype=time unnecessary? (2000)
Protecting Files (how to display vs. present a link to (2005)
Great product and great job ! (1997)
Storebuilder documentation (2004)
Emailer.Out (1998)
carriage returns in data (1997)
Experience with creating real dynamic solutions?????? (1998)
Questions To Answer (1997)