Re: [WebDNA] Nested Searches
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110948
interpreted = N
texte = So why does [showif [ASSIGNMENT1]^Properties] some code [/showif] = work, and [showif [ASSIGNMENT1]=3DProperties] some =other code [/showif] does not work.What is the mathematical operation of the ^ symbol?I've never used it before. =20That makes me wonder if there are other operators that I don't know.Thanks,sfbOn Nov 26, 2013, at 4:54 PM, Stuart Tremain
wrote:> try this>=20> [showif [ASSIGNMENT1]^Properties] some code [/showif]>=20> Using contains may prove that you have some white space in your data.>=20>=20>=20>=20>=20> On 27 Nov 2013, at 7:41 am, Stephen Braun =wrote:>=20>> 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:>> SSKU2CR_NAMEFCR_NAMEL=ASSIGNMENT1>>=20>> Data is=20>> 5001StephenBraunProperties>>=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>=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:
So why does [showif [ASSIGNMENT1]^Properties] some code [/showif] = work, and [showif [ASSIGNMENT1]=3DProperties] some =other code [/showif] does not work.What is the mathematical operation of the ^ symbol?I've never used it before. =20That makes me wonder if there are other operators that I don't know.Thanks,sfbOn Nov 26, 2013, at 4:54 PM, Stuart Tremain wrote:> try this>=20> [showif [ASSIGNMENT1]^Properties] some code [/showif]>=20> Using contains may prove that you have some white space in your data.>=20>=20>=20>=20>=20> On 27 Nov 2013, at 7:41 am, Stephen Braun =wrote:>=20>> 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:>> SSKU2CR_NAMEFCR_NAMEL=ASSIGNMENT1>>=20>> Data is=20>> 5001StephenBraunProperties>>=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>=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:
WebCatalog v2.1.1 (1998)
Error Lob.db records error message not name (1997)
listfiles-looking for slick solution (1997)
access denied problem (1997)
emailer w/F2 (1997)
Re:Problem (1997)
[shell]? (2000)
Multiple Pulldowns (1997)
[WebDNA] Sending Email Problem (2008)
WebCat2.0 [format thousands .0f] no go (1997)
WebCatalog 2.0 b 15 mac (1997)
Quickie question on the email templates (1997)
Not really WebCat- (1997)
Autoreturn Submit? (1997)
WebCat2.0 [format thousands .0f] no go (1997)
FAX orders (1996)
Too Much Rootbeer Free Offer (1997)
Sami (1998)
[Announce] Newest Commerce Site based on WebCatalog (1997)
WCS Newbie question (1997)