Re: Dates - Search and Sorting

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23011
interpreted = N
texte = >Dated is the name of my database field: >[search db=my.db&eqMarkerdatarq=c&Datedtype=date&Datedsort=1&Datedsdir=as] > >This search results show the records found as expected, but the sorting is >not happening by date. It seems to be sorting the correct Dated field, >but it is seeing them as text not dates. I include the type tag, but it >still doesn't see it properly.This may have something to do with the date prefs in your WebCatalog Prefs file. I think there are two different date preferences in that file, what are yours set to? And what kind of date format are you using in your 'dated' field?Another possibility is that the field name Dated could be confusing webcat ... have you tried using a different field name?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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)
>Dated is the name of my database field: >[search db=my.db&eqMarkerdatarq=c&Datedtype=date&Datedsort=1&Datedsdir=as] > >This search results show the records found as expected, but the sorting is >not happening by date. It seems to be sorting the correct Dated field, >but it is seeing them as text not dates. I include the type tag, but it >still doesn't see it properly.This may have something to do with the date prefs in your WebCatalog Prefs file. I think there are two different date preferences in that file, what are yours set to? And what kind of date format are you using in your 'dated' field?Another possibility is that the field name Dated could be confusing webcat ... have you tried using a different field name?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

PIXO support (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) nesting limits? (1998) RAM variables (1997) a * question (2003) WebCat b13 CGI -shownext- (1997) PCS Frames-Default page is solution! (1997) Formating Tables w/[founditems] (1998) Resume Catalog ? (1997) WebCat2 several catalogs? (1997) Any limit to [include] (1997) Shipping.db (1998) PC Cookie Problem? (2003) Anyone have an invoicing system? (2000) Sorting LISTFILES (1997) Help! WebCat2 bug (1997) WebCat2: Items xx to xx shown, etc. (1997) [OT] DNS on Development Server (2004) RE: Can a database get stomped by simultaneous access? (1997) auction system w/ Web Cat (1999)