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:
User/Pass dialogue issue [AOL?] (2002)
Who is doing sign-ups-got it (1998)
Major Security Hole (1998)
Multiple fields on 1 input (1997)
Why is deleting so slow? (2002)
Setting up shop (1997)
Stumpted Again (1997)
Fedora Core 2 (2005)
Which GUI HTML editors work with WC ? (1997)
problem with NT beta (1997)
Problems with upload / WebCat (1998)
Lots of bounce errors (2007)
[HIDEIF] inside [FOUNDITEM] (1997)
Help formatting search results w/ table (1997)
question: webmerchant connection (1997)
Server Freeze (1998)
Webcatalog/NT dbserver crashing. (2000)
RE:formula.db problems (1999)
Newbie questions (2000)
webcat NT with [dos] command (1997)