Re: Searching/sorting dates

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 13993
interpreted = N
texte = >Does or does not WebCat work with international dates? The doc states that >international dates can be used and sorting, comparision and summaries >works with dates formatted as set in the general prefs, but my experiences >today says different :-(I think the numbers need to be separate by /, not -. But before you change your database, I have another suggestion. It looks like you have stored your dates in a way that can be sorted using standard alphabetical sorting, so first try removing the type=date parameter from your search context. Then WebCatalog will sort them as strings of text, and I think they will sort correctly.If you use this technique, it is *very* important that you have 0 preceding single-digit days and months: 1997-02-02, *not* 1997-2-1Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching/sorting dates (Grant Hulbert 1997)
  2. Searching/sorting dates (Christer Olsson 1997)
>Does or does not WebCat work with international dates? The doc states that >international dates can be used and sorting, comparision and summaries >works with dates formatted as set in the general prefs, but my experiences >today says different :-(I think the numbers need to be separate by /, not -. But before you change your database, I have another suggestion. It looks like you have stored your dates in a way that can be sorted using standard alphabetical sorting, so first try removing the type=date parameter from your search context. Then WebCatalog will sort them as strings of text, and I think they will sort correctly.If you use this technique, it is *very* important that you have 0 preceding single-digit days and months: 1997-02-02, *not* 1997-2-1Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) WC2.0 Memory Requirements (1997) Multiply prices (1997) [SHOWIF] (1997) webcat2b12 CGI -- Date comparisons (1997) Rhapsody? (1997) [WebDNA] WebDNA & Facebook (2010) RE: [WebDNA] [OT] Phone solution for multiple companies at same location (2010) textarea question (1998) Secure server question (1997) PR: WebCatalog Affiliates Program Announced -- Share the revenue for promoting WebCatalog (2000) Help HTML reader (1999) Rollovers (1999) Moment of Thanks (1997) HELP WITH DATES (1997) Database access (2003) thankyou.tmpl (1997) Math with Time (1997) WebCat2b13 Command Reference Doc error (1997) Two prices in shoppingcart? (1997)