Re: more trouble with [showif] in [search] = busted [shownext]
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 28555
interpreted = N
texte = Ken I added 'RequireAffil' to the shownext link as you suggested, but it still behaves as I described before (see below)I believe you you it is simple, but I can't see this one... Arrrg!Could you have a look, please-JohnHere's the shownext which follows the search shown below-[shownext]
Show found orders [start]-[end][/shownext]I have a search context which finds orders within a date range input by the admin on theprevious page. The founditems are further restricted in that they are required to containthe passed value for [AffilCode] (in the field AffilCode) if the admin has checked acheckbox named RequireAffil.(carriage returns added for clarity)[Search db=Orders-Main.db&mrDayOrdereddatarq=[mrDayOrdereddatarq]&xrDayOrdereddatarq=[xrDayOrdereddatarq][showif [URL][RequireAffil][/URL]=yes]&eqAffilCodedatarq=[AffilCode][/showif]&max=[max]&startat=[start]&DayOrderedtype=date&TimeOrderedtype=time&DayOrderedsort=1&TimeOrderedsort=2&DayOrderedsdir=de&TimeOrderedsdir=de&no_cache=[random][random][random]]This works great except that when a [shownext] link is clicked then upon rerendering thepage based on the new [start] value, the founditems are no longer restricted by theoriginally passed formvariable AffilCode. It finds any record within the date rangewith ANY AffilCode. Why? Perhaps in addition to just posting the fix, could some kindsoul please explain all the principles involved in using [shownext] correctly... I keepgetting stumped with them.Kenneth Grome wrote:> >could some kind> >soul please explain all the principles involved in using [shownext] correctly... I keep> >getting stumped with them.>> All you have to do is use [formvariables][name]=[value][/formvariables] to display a list of all the formvariables passed into the page, then duplicate those same variables in your shownext links so they are sent AGAIN to the page when you click a shownext link.>> Of course this assumes that all the parameters are always passed to the next page, but checkboxes are not passed unless they are checked. You probably forgot to add the checkbox parameter to your shownext links ...>> ================================> Kenneth Grome, WebDNA Consultant> 808-737-6499 http://webdna.net> ================================>> -------------------------------------------------------------> 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 -------------------------------------------------------------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
Associated Messages, from the most recent to the oldest:
Ken I added 'RequireAffil' to the shownext link as you suggested, but it still behaves as I described before (see below)I believe you you it is simple, but I can't see this one... Arrrg!Could you have a look, please-JohnHere's the shownext which follows the search shown below-[shownext][url][RequireAffil][/URL]&start=[start]&no_cache=[date %Y%m%d%m%S]>Show found orders [start]-[end]
[/shownext]I have a search context which finds orders within a date range input by the admin on theprevious page. The founditems are further restricted in that they are required to containthe passed value for [AffilCode] (in the field AffilCode) if the admin has checked acheckbox named RequireAffil.(carriage returns added for clarity)[Search db=Orders-Main.db&mrDayOrdereddatarq=[mrDayOrdereddatarq]&xrDayOrdereddatarq=[xrDayOrdereddatarq][showif [url][RequireAffil][/URL]=yes]&eqAffilCodedatarq=[AffilCode][/showif]&max=[max]&startat=[start]&DayOrderedtype=date&TimeOrderedtype=time&DayOrderedsort=1&TimeOrderedsort=2&DayOrderedsdir=de&TimeOrderedsdir=de&no_cache=[random][random][random]]This works great except that when a [shownext] link is clicked then upon rerendering thepage based on the new [start] value, the founditems are no longer restricted by theoriginally passed formvariable AffilCode. It finds any record within the date rangewith ANY AffilCode. Why? Perhaps in addition to just posting the fix, could some kindsoul please explain all the principles involved in using [shownext] correctly... I keepgetting stumped with them.Kenneth Grome wrote:> >could some kind> >soul please explain all the principles involved in using [shownext] correctly... I keep> >getting stumped with them.>> All you have to do is use [formvariables][name]=[value][/formvariables] to display a list of all the formvariables passed into the page, then duplicate those same variables in your shownext links so they are sent AGAIN to the page when you click a shownext link.>> Of course this assumes that all the parameters are always passed to the next page, but checkboxes are not passed unless they are checked. You probably forgot to add the checkbox parameter to your shownext links ...>> ================================> Kenneth Grome, WebDNA Consultant> 808-737-6499 http://webdna.net> ================================>> -------------------------------------------------------------> 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 -------------------------------------------------------------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
John Butler
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:
Document Contains No Data! (1997)
Arbitrary limits on length of data in cart header fields? (2000)
duplicate cart numbers (2002)
[WebDNA] Nginx (2010)
[SHOWIF]s and empty arguments (1997)
Sorting LISTFILES (1997)
Problem with a search context (2005)
ShowNext Command (1997)
Formvariables + Netscape + Frame Set = Confusion (2000)
WebCatalog Technical Reference (1997)
Search technique question (1998)
[WebDNA] Problem saving returned value as a variable (2012)
[isfolder] and [filename] (1997)
Listserver problem (1997)
includes and cart numbers (1997)
Template transformed itself into a database? (1998)
Size limit for tmpl editor ? (1997)
Emailer (1997)
Order not created error (never mind) (1997)
Return records from another (1997)