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:
[WriteFile] problems (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
Emailer (WebCat2) (1997)
Search returns all, not 20 (1997)
Doesn't change (WebCat 4.0) (2000)
emailer (1997)
AppleScript: Tell application:app location? (1998)
Thanks and Big News!!! (1997)
NT Version on IIS 4.0 (1997)
How to Display text in empty fields (1997)
[CART] (1997)
Nav. 4 probs with cart (1997)
no global [username] or [password] displayed ... (1997)
Server Freeze (1998)
Odd search results, or odd programmer, not sure which... (2002)
How true is this? (1999)
hidden (phantom) file downloads (2000)
target=_blank and form variables (1997)
problems with WebCat-Plugin (1997)
Applescript error (1998)