Re: Dates - Search and Sorting
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23023
interpreted = N
texte = DON'T use dateFIELD. nor dateTYPE nor dateSDIR, you see where I'm going. Field is used with talking about What fields are used in a group. I generally use TheDate AddDate, etc... as my field header.At 02:48 PM 1/27/99 -0800, you wrote: >Still stumped... > >I changed my date preferences to %m/%d/%y to they match the format of the >info in the database field, DateField. It had no affect. I tried to make >sure that the name of my field would not conflict with other DNA code by >changing it to DateField, no affect. There is still something I am missing. >Maybe someone else can see it ... > >One of those days :-) > >RH Prouty >bristol@ez-mortgage.com > >>> 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, 1999 >> >> the 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? >Howard Wolosky ------------------------- Rutgers University Class of 2001 hwolosky@eden.rutgers.edu
Associated Messages, from the most recent to the oldest:
DON'T use dateFIELD. nor dateTYPE nor dateSDIR, you see where I'm going. Field is used with talking about What fields are used in a group. I generally use TheDate AddDate, etc... as my field header.At 02:48 PM 1/27/99 -0800, you wrote: >Still stumped... > >I changed my date preferences to %m/%d/%y to they match the format of the >info in the database field, DateField. It had no affect. I tried to make >sure that the name of my field would not conflict with other DNA code by >changing it to DateField, no affect. There is still something I am missing. >Maybe someone else can see it ... > >One of those days :-) > >RH Prouty >bristol@ez-mortgage.com > >>> 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, 1999 >> >> the 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? >Howard Wolosky ------------------------- Rutgers University Class of 2001 hwolosky@eden.rutgers.edu
Howard Wolosky
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:
Running 2 two WebCatalog.acgi's (1996)
Incorrect Value Display (2000)
writefile and texte (1997)
WebDNA Freelancer Needed (2002)
Running 2 two WebCatalog.acgi's (1996)
RE: 2nd WebCatalog2 Feature Request (1996)
ListVariables Problem (2003)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
simple help (1999)
SendTo more emails (1998)
HELP WITH DATES (1997)
template includes encrypted template (1999)
Login and pass variables to [protect] tag (2001)
[taxRate] [TaxTotal] ? (1997)
Separate SSL Server (1997)
WebCat2b13MacPlugIn - more [date] problems (1997)
[isfile] ? (1997)
Access Denied! But why? (1997)
[sendmail] questions... (1997)