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:

Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006) Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006) Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006) Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006) Re: Help with searching dates from mysql dump & searching ( Gary Krockover 2006) Re: Help with searching dates from mysql dump & searching ( "Olin Lagon" 2006) Re: Help with searching dates from mysql dump & searching ( Grant Hulbert 2006) Help with searching dates from mysql dump & searching between ( "Olin Lagon" 2006)

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:

Hiding the URL(was Cart ID Duplication) (2001) Carts in Admin folder? (1999) [sendmail] and [formvariables] (1997) Trouble with Showif and Search (1998) WC2/Mac -- Forms not submitting correctly with Mac browsers (1997) Not reading blanks (1998) authenticating a second user (1997) webcat- multiple selection in input field (1997) Feature request for next version (2005) question: webmerchant connection (1997) DB Updates don't take (1998) How to add product size choices to form? (1997) Out of the woodwork (2007) [sendmail] on NT? (1997) More questions about serial number dishing (1997) emailer (1997) WebCatalog Mac and cgi-bin (WebSTAR 2.0) (1997) WebDNA Grep help wanted (2004) problems with 2 tags (1997) Generating Report Totals (1997)