[WebDNA] Nested Searches

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110875
interpreted = N
texte = 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]=20 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. =20 Any ideas would be greatly appreciated. Thank you, sfb [search = db=3D../signin/data/signin.db&grSSKUdata=3D1&asSTUDENT_NAMELsort=3D1&asSTU= DENT_NAMEFsort=3D2][founditems] [search = db=3Drecordsbyname.db&geSSKU2data=3D1eqCR_NAMEFdata=3D[STUDENT_NAMEF]&eqCR= _NAMELdatarq=3D[STUDENT_NAMEL]][founditems] [showif [STUDENT_NAMEF]=3D[CR_NAMEF]] = HERE 1=20 [showif = [STUDENT_NAMEL]=3D[CR_NAMEL]] HERE 2   Output = Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
=20 [showif = [RBN_ASSIGNMENT]=3DMakeup] =20 = HERE 3 = [/showif]=20 [/showif]=20 [/showif] =20 [/founditems][/search] [/founditems][/search]= 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)
  11. [WebDNA] Nested Searches (Stephen Braun 2013)
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]=20 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. =20 Any ideas would be greatly appreciated. Thank you, sfb [search = db=3D../signin/data/signin.db&grSSKUdata=3D1&asSTUDENT_NAMELsort=3D1&asSTU= DENT_NAMEFsort=3D2][founditems] [search = db=3Drecordsbyname.db&geSSKU2data=3D1eqCR_NAMEFdata=3D[STUDENT_NAMEF]&eqCR= _NAMELdatarq=3D[STUDENT_NAMEL]][founditems] [showif [STUDENT_NAMEF]=3D[CR_NAMEF]] = HERE 1=20 [showif = [STUDENT_NAMEL]=3D[CR_NAMEL]] HERE 2   Output = Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
=20 [showif = [RBN_ASSIGNMENT]=3DMakeup] =20 = HERE 3 = [/showif]=20 [/showif]=20 [/showif] =20 [/founditems][/search] [/founditems][/search]= Stephen Braun

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:

Emailer error 550? (1999) # fields limited? (1997) PIXO support (1997) 2.0 Beta (1997) Problems reading files created by WC (1997) search same field twice??? (1999) Help name our technology! (1997) shipCost formula (1997) OT - quiet on the list today - here's something (2004) [input] [/input] (1997) [SEARCH] Context for SKU prices not working... (1998) What does this error mean? (2000) Remove from list server (1997) won't serve .tpl (2000) How long until WebDNA makes the list? :( (2004) Building Calendars (1997) [WebDNA] WebDNA & VPS (2009) too many nested tags ... (1997) Simple way to create unique SKU (1997) Sorting search results (1998)