Re: Dates - Search and Sorting

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23013
interpreted = N
texte = > This may have something to do with the date prefs in your WebCatalog Prefs > file.hmm.. That could be..>I think there are two different date preferences in that file, what > are yours set to? %B %d, %Y - yields - January 27, 1999the only other preference I see is for time:%I:%M:%p> And what kind of date format are you using in your 'dated' field?day/month/year - as in 1/25/99 > > Another possibility is that the field name Dated could be confusing > webcat ... have you tried using a different field name?I tried changing this also. My search is now:[search db=mfiShares.db&eqMarkerdatarq=c&DateFieldtype=date&DateFieldsort=1]It also seems that another date sort on my site that was working is now not working.I am using webstar 3.02 and webcat 3.04b5 on a 266 G3. It would seem this is a simple search. I am not aware that the data must be stored in any kind of date format as long as you tell webcat it's Fieldtype=date is should treat it as such.... right?RH Prouty bristol@ez-mortgage.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  2. Re: Dates - Search and Sorting (Mike_Davis 1999)
  3. Re: Dates - Search and Sorting (PCS Technical Support 1999)
  4. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  5. Re: Dates - Search and Sorting (RH Prouty 1999)
  6. Re: Dates - Search and Sorting (RH Prouty 1999)
  7. Re: Dates - Search and Sorting (RH Prouty 1999)
  8. Re: Dates - Search and Sorting (Howard Wolosky 1999)
  9. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  10. Re: Dates - Search and Sorting (RH Prouty 1999)
  11. Re: Dates - Search and Sorting (RH Prouty 1999)
  12. Re: Dates - Search and Sorting (Kenneth Grome 1999)
  13. Dates - Search and Sorting (RH Prouty 1999)
> This may have something to do with the date prefs in your WebCatalog Prefs > file.hmm.. That could be..>I think there are two different date preferences in that file, what > are yours set to? %B %d, %Y - yields - January 27, 1999the only other preference I see is for time:%I:%M:%p> And what kind of date format are you using in your 'dated' field?day/month/year - as in 1/25/99 > > Another possibility is that the field name Dated could be confusing > webcat ... have you tried using a different field name?I tried changing this also. My search is now:[search db=mfiShares.db&eqMarkerdatarq=c&DateFieldtype=date&DateFieldsort=1]It also seems that another date sort on my site that was working is now not working.I am using webstar 3.02 and webcat 3.04b5 on a 266 G3. It would seem this is a simple search. I am not aware that the data must be stored in any kind of date format as long as you tell webcat it's Fieldtype=date is should treat it as such.... right?RH Prouty bristol@ez-mortgage.com RH Prouty

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:

Search results templates (1996) Email Formatting (2001) Central Reservation System? (2003) Press Release hit the NewsWire!!! (1997) why is this line in GeneralStore? (1998) blank page from template (1997) [SearchString] usage (1997) Problem with empty form-variables in [search] (1998) latest version? (1998) [WebDNA] grep again (2010) Fwd: Image Pirating [protecting against] (2003) [OT] Robust order processing (2003) Single Link browsing (1997) searchable list archive (1997) Configuring E-mail (1997) [purgeDatabase], [replaceChars] and others ... (1997) Help! WebCat2 bug (1997) searching a range -still don't get it (2000) Simple way to create unique SKU (1997) Who is doing sign-ups-got it (1998)