Re: [WebDNA] Nested Searches
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110888
interpreted = N
texte = try this [showif [ASSIGNMENT1]^Properties] some code [/showif] Using contains may prove that you have some white space in your data. On 27 Nov 2013, at 7:41 am, Stephen Braun
wrote: > 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 >=20 > Database fields are: > SSKU2 CR_NAMEF CR_NAMEL = ASSIGNMENT1 >=20 > Data is=20 > 5001 Stephen Braun Properties >=20 > [showif [CR_NAMEL]=3DBraun] some code [/showif] works fine. > [showif [ASSIGNMENT1]=3DProperties] some code [/showif] won't = work at all. I am stumped. >=20 > Any ideas? >=20 > Thanks, > sfb >=20 >=20 >=20 > On Nov 18, 2013, at 9:52 PM, Gary Krockover = wrote: >=20 >> 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 >=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:
try this [showif [ASSIGNMENT1]^Properties] some code [/showif] Using contains may prove that you have some white space in your data. On 27 Nov 2013, at 7:41 am, Stephen Braun wrote: > 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 >=20 > Database fields are: > SSKU2 CR_NAMEF CR_NAMEL = ASSIGNMENT1 >=20 > Data is=20 > 5001 Stephen Braun Properties >=20 > [showif [CR_NAMEL]=3DBraun] some code [/showif] works fine. > [showif [ASSIGNMENT1]=3DProperties] some code [/showif] won't = work at all. I am stumped. >=20 > Any ideas? >=20 > Thanks, > sfb >=20 >=20 >=20 > On Nov 18, 2013, at 9:52 PM, Gary Krockover = wrote: >=20 >> 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 >=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
Stuart Tremain
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:
nesting limits? (1998)
WebTEN vs webSTAR (1998)
Special characters & [sendmail] (1998)
docs for WebCatalog2 (1997)
Secure server question (1997)
Off Topic: Frames Killer? (1998)
how to include a name in from or to using Sendmail? (2003)
Problem with summary on date / inconsequent webcat behaviour (1998)
Permissions (once again) (2003)
Security Issues and WebCommerce Solution (1997)
WebCat/CyberStudio Compatibility (1998)
Separate SSL Server (1997)
[OT] was SQL Query Question (2001)
WCS Newbie question (1997)
problems with 2 tags (1997)
Webcatalog and foreign languages (1998)
WebStar Secure on other machine (1997)
Hello??? (1997)
WebCat2final1 crashes (1997)
Paths, relative paths, webstar server setup and security (Mac) (1997)