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. =20 That makes me wonder if there are other operators that I don't know. Thanks, sfb On 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: >> 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 >=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. =20 That makes me wonder if there are other operators that I don't know. Thanks, sfb On 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: >> 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 >=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:
Postdata expired from cache (2004)
WebCat for Site Search? (1997)
SiteEditPro (1996)
Need Sample Template - just purchased (1997)
Emailer Set Up (1997)
Spiders (1998)
Upgrade to WebCat2 from Commerce Lite (1997)
: fyi: getting ODBC MySQL ready for WebCat (2001)
taxTotal, grandTotal (1997)
Replace context problem ... (1997)
WCS Newbie question (1997)
WebCat B13 Mac CGI -- Frames question (1997)
bug in wn searching NT version? (1997)
TinyStore Question (1999)
Append command (2000)
[ShowIf] a either fields are blank (1998)
Country & Ship-to address & other fields ? (1997)
File Upload (1997)
Hosting Options (2000)
OrderFile (2000)