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:

    
  1. Re: Searching the same field with 2 form variables. (MARC MALACARME 2000)
  2. Re: Searching the same field with 2 form variables. (Marty Schmid 2000)
  3. Re: Searching the same field with 2 form variables. (Marty Schmid 2000)
  4. Re: Searching the same field with 2 form variables. (MARC MALACARME 2000)
  5. Searching the same field with 2 form variables. (MARC MALACARME 2000)
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)