Re: Dates
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19363
interpreted = N
texte = You don't need to enclose the date your searching for in the math contextunless you plan on manipulating the date somehow. This works the same way:[Searchdb=dkmweb.db&lestart_datedatarq=[Date]&geEnd_datedatarq=[Date]&Start_datetype=DATE&End_datetype=DATE]The reason this isn't returning any records (I think) is because you arerequireing that the date be less than or equal to the start and greaterthan or equal to the end (which is probably impossible).John.Hi Folks,I set up a test .db with start_date and end_date entries all in mm/dd/yyyy.On a sample search when I try to do a search for todays events , i.e. daterange search using[Search db=dkmweb.db&lestart_datedatarq=[mathDATE]{[Date]}[/math]&geEnd_datedatarq=[mathDATE]{[Date]}[/math]&Start_datetype=DATE&End_datetype=DATE]I get no matches and if I remove the 'rq' parts of the context i get allresults.Can anybody point out the error of my ways:-)Thanks in advance.Regards,****************************************************************Micheal O Sewww.elive.ie Internet Hosting Servicemicheal@elive.ie Database powered websites**************************************************************** John A. Hill, V.P. Marketing Pacific Coast SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
You don't need to enclose the date your searching for in the math contextunless you plan on manipulating the date somehow. This works the same way:[Searchdb=dkmweb.db&lestart_datedatarq=
[date]&geEnd_datedatarq=
[date]&Start_datetype=DATE&End_datetype=DATE]The reason this isn't returning any records (I think) is because you arerequireing that the date be less than or equal to the start and greaterthan or equal to the end (which is probably impossible).John.Hi Folks,I set up a test .db with start_date and end_date entries all in mm/dd/yyyy.On a sample search when I try to do a search for todays events , i.e. daterange search using[Search db=dkmweb.db&lestart_datedatarq=[mathDATE]{
[date]}[/math]&geEnd_datedatarq=[mathDATE]{
[date]}[/math]&Start_datetype=DATE&End_datetype=DATE]I get no matches and if I remove the 'rq' parts of the context i get allresults.Can anybody point out the error of my ways:-)Thanks in advance.Regards,****************************************************************Micheal O Sewww.elive.ie Internet Hosting Servicemicheal@elive.ie Database powered websites**************************************************************** John A. Hill, V.P. Marketing Pacific Coast SoftwareeCommerce / Web Developer Tools http://www.smithmicro.com
John Hill
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:
Can I determine where they are coming from? (2000)
Sendmail: bounced e-mails (2001)
Server crash (1997)
selecting multiple found items (1997)
[protect] (2000)
Confused about QTY and QTY* price updating (1998)
Frames and WebCat (1997)
Appending with +1 ... (1997)
Trouble with Netscape (1998)
Templates for Customer Database? (1997)
RE: Explorer oddities (1997)
WebMerchant Error (1998)
primer/tutorial question (2004)
Problems w/ heavy use of cart header fields? (1998)
Hosting Services (1999)
Searching a field and returning the highest value (1997)
SSL and Webstar 3 with Webcatalog (1998)
Dealer Locator (2008)
Help name our technology! I found it (1997)
Help! WebCat2 bug (1997)