Re: searching by date
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18256
interpreted = N
texte = >At 10:10 AM 6/15/98, John Hill wrote:>>Ken:>>>>The best way is to add a hidden input field or parameter to each search>>request (if you are using command=search style searching and your field is>>named CLASS_DATE):>>>>CLASS_DATEtype=date&geCLASS_DATEdatarq=[date]>>Well I had that, and it didn't work. I added your line and it didn't>work...didn't work in that I get 0 results.>>I'm wondering if the data in the Class-date field is not in the proper>configuration.>>I've tried 6/12/98 Jun 12, 1998 June 12, 1998 with and without spaces>between the comma and the year.>>Any other ideas?I've solved many date searching problems by storing all my dates as the number of days since 00/00/0000, then using the other date searching suggestions available at:http://webdna.net/dates.htmlSincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>At 10:10 AM 6/15/98, John Hill wrote:>>Ken:>>>>The best way is to add a hidden input field or parameter to each search>>request (if you are using command=search style searching and your field is>>named CLASS_DATE):>>>>CLASS_DATEtype=date&geCLASS_DATEdatarq=
[date]>>Well I had that, and it didn't work. I added your line and it didn't>work...didn't work in that I get 0 results.>>I'm wondering if the data in the Class-date field is not in the proper>configuration.>>I've tried 6/12/98 Jun 12, 1998 June 12, 1998 with and without spaces>between the comma and the year.>>Any other ideas?I've solved many date searching problems by storing all my dates as the number of days since 00/00/0000, then using the other date searching suggestions available at:http://webdna.net/dates.htmlSincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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:
I have observed and I am gone. (1998)
If Empty ? (1997)
WebCat2 - storing unformatted date data? (1997)
Re[3]: Problem with new formvariables (2000)
Emailer setup (1997)
Date Formats (1997)
Template Encrypt Speed (1998)
[ShowNext] (1997)
Location of Browser Info.txt file (1997)
can we get string variables? (1998)
foreign character sets and conversions (1998)
Size limit for tmpl editor ? (1997)
Instructions for Digest (1997)
Need relative path explanation (1997)
User/Pass dialogue issue [AOL?] (2002)
Bulk Processing Offline (2004)
random .inc files pulled and placed (2002)
sorting on date in search (2000)
where to put code (1998)
Windows-based Code Editor (2002)