RE: [WebDNA] Nested Searches

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110876
interpreted = N
texte = 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]------------------------------------------------------ --- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Nested Searches (Stephen Braun 2013)
  2. Re: [WebDNA] Nested Searches (WebDNA 2013)
  3. Re: [WebDNA] Nested Searches ("Brian B. Burton" 2013)
  4. Re: [WebDNA] Nested Searches (Eddie Z 2013)
  5. Re: [WebDNA] Nested Searches (Stephen Braun 2013)
  6. Re: [WebDNA] Nested Searches ("Terry Wilson" 2013)
  7. Re: [WebDNA] Nested Searches (Stuart Tremain 2013)
  8. Re: [WebDNA] Nested Searches (Stephen Braun 2013)
  9. RE: [WebDNA] Nested Searches ("Gary Krockover" 2013)
  10. RE: [WebDNA] Nested Searches ("Terry Nair" 2013)
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]------------------------------------------------------ --- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us "Terry Nair"

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:

Apache 2.2 (2007) Only charge card when product shipped ? (1997) Bug in WebCat, (2000) GoLive CyberStudio 1.0.1 (1997) Browser Resolution (test test test) (1999) Newbie Progress! (2000) Shipping calculations (1997) Auto entering Friday's date in a field (2002) syntax question, not in online refernce (1997) Sendmail (1997) [listfiles] with max? (2000) Symantec VIsual Page 1.0.3 (1997) WebCatalog2 Feature Feedback (1996) Emailer (1997) [thisurl] (2004) I need to get a [grep] (2003) Fun with Dates - revisited (1997) Hosting Service (1998) WebCat2final1 crashes (1997) Separate SSL Server (1997)