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:

Can I invoke an ssi plugin from within a webcat page (1997) WML (2000) If Empty ? (1997) Problems passing [SKU] with $Replace in 2.0 (1997) WebCat2 - Getting to the browser's username/password data (1997) WebDNA 5.0 Enterprise Edition (2003) Setting a null value for reply to address using sendmail... (2001) TCPConnect (2002) Restarting Crippled Webcatalog (2003) PCS Emailer's role ? (1997) PIXO (1997) OT: How to Ignore Your Best Customers (2003) [foundItems] context problem (2000) CommandSecurity? (1997) WebCatalog Hosting (1996) Re:Running 2 two WebCatalog.acgi's (1996) problem: type 2 errors (1997) Possible Bug in 2.0b15.acgi (1997) SSL and WebCatalog (1997) Card clearance, problems - solutions? (1997)