Re: Exclude by date - multiple

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 12005
interpreted = N
texte = >Hey WebCat brainiards...>I've got a problem thats got me stumped (not a difficult task by the way).>I have a db of events which have starting and ending dates. In my search>form I have an option to require that the search limit its results to those>that are happening during a client-supplied date range (in addition to>limiting the search by event type, keyword etc.). Ok, simple enough>everything works so far... The problem I have is that I'd also like the>search to require that the records ALWAYS have an ending date AFTER todays>date. And therein lies my problem, that is having multiple required>searches on the same field with multiple values - Here I think my problem>code will better demonstrate:>---------------------------->>>>>>----------------------------->>If I add the line: >and I select the option the limit the date range then no records are ever>returned (of course). So any ideas on how to exclude old events (and still>aloow date-range limiting) without this code? I can't use a [showif] in the>results template because I'd like my numfound statement to match the>actual records being displayed -I might be wrong on this but I believe>numfound will show the total number of matchs even if data is hidden by>showif/hideif statements. Is that correct?>>thanks for the help>-martyhave you looked at online reference searching numbers rn range: field contains two numbers separated by space, or + rnZipCodedata=92069+93090 finds all records whose ZipCode field isnumerically in the range of 92069 - 93090 mr minimum range value: if no maximum then ge is used instead xr maximum range value: if no minimum than le is used insteadif you tell it type=date then according to the docs the above should comeinto play. Using the range. I think you might be wrong cause you haveboth le and ge fighting each other and need to think mr and xr.The next question was they click on specify date range and leave the restof the fields blank or geintdatarq becomes the current date you get norecords.Maybe change your checkbox to a radio button and add another radio buttonboth with the same name, and different values. The options would be do youwant to specify a given date or use [date]. then use a showif buttonvalue=specify and place between the showif and then do another show if right below this that says showifbutton value= date then

Re: Exclude by date - multiple (Kenneth Grome 1997)
Re: Exclude by date - multiple (Marty Schmid 1997)
Re: Exclude by date - multiple (grichter@panavise.com (Gary Richter) 1997)
Exclude by date - multiple (Marty Schmid 1997)

>Hey WebCat brainiards...>I've got a problem thats got me stumped (not a difficult task by the way).>I have a db of events which have starting and ending dates. In my search>form I have an option to require that the search limit its results to those>that are happening during a client-supplied date range (in addition to>limiting the search by event type, keyword etc.). Ok, simple enough>everything works so far... The problem I have is that I'd also like the>search to require that the records ALWAYS have an ending date AFTER todays>date. And therein lies my problem, that is having multiple required>searches on the same field with multiple values - Here I think my problem>code will better demonstrate:>---------------------------->>>>>>----------------------------->>If I add the line: [date]>>and I select the option the limit the date range then no records are ever>returned (of course). So any ideas on how to exclude old events (and still>aloow date-range limiting) without this code? I can't use a [showif] in the>results template because I'd like my numfound statement to match the>actual records being displayed -I might be wrong on this but I believe>numfound will show the total number of matchs even if data is hidden by>showif/hideif statements. Is that correct?>>thanks for the help>-martyhave you looked at online reference searching numbers rn range: field contains two numbers separated by space, or + rnZipCodedata=92069+93090 finds all records whose ZipCode field isnumerically in the range of 92069 - 93090 mr minimum range value: if no maximum then ge is used instead xr maximum range value: if no minimum than le is used insteadif you tell it type=date then according to the docs the above should comeinto play. Using the range. I think you might be wrong cause you haveboth le and ge fighting each other and need to think mr and xr.The next question was they click on specify date range and leave the restof the fields blank or geintdatarq becomes the current date you get norecords.Maybe change your checkbox to a radio button and add another radio buttonboth with the same name, and different values. The options would be do youwant to specify a given date or use [date]. then use a showif buttonvalue=specify and place between the showif and then do another show if right below this that says showifbutton value= date then grichter@panavise.com (Gary Richter)

DOWNLOAD WEBDNA NOW!

Re: Exclude by date - multiple

1997

Top Articles:

Related Readings: