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:
[WebDNA] Fwd: RETS... HELP! (2009)
Writing encrypted files causes errors ... (1998)
WebCat2 beta 11 - new prefs ... (1997)
RE: Supressing Error Messages (1998)
RE: type 2 errors with ssl server (1997)
Don't know if this is a silly question... (2003)
searchable list archive (1997)
WC2/Mac -- Forms not submitting correctly with Mac browsers (1997)
this year (2000)
Selected Item in Pop-down (2003)
Storeless in Seattle... (1998)
Nav4 not specifying cart (1997)
Looking for WebCat developer/contractor (2000)
[WriteFile] problems (1997)
RE: Contexts and Ampersands (1997)
2.1b3 --> way slow (1997)
WebCat2 - [format thousands] (1997)
Mac: [ListFiles] bug alert (1997)
[ShowNext] feature in 2.0 (1997)
Sort Order on a page search (1997)