Re: BW in a search

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68529
interpreted = N
texte = BW does seem to work with numbers - just not very large ones. When you try to apply math to a number 16 digits or larger, WebDNA seems to change it to exponential format. Try this [math]1234567890123456[/math] You get this 1.23456789012346e+015 So if in a search context large numbers (carts, dates, etc) may get converted into exponential format and thus the bw may not work properly unless you leave it as text. This is a good case to keep dates in text sortable format YYYYMMDD so you can sort them alphanumerically. Just my hunch and not via testing... -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Lester Sent: Friday, February 23, 2007 2:25 PM To: WebDNA Talk Subject: Re: BW in a search --- Donovan Brooke wrote: >Surprises me that bw doesn't >apparently work with numbers. > > Donovan The "type=num" error was my fault... but it didn't matter anyways I thought BW should work with numbers as well.. oh well onward.... thanks ____________________________________________________________________________ ________ Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=list&sid=396546091 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: BW in a search ( John Peacock 2007)
  2. Re: BW in a search ( "Olin Lagon" 2007)
  3. Re: BW in a search ( Lester 2007)
  4. Re: BW in a search ( Donovan Brooke 2007)
  5. Re: BW in a search ( Pat McCormick 2007)
  6. Re: BW in a search ( Pat McCormick 2007)
  7. Re: BW in a search ( Lester 2007)
  8. Re: BW in a search ( "Olin Lagon" 2007)
  9. Re: BW in a search ( Donovan Brooke 2007)
  10. Re: BW in a search ( Lester 2007)
  11. Re: BW in a search ( thierry 2007)
  12. Re: BW in a search ( Gary Krockover 2007)
  13. BW in a search ( Lester 2007)
  14. using bw in a search on a numeric field (100-Watt Puppeteer 2000)
BW does seem to work with numbers - just not very large ones. When you try to apply math to a number 16 digits or larger, WebDNA seems to change it to exponential format. Try this [math]1234567890123456[/math] You get this 1.23456789012346e+015 So if in a search context large numbers (carts, dates, etc) may get converted into exponential format and thus the bw may not work properly unless you leave it as text. This is a good case to keep dates in text sortable format YYYYMMDD so you can sort them alphanumerically. Just my hunch and not via testing... -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Lester Sent: Friday, February 23, 2007 2:25 PM To: WebDNA Talk Subject: Re: BW in a search --- Donovan Brooke wrote: >Surprises me that bw doesn't >apparently work with numbers. > > Donovan The "type=num" error was my fault... but it didn't matter anyways I thought BW should work with numbers as well.. oh well onward.... thanks ____________________________________________________________________________ ________ Need Mail bonding? Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=list&sid=396546091 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ "Olin Lagon"

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:

Two submit buttons ? (1997) sorry (1997) NEVERMIND! New syntax (2000) WebTen and WebCat (1997) WCS Newbie question (1997) Searching multiple fields from one form field (1997) Keeping track of revision history, etc. (2005) [WebDNA] [WSC] WebDNA Development Summit (2014) Storebuilder (2000) OPEN MARKET PATENTS SOUND ECOMMERCE ALARM (1998) Math (1997) Help!!!! (1997) 4.0.2b4 (2000) Recalculating Shipping Costs (1997) Separate SSL Server (1997) useful guidelines =] vs !] (2007) smithmicro.com website? (2004) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Email template names (1997) MS Commerce Comparison (long) (1998)