Re: sorting by date

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23382
interpreted = N
texte = >I need to show a search sorted by date. > >the date in the database is 11/11/98 etc. > >I'm getting a sort on the first digits first. >not on the entire date. >11/01/98 >11/12/98 >12/13/98OK, a couple things: make sure you are telling WebCatalog that the field is a date. You do this by adding something like YOURFIELDNAMEtype=date to the search criteria. Then if that doesn't help, it means your WebCatalog preferences for Read Date Format are not mdy, which stands for month/day/year ordering.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: sorting by date Y2K mix up (Brian B. Burton 2000)
  2. Re: sorting by date Y2K mix up (Kenneth Grome 2000)
  3. sorting by date Y2K mix up (Laurent Pladys 2000)
  4. Re: sorting by date (PCS Technical Support 1999)
  5. Re: sorting by date (Kenneth Grome 1999)
  6. Re: sorting by date (Kenneth Grome 1999)
  7. sorting by date (Richard 1999)
  8. Re: Sorting by date (Trevor Crist 1997)
  9. Re: Sorting by date (Trevor Crist 1997)
  10. Re: Sorting by date (Trevor Crist 1997)
  11. Re: Sorting by date (marty@artwerks.com (Marty Schmid) 1997)
  12. Re: Sorting by date (Grant Hulbert 1997)
  13. Re: Sorting by date (Marty Schmid 1997)
  14. Sorting by date (Trevor Crist 1997)
  15. Re: Sorting by date (Grant Hulbert 1997)
>I need to show a search sorted by date. > >the date in the database is 11/11/98 etc. > >I'm getting a sort on the first digits first. >not on the entire date. >11/01/98 >11/12/98 >12/13/98OK, a couple things: make sure you are telling WebCatalog that the field is a date. You do this by adding something like YOURFIELDNAMEtype=date to the search criteria. Then if that doesn't help, it means your WebCatalog preferences for Read Date Format are not mdy, which stands for month/day/year ordering.Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ PCS Technical Support

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:

cart info (1998) It just Does't add up!!! (1997) Forcing a NEWCART (1997) 2.1 bugs left over from beta cycle (1998) WebCommerce: Folder organization ? (1997) Searching blank fields problem (1999) multi-paragraph fields (1997) purchase plugin (1996) WebCat2b12--[searchstring] bug (1997) Template Encryption (1998) Groups doesn't work (1997) bug in [SendMail] (1997) WebCat2: Items xx to xx shown, etc. (1997) Re:Email Problem (1997) Checkboxes (1998) Uploading Files and Descriptions W* (2000) Math Help (2000) OS X problem: when using [ShowCart] or [orderfile]... (2000) set header in DB (no cart) (2003) [Sum] function? (1997)