Re: Dates - Search and Sorting
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23014
interpreted = N
texte = 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?
Associated Messages, from the most recent to the oldest:
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?
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:
Using Plug-In while running 1.6.1 (1997)
WebCat2 - many [carts] on one template page? (1997)
creator code (1997)
spawn (1998)
WebCatalog can't find database (1997)
corrupted images (2002)
[writefile] (1997)
WebCommerce: Folder organization ? (1997)
Exists? (1997)
SQL / Webcat Help (1999)
Nesting format tags (1997)
Malformed Pages (1999)
Gathering the values of matching fields in a database. (1998)
Mozilla/4. and Browser Info.txt (1997)
Cookies not being set on PC/ Explorer (2000)
SQL Error: 00000 (2004)
Here's how to kill a Butler Database. (1997)
http or https? (2001)
Re:Emailer tracking (1997)
Emailer setup (1997)