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:
default value from Lookup (was Grant, please help me) (1997)
View order not right (1997)
(1998)
[WebDNA] Admin Login Required to Serve any TPL Page (2009)
emailer setup (1997)
help with autenticate (1998)
WC2b12: Yes, Formulas.db is for real (1997)
[WebDNA] seconds_to_time (2017)
WebCat2 - Getting to the browser's username/password data (1997)
page redirect in webDNA (1997)
Cold Fusion Buster (1997)
[WebDNA] [OT] Kickstarter feedback please? (2015)
[format 40s]text[/format] doesn't work (1997)
Bug? (1997)
Reinstalling (2001)
WebMerchant bomb (1998)
X etc.... (1999)
Hard Questions ? (1997)
Using webcat to roll apache logs (2002)
What am I missing (1997)