Re: Help with searching dates from mysql dump & searching
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 68102
interpreted = N
texte = Thanks Grant! Been a loooong time.The sorting works fine now. The searching partly. This works[...&geCREATE_DATEdatarq=[eventStartDate]...]It finds records in the DB that are greater than or equal to theeventStartDate. However, when I add the following to create an upper limit,I get no search results:[...&geCREATE_DATEdatarq=[eventStartDate]&leEND_DATEdatarq=[eventEndDate]...]And this also produces no results (taking out the first date searchparameter)[...&leEND_DATEdatarq=[eventEndDate]...]So, it seems that I can't get a less than or equal to an end date. Is thisbecause the data in the field has both a date and time?Also tried to manually put in dummy time data([...&leEND_DATEdatarq=[eventEndDate] 00:00:00&...]) which didn't work.Mahalo, Olin-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfGrant HulbertSent: Sunday, November 05, 2006 8:23 AMTo: WebDNA TalkSubject: Re: Help with searching dates from mysql dump & searching betweendatesYour raw date field is already a canonically-sortable string, so it doesn'tneed to be converted to a date type. Remove the&CREATE_DATEtype=date&END_DATEtype=date in order to make WebDNA interpretthose fields as plain text.> [search> db=EVENT.db&leEND_DATEdatarq=[year]-[pickMonth]-[index]&geCREATE_DATEd> atarq= > [year]-[pickMonth]-[index]&CREATE_DATEtype=date&END_DATEtype=date]> -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thanks Grant! Been a loooong time.The sorting works fine now. The searching partly. This works[...&geCREATE_DATEdatarq=[eventStartDate]...]It finds records in the DB that are greater than or equal to theeventStartDate. However, when I add the following to create an upper limit,I get no search results:[...&geCREATE_DATEdatarq=[eventStartDate]&leEND_DATEdatarq=[eventEndDate]...]And this also produces no results (taking out the first date searchparameter)[...&leEND_DATEdatarq=[eventEndDate]...]So, it seems that I can't get a less than or equal to an end date. Is thisbecause the data in the field has both a date and time?Also tried to manually put in dummy time data([...&leEND_DATEdatarq=[eventEndDate] 00:00:00&...]) which didn't work.Mahalo, Olin-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf OfGrant HulbertSent: Sunday, November 05, 2006 8:23 AMTo: WebDNA TalkSubject: Re: Help with searching dates from mysql dump & searching betweendatesYour raw date field is already a canonically-sortable string, so it doesn'tneed to be converted to a date type. Remove the&CREATE_DATEtype=date&END_DATEtype=date in order to make WebDNA interpretthose fields as plain text.> [search> db=EVENT.db&leEND_DATEdatarq=[year]-[pickMonth]-[index]&geCREATE_DATEd> atarq= > [year]-[pickMonth]-[index]&CREATE_DATEtype=date&END_DATEtype=date]> -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Olin Lagon"
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:
upgrade? (1997)
Banners (1997)
FoundItems Question (1998)
Format all of a sudden doesn't work (1997)
Exclamation point (1997)
Creating main- and sub-category search (1997)
Error 11 (1996)
Banners (1997)
Re:quit command on NT (1997)
Help! WebCat2 bug (1997)
search engine friendly URLS (Mac) and Lycos! (1998)
Help! WebCat2 bug (1997)
Conditional searching & displaying (1997)
syntax question, not in online refernce (1997)
PCS Frames (1997)
Append File help needed: example (2000)
[WebDNA] Mailing list failure !!! (2019)
Re2: frames & carts (1997)
Template Security error (1997)
Problem during evaluation of WebCatalog (1998)