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] png support in webDNA (2011)
WebCat2 - Getting to the browser's username/password data (1997)
Bug? (1997)
Emailer (WebCat2) (1997)
[TaxableTotal] - not working with AOL and IE (1997)
[WebDNA] Exclude found items in a 2nd search (2016)
Checkboxes (1997)
Cookies (1999)
WebCat2 - storing unformatted date data? (1997)
flushdatabases (1997)
RE: protect tag on NT (1997)
Newbie Tax Question (1997)
Sending Email (2004)
Stumpted Again (1997)
Search 1 Field Twice? (2004)
Setting up WebCatalog with Retail Pro data (1996)
Extended [ConvertChars] (1997)
send mail problem? (1997)
Return records from another (1997)
possible, WebCat2.0 and checkboxes-restated (1997)