Re: Searching the same field with 2 form variables.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33335
interpreted = N
texte = Thanks for the hand its much appreciated after close to 11 hours of monitor on I think a sunday.Yes I am using a real date in the form 07/01/2000Marty Schmid wrote:> Ok, I assume that this is what you have: > A pulldown which establishes the month you are looking for - lets rename it > the_month > A pulldown which establishes the year you are looking for - lets rename it > the_year > A single database field which contains a combined date value (ie: 7/2000) > > If so then your search should be for a a value which is a combination of > the month & year values. > Like so: [search db=my.db&eqDate_shippeddatarq=[the_month]/[the_year]] > > All this is assuming that you are storing the Date_shipped values literally > as [the_month]/[the_year] so you are really executing a text string style > of search. If you are storing the value as a real date value (ie: > 07/01/2000) than you have to change your arguements and treat everything as > real dates . I don't want to confuse you by getting into all that so I > won't unless you need it. > > Hope that helps > Marty Schmid > > >I'm trying to search a date field by month/year. using a form,. I read > >example 3 in the search grouping Fields but I can't make heads or > >tails of it. > >I trying to allow the cleint to use a pulldown for month and a pulldown > >for year to search on field > >Date in the form DD/MM/YYYY. > > > >I've been trying to crack this one for about an hour with no luck. Help > > > > > > > >I have: > > > >
> > > > > >------------------------------------------------------------- > >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://search.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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thanks for the hand its much appreciated after close to 11 hours of monitor on I think a sunday.Yes I am using a real date in the form 07/01/2000Marty Schmid wrote:> Ok, I assume that this is what you have: > A pulldown which establishes the month you are looking for - lets rename it > the_month > A pulldown which establishes the year you are looking for - lets rename it > the_year > A single database field which contains a combined date value (ie: 7/2000) > > If so then your search should be for a a value which is a combination of > the month & year values. > Like so: [search db=my.db&eqDate_shippeddatarq=[the_month]/[the_year]] > > All this is assuming that you are storing the Date_shipped values literally > as [the_month]/[the_year] so you are really executing a text string style > of search. If you are storing the value as a real date value (ie: > 07/01/2000) than you have to change your arguements and treat everything as > real dates . I don't want to confuse you by getting into all that so I > won't unless you need it. > > Hope that helps > Marty Schmid > > >I'm trying to search a date field by month/year. using a form,. I read > >example 3 in the search grouping Fields but I can't make heads or > >tails of it. > >I trying to allow the cleint to use a pulldown for month and a pulldown > >for year to search on field > >Date in the form DD/MM/YYYY. > > > >I've been trying to crack this one for about an hour with no luck. Help > > > > > > > >I have: > > > > > > > > > >------------------------------------------------------------- > >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://search.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://search.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://search.smithmicro.com/
MARC MALACARME
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:
Quickie question on the email templates (1997)
Multiple Users.db Possible? (1997)
Bug? (1997)
Strange Search Results (2004)
WC1.6 to WC2 date formatting (1997)
special commerce fields (1997)
Help! WebCat2 bug (1997)
using showpage and showcart commands (1996)
Execute Applescript (1997)
[WebDNA] Upgrade from OS 10.7.5 WebDNA 6.2 to Mavericks (2014)
[WebDNA] Google Cloud (2014)
WebCat2b15MacPlugin - [protect] (1997)
Internal server error (2004)
WebCat2 - Getting to the browser's username/password data (1997)
Emailer (1997)
WebCatalog can't find database (1997)
show all problem (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
[input]?? (1998)
Problems with [Search] param - Mac Plugin b15 (1997)