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:
Duplicate Items in the Cart (1998)
Databases (2000)
Shopping Cart Problem (1998)
stray LF character in the email (2003)
Variables not being passed *back* (2000)
Searching multiple fields from one form field (1997)
[WebDNA] Serial numbers and pricing for WebDNA 7.0 (2011)
bug in wn searching NT version? (1997)
Sendmail and textarea (1998)
Ooops-Serial Number for NT (1997)
newcart (1997)
[WebDNA] [TEXT] limit (2019)
NT Woes (1997)
DataBaseHelper Flawed (1997)
WebCatalog2 Feature Feedback (1996)
ThreadMem ignored? (1998)
newbie Q: [cart] documentation (1999)
[WebDNA] Receive JSON POST (2019)
WebCat B13 Mac CGI -- Frames question (1997)
Success Stories (1997)