RE: [WebDNA] Nested Searches
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110877
interpreted = N
texte = Would it also not be wise to [url] the search comparisons in case the values have funky characters in them? Also, should the variable [RBN_ASSIGNMENT] be reset on the outer search so that it doesn't get assigned a variable that is then carried over on each iterance of the search? My WebDNA is rusty, so take it for what it's worth: [search db=../signin/data/signin.db&grSSKUdatarq=1&asSTUDENT_NAMELsort=1&asSTUDENT_N AMEFsort=2] [text show=f]RBN_ASSIGNMENT=nada[/text] [founditems] [search db=recordsbyname.db&geSSKU2datarq=1&eqCR_NAMEFdata=[STUDENT_NAMEF]&eqCR_NAME Ldatarq=[STUDENT_NAMEL]] [founditems] [showif [Url][STUDENT_NAMEF][/Url]=[CR_NAMEF]] HERE 1 [showif [Url][STUDENT_NAMEL][/Url]=[CR_NAMEL]] HERE 2 Output Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
[showif [Url][RBN_ASSIGNMENT][/Url]=Makeup] HERE 3 [/showif] [/showif] [/showif] [/founditems][/search] [/founditems][/search] -----Original Message----- From: Terry Nair [mailto:terrynair@prism4u.com] Sent: Monday, November 18, 2013 4:05 PM To: talk@webdna.us Subject: RE: [WebDNA] Nested Searches There is a "&" missing where ^^^ is shown .... db=recordsbyname.db&geSSKU2data=1 ^^^ eqCR_NAMEFdata -----Original Message----- From: Stephen Braun [mailto:sbraun1@twcny.rr.com] Sent: Tuesday, November 19, 2013 05:45 To: talk@webdna.us Subject: [WebDNA] Nested Searches Hi everyone. I had nested searches that worked fine for several years, and now they have stopped. The outside search finds [STUDENT_NAMEF] & [STUDENT_NAMEL] The inside search finds [CR_NAMEF] & [CR_NAMEL] These variables are compared both in the search, and with the [showif] commands. Everything works fine to a point.... I get the text HERE 1 and HERE 2 and the line of variables labeled Output Text. I never get the results 'HERE 3', although [RBN_ASSIGNMENT] is shown to be the word Makeup several times in the Output Text The [RBN_ASSIGNMENT] variable is in the inside search. I've been at this for a few hours, and I can't see why it's not giving me HERE 3 when the text Makeup is found. Any ideas would be greatly appreciated. Thank you, sfb [search db=../signin/data/signin.db&grSSKUdata=1&asSTUDENT_NAMELsort=1&asSTUDENT_NAM EFsort=2][founditems] [search db=recordsbyname.db&geSSKU2data=1eqCR_NAMEFdata=[STUDENT_NAMEF]&eqCR_NAMELda tarq=[STUDENT_NAMEL]][founditems] [showif [STUDENT_NAMEF]=[CR_NAMEF]] HERE 1 [showif [STUDENT_NAMEL]=[CR_NAMEL]] HERE 2 Output Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
[showif [RBN_ASSIGNMENT]=Makeup] HERE 3 [/showif] [/showif] [/showif] [/founditems][/search] [/founditems][/search]------------------------------------------------------
Associated Messages, from the most recent to the oldest:
Would it also not be wise to
[url] the search comparisons in case the values have funky characters in them? Also, should the variable [RBN_ASSIGNMENT] be reset on the outer search so that it doesn't get assigned a variable that is then carried over on each iterance of the search? My WebDNA is rusty, so take it for what it's worth: [search db=../signin/data/signin.db&grSSKUdatarq=1&asSTUDENT_NAMELsort=1&asSTUDENT_N AMEFsort=2] [text show=f]RBN_ASSIGNMENT=nada[/text]
[founditems] [search db=recordsbyname.db&geSSKU2datarq=1&eqCR_NAMEFdata=[STUDENT_NAMEF]&eqCR_NAME Ldatarq=[STUDENT_NAMEL]]
[founditems] [showif
[url][STUDENT_NAMEF][/Url]=[CR_NAMEF]] HERE 1 [showif
[url][STUDENT_NAMEL][/Url]=[CR_NAMEL]] HERE 2 Output Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
[showif
[url][RBN_ASSIGNMENT][/Url]=Makeup] HERE 3 [/showif] [/showif] [/showif] [/founditems][/search] [/founditems][/search] -----Original Message----- From: Terry Nair [mailto:terrynair@prism4u.com] Sent: Monday, November 18, 2013 4:05 PM To: talk@webdna.us Subject: RE: [WebDNA] Nested Searches There is a "&" missing where ^^^ is shown .... db=recordsbyname.db&geSSKU2data=1 ^^^ eqCR_NAMEFdata -----Original Message----- From: Stephen Braun [mailto:sbraun1@twcny.rr.com] Sent: Tuesday, November 19, 2013 05:45 To: talk@webdna.us Subject: [WebDNA] Nested Searches Hi everyone. I had nested searches that worked fine for several years, and now they have stopped. The outside search finds [STUDENT_NAMEF] & [STUDENT_NAMEL] The inside search finds [CR_NAMEF] & [CR_NAMEL] These variables are compared both in the search, and with the
[showif] commands. Everything works fine to a point.... I get the text HERE 1 and HERE 2 and the line of variables labeled Output Text. I never get the results 'HERE 3', although [RBN_ASSIGNMENT] is shown to be the word Makeup several times in the Output Text The [RBN_ASSIGNMENT] variable is in the inside search. I've been at this for a few hours, and I can't see why it's not giving me HERE 3 when the text Makeup is found. Any ideas would be greatly appreciated. Thank you, sfb [search db=../signin/data/signin.db&grSSKUdata=1&asSTUDENT_NAMELsort=1&asSTUDENT_NAM EFsort=2]
[founditems] [search db=recordsbyname.db&geSSKU2data=1eqCR_NAMEFdata=[STUDENT_NAMEF]&eqCR_NAMELda tarq=[STUDENT_NAMEL]]
[founditems] [showif [STUDENT_NAMEF]=[CR_NAMEF]] HERE 1 [showif [STUDENT_NAMEL]=[CR_NAMEL]] HERE 2 Output Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
[showif [RBN_ASSIGNMENT]=Makeup] HERE 3 [/showif] [/showif] [/showif] [/founditems][/search] [/founditems][/search]------------------------------------------------------
"Gary Krockover"
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:
Size limit for tmpl editor ? (1997)
Nested vs conditional (1997)
Delete Context - to remove record (1998)
[WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011)
[WebDNA] Wishlist: ignore whitespace in database changes (2016)
oops private message leaked into talk list (1997)
$purchase WITHOUT creditcar (1997)
WebCat virtual postcard is done! Thanks for the help! (1998)
writefile and emailer (2002)
looping table rows (1999)
[append] (1997)
Error:Too many nested [xxx] contexts (1997)
Showing unopened cart (1997)
Emailer setup (1997)
[SHOWIF]s and empty arguments (1997)
customizing the color of user's pages (1997)
Listserver problem (1997)
HELP WITH DATES (1997)
Public beta 2 for WebCatalog 4.0 is now available. (2000)
User Defined Sorting (1997)