Re: [WebDNA] Nested Searches

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110887
interpreted = N
texte = Hi, I'm still having a problem with my nested searches. The searches are working and I can display the data from inside of the = inner search. But I still cannot test for a variable inside of the inner search using = a field name from the second database.=20 Database fields are: SSKU2CR_NAMEFCR_NAMEL= ASSIGNMENT1 Data is=20 5001StephenBraunProperties [showif [CR_NAMEL]=3DBraun] some code [/showif] works fine. [showif [ASSIGNMENT1]=3DProperties] some code [/showif] won't = work at all. I am stumped. Any ideas? Thanks, sfb On Nov 18, 2013, at 9:52 PM, Gary Krockover = wrote: > Would it also not be wise to [url] the search comparisons in case the = values > have funky characters in them? >=20 > 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? >=20 > My WebDNA is rusty, so take it for what it's worth: >=20 > [search > = db=3D../signin/data/signin.db&grSSKUdatarq=3D1&asSTUDENT_NAMELsort=3D1&asS= TUDENT_N > AMEFsort=3D2] > [text show=3Df]RBN_ASSIGNMENT=3Dnada[/text] > [founditems] > [search > = db=3Drecordsbyname.db&geSSKU2datarq=3D1&eqCR_NAMEFdata=3D[STUDENT_NAMEF]&e= qCR_NAME > Ldatarq=3D[STUDENT_NAMEL]] > [founditems] > [showif > [Url][STUDENT_NAMEF][/Url]=3D[CR_NAMEF]] HERE 1=20 > [showif > [Url][STUDENT_NAMEL][/Url]=3D[CR_NAMEL]] HERE 2 >   Output > Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
=20 > [showif > [Url][RBN_ASSIGNMENT][/Url]=3DMakeup] =20 > =09 > HERE 3 > = [/showif]=20 > [/showif]=20 > [/showif] > [/founditems][/search] > [/founditems][/search] >=20 > -----Original Message----- > From: Terry Nair [mailto:terrynair@prism4u.com]=20 > Sent: Monday, November 18, 2013 4:05 PM > To: talk@webdna.us > Subject: RE: [WebDNA] Nested Searches >=20 > There is a "&" missing where ^^^ is shown .... > db=3Drecordsbyname.db&geSSKU2data=3D1 ^^^ eqCR_NAMEFdata >=20 > -----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 >=20 > Hi everyone. > I had nested searches that worked fine for several years, and now they = have > stopped. >=20 > 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. >=20 > 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 >=20 >=20 >=20 >=20 > [search > = db=3D../signin/data/signin.db&grSSKUdata=3D1&asSTUDENT_NAMELsort=3D1&asSTU= DENT_NAM > EFsort=3D2][founditems] > [search > = db=3Drecordsbyname.db&geSSKU2data=3D1eqCR_NAMEFdata=3D[STUDENT_NAMEF]&eqCR= _NAMELda > tarq=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 > =09 > HERE 3 > = [/showif]=20 > [/showif]=20 > [/showif] =20 > [/founditems][/search] > = [/founditems][/search]----------------------------------------------------= -- >=20 >=20 > --------------------------------------------------------- > 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)
  11. [WebDNA] Nested Searches (Stephen Braun 2013)
Hi, I'm still having a problem with my nested searches. The searches are working and I can display the data from inside of the = inner search. But I still cannot test for a variable inside of the inner search using = a field name from the second database.=20 Database fields are: SSKU2CR_NAMEFCR_NAMEL= ASSIGNMENT1 Data is=20 5001StephenBraunProperties [showif [CR_NAMEL]=3DBraun] some code [/showif] works fine. [showif [ASSIGNMENT1]=3DProperties] some code [/showif] won't = work at all. I am stumped. Any ideas? Thanks, sfb On Nov 18, 2013, at 9:52 PM, Gary Krockover = wrote: > Would it also not be wise to [url] the search comparisons in case the = values > have funky characters in them? >=20 > 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? >=20 > My WebDNA is rusty, so take it for what it's worth: >=20 > [search > = db=3D../signin/data/signin.db&grSSKUdatarq=3D1&asSTUDENT_NAMELsort=3D1&asS= TUDENT_N > AMEFsort=3D2] > [text show=3Df]RBN_ASSIGNMENT=3Dnada[/text] > [founditems] > [search > = db=3Drecordsbyname.db&geSSKU2datarq=3D1&eqCR_NAMEFdata=3D[STUDENT_NAMEF]&e= qCR_NAME > Ldatarq=3D[STUDENT_NAMEL]] > [founditems] > [showif > [url][STUDENT_NAMEF][/Url]=3D[CR_NAMEF]] HERE 1=20 > [showif > [url][STUDENT_NAMEL][/Url]=3D[CR_NAMEL]] HERE 2 >   Output > Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
=20 > [showif > [url][RBN_ASSIGNMENT][/Url]=3DMakeup] =20 > =09 > HERE 3 > = [/showif]=20 > [/showif]=20 > [/showif] > [/founditems][/search] > [/founditems][/search] >=20 > -----Original Message----- > From: Terry Nair [mailto:terrynair@prism4u.com]=20 > Sent: Monday, November 18, 2013 4:05 PM > To: talk@webdna.us > Subject: RE: [WebDNA] Nested Searches >=20 > There is a "&" missing where ^^^ is shown .... > db=3Drecordsbyname.db&geSSKU2data=3D1 ^^^ eqCR_NAMEFdata >=20 > -----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 >=20 > Hi everyone. > I had nested searches that worked fine for several years, and now they = have > stopped. >=20 > 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. >=20 > 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 >=20 >=20 >=20 >=20 > [search > = db=3D../signin/data/signin.db&grSSKUdata=3D1&asSTUDENT_NAMELsort=3D1&asSTU= DENT_NAM > EFsort=3D2][founditems] > [search > = db=3Drecordsbyname.db&geSSKU2data=3D1eqCR_NAMEFdata=3D[STUDENT_NAMEF]&eqCR= _NAMELda > tarq=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 > =09 > HERE 3 > = [/showif]=20 > [/showif]=20 > [/showif] =20 > [/founditems][/search] > = [/founditems][/search]----------------------------------------------------= -- >=20 >=20 > --------------------------------------------------------- > 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 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:

Location of Webcat site in folder hierarchy (1997) Emailer setup (1997) Clear command and ShoppingCart.tmpl (1997) E-Mailer (WebCatb15acgiMac) (1997) WebCatalog 4.0.1b1 is now available (2000) Two stores, one server (1998) Don't tick me off :) [elaspedtime] (1997) Sort Order on a page search (1997) Writing custom WebCat searches?? (2000) [setLineItem] does not work. (1998) WebCat2b13MacPlugin - nested [xxx] contexts (1997) Separate SSL Server (1997) Need some Java Script Code (2003) authenticate and password (1998) WebCat2_Mac RETURNs in .db (1997) WebCat2 - [format thousands] (1997) Sending Email (2004) multiple credit card merchant accounts/processors (1997) PhotoMill -> PhotoMaster (1997) Uh...can someone help me out with the b10? (1997)