Re: searching numbers

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18514
interpreted = N
texte = >>This is wrong, it should be:>the db price field data has commas in the price could this be the >problem?Yes, that's another thing to correct. Numeric values in your database should NEVER be stored with commas. You can use [format] to display commas on the page if you want to, but you should get rid of the commas in your db so the numeric comparisons will work properly ... :)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:

    
  1. Re: Searching Numbers (ZIP Code, Distance-based, Store ( David M. Dantowitz 2004)
  2. Re: Searching Numbers (ZIP Code, Distance-based, Store ( David M. Dantowitz 2004)
  3. Re: Searching Numbers ( Gary Krockover 2004)
  4. Re: Searching Numbers ( David Cate 2004)
  5. Re: Searching Numbers ( Terry Wilson 2004)
  6. Re: Searching Numbers ( Brian Fries 2004)
  7. Re: Searching Numbers ( Gary Krockover 2004)
  8. Re: Searching Numbers ( David Cate 2004)
  9. Re: Searching Numbers ( David Cate 2004)
  10. Re: Searching Numbers ( Brian Fries 2004)
  11. Re: Searching Numbers ( Terry Wilson 2004)
  12. Re: Searching Numbers ( David Cate 2004)
  13. Re: Searching Numbers ( Gary Krockover 2004)
  14. Re: Searching Numbers ( "Sal D'Anna" 2004)
  15. Re: Searching Numbers ( David Cate 2004)
  16. Re: Searching Numbers ( "Sal D'Anna" 2004)
  17. Re: Searching Numbers ( Gary Krockover 2004)
  18. Re: Searching Numbers ( David Cate 2004)
  19. Re: Searching Numbers ( Gary Krockover 2004)
  20. Re: Searching Numbers ( David Cate 2004)
  21. Re: Searching Numbers ( Gary Krockover 2004)
  22. Searching Numbers ( David Cate 2004)
  23. Re: searching numbers (PCS Technical Support 1998)
  24. Re: searching numbers (Kenneth Grome 1998)
  25. searching numbers (Chuck Wall 1998)
>>This is wrong, it should be:>the db price field data has commas in the price could this be the >problem?Yes, that's another thing to correct. Numeric values in your database should NEVER be stored with commas. You can use [format] to display commas on the page if you want to, but you should get rid of the commas in your db so the numeric comparisons will work properly ... :)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:

disappearing SKU (etc.) fields (1998) [WebDNA] Best practice re: password storage (2013) Editor Recommendation for NT Users (1998) Generating Searches on the fly? (1999) WebCatb15 Mac CGI -- [purchase] (1997) Resume Catalog ? (1997) Friday night shopping site joke (1997) Where is f2? (1997) Re:Merging databases (1997) Integration with SQL (1997) b18 problem on NT 4.0 (1997) database size? (1997) Almost a there but..bye bye NetCloak (1997) shipcost (1997) RE: Include (1998) New servers and new inline cache (1997) Re:no [search] with NT (1997) Quick ShowIf question (1997) [WebDNA] FileUpload Issue ... cont. (2012) Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997)