Re: Searching the same field with 2 form variables.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33338
interpreted = N
texte = Thanks, much appreciated.Marty Schmid wrote:> Ok, are you looking for a precise date (07/01/2000 ) or are you looking for> for a date range (like show everything that shipped in July)?>> If you are looking for a precise date then add the the_day pulldown and> and add it to the combined arguement and since you're looking for a real> date then specify that in the arguement as well. Its probably easier to> understand if you set a date variable from your pulldowns and search upon> it.> As in:> [text]mydate=[the_month]/[the_day]/[the_year][/text]> then search like: [search> db=my.db&Date_shippedtype=date&eqDate_shippeddatarq=[mydate]]>> If you are trying to use a range search then you'll have to set seperate> variables for the the starting & ending values which you'll use in your> range arguement. Same concept as above but you'll set an additional value.> Once you get used to using varibles everything will get much easier.>> Also, get in the habit of setting values on one page and passing these> values to a second page which contains the actual [search] - and always use> contexts instead of commands. It will make your life much easier and your> sites more secure.>> HTH> Marty Schmid>> >>>> >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/2000> >> >Marty 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/>> -------------------------------------------------------------> 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, much appreciated.Marty Schmid wrote:> Ok, are you looking for a precise date (07/01/2000 ) or are you looking for> for a date range (like show everything that shipped in July)?>> If you are looking for a precise date then add the the_day pulldown and> and add it to the combined arguement and since you're looking for a real> date then specify that in the arguement as well. Its probably easier to> understand if you set a date variable from your pulldowns and search upon> it.> As in:> [text]mydate=[the_month]/[the_day]/[the_year][/text]> then search like: [search> db=my.db&Date_shippedtype=date&eqDate_shippeddatarq=[mydate]]>> If you are trying to use a range search then you'll have to set seperate> variables for the the starting & ending values which you'll use in your> range arguement. Same concept as above but you'll set an additional value.> Once you get used to using varibles everything will get much easier.>> Also, get in the habit of setting values on one page and passing these> values to a second page which contains the actual [search] - and always use> contexts instead of commands. It will make your life much easier and your> sites more secure.>> HTH> Marty Schmid>> >>>> >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/2000> >> >Marty 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/>> -------------------------------------------------------------> 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:
Need relative path explanation (1997)
Date search - yes or no (1997)
Test (2002)
New WebCatalog Version !!! (1997)
OT: Processor Speed (2002)
Interfacing WebMerchant to www.fedex.com (1997)
database size? (1997)
WebCat2 - storing unformatted date data? (1997)
Up and running ... at last !! (1997)
Cannot calculate prices (1997)
WebCat chatroom (1997)
Interpret Around Contexts? (2000)
ShowNext Context (2004)
SKU (1997)
[LOOKUP] (1997)
HTTP header line is too long? (1997)
rename a file (1997)
More on the email templates (1997)
[sendmail] on NT? (1997)
ImageMagick on OSX (2003)