Re: BW in a search

This WebDNA talk-list message is from

2007


It keeps the original formatting.
numero = 68530
interpreted = N
texte = Olin Lagon wrote: > [math]1234567890123456[/math] > > You get this 1.23456789012346e+015 That has nothing to do with WebCatalog, /per se/, but rather the underlying CRT (C Run-Time library) being unable to handle arbitrarily large integers. > So if in a search context large numbers (carts, dates, etc) may get A date number is 32bits (number of seconds since the epoch) and hence will be small enough to fit in any modern O/S's integer (until 2038, that is). On the other hand, [cart] is *not* a number, because it has a variable length (multiple carts issued in the same second will have a uniquifier appended to them). It may look like a number, but if you treat it as one, your sites will break in annoying and hard to track ways (since it will only be variable length under heavy load). There are probably a few people here who were running WebCatalog on 2001-09-09 Sun, when the typical length of the [cart] value went from 15 to 16 characters (corresponding to 1 billion seconds after the Unix epoch). John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Blvd Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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)
Olin Lagon wrote: > [math]1234567890123456[/math] > > You get this 1.23456789012346e+015 That has nothing to do with WebCatalog, /per se/, but rather the underlying CRT (C Run-Time library) being unable to handle arbitrarily large integers. > So if in a search context large numbers (carts, dates, etc) may get A date number is 32bits (number of seconds since the epoch) and hence will be small enough to fit in any modern O/S's integer (until 2038, that is). On the other hand, [cart] is *not* a number, because it has a variable length (multiple carts issued in the same second will have a uniquifier appended to them). It may look like a number, but if you treat it as one, your sites will break in annoying and hard to track ways (since it will only be variable length under heavy load). There are probably a few people here who were running WebCatalog on 2001-09-09 Sun, when the typical length of the [cart] value went from 15 to 16 characters (corresponding to 1 billion seconds after the Unix epoch). John -- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4501 Forbes Blvd Suite H Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- 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/ John Peacock

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:

frames & carts (1997) Summing fields (1997) [WebDNA] filter out the exclaimation point (2017) Pager notification of completed orders (1998) retain raw [cart] submitted value (2004) OT-JS question (2001) New servers and new inline cache (1997) creating an email message (1998) - selectable size to an ecommerce app? (2000) webcat- multiple selection in input field (1997) WCS Newbie question (1997) Cancel Subscription (1996) Migrating to NT -Reply (1997) [WebDNA] anybody installed on snow leopard (2009) OT?: Size issues (2001) Banner DNA (1997) FYI: virus alert (1996) Help! WebCat2 bug (1997) Frames and WebCat (1997) Re:2nd WebCatalog2 Feature Request (1996)