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:
Limiting user access to .tmpl files (1997)
Number searching/formats (1998)
WebCat2b12 - New features for 1.6 users ... (1997)
Multi-Row Tables from a search. (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Another Large Database Questions (1997)
replace problem (1999)
Trouble with formula.db (1997)
[WebDNA] Live Currency exchanege rates (2008)
Silly Question (2003)
Cart ID Duplication (2001)
Faxing orders in place of email (1997)
Width & Height (1998)
WebCat2b12plugin - [search] is broken ... not! (1997)
Public Beta for WebCatalog 4.0 is Available (2000)
Help name our technology! (1997)
Updating checkboxes made easy !!! (1998)
Multiple transactions per cart (2000)
Mail Service Dead (1998)
How to verify email address (1997)