Re: Searching the same field with 2 form variables.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33336
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
Marty Schmid
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:
Problem with version 4 browsers (1998)
my price won't move (1997)
Linebreak as a delimiter in listwords? (2003)
Emailer [cart] file names (1997)
Going to anchors within a template page (1997)
Online reference (1997)
SQL connection - Solved (2000)
Serial Number Question (1997)
webDNA and ASP pages (1997)
Include files (1998)
New Site Announcement (1998)
Search wbrk (repost) (2001)
(1997)
default value from Lookup (was Grant, please help me) (1997)
different show next (1997)
Cookies and webcat (1997)
Bulk Email >>>>Any ideas? (2001)
Writing to disk (1999)
shipcost - fed up with the old way (1998)
WebCatalog for guestbook ? (1997)