Re: [WebDNA] Nested Searches
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110949
interpreted = N
texte = It just means contains. So it would show you any instance of [ASSIGNMENT1] that includes Properties in it. It could be Properties A, Propertieszzzz, or just Properties. On 12/2/13 12:53 PM, "Stephen Braun"
wrote: >So why does [showif [ASSIGNMENT1]^Properties] some code [/showif] > work, and > [showif [ASSIGNMENT1]=Properties] some other >code [/showif] does not work. > >What is the mathematical operation of the ^ symbol? >I've never used it before. >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 >> >> [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. >>> >>> Database fields are: >>> SSKU2 CR_NAMEF CR_NAMEL ASSIGNMENT1 >>> >>> Data is >>> 5001 Stephen Braun Properties >>> >>> [showif [CR_NAMEL]=Braun] some code [/showif] works fine. >>> [showif [ASSIGNMENT1]=Properties] 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? >>>> >>>> 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? >>>> >>>> My WebDNA is rusty, so take it for what it's worth: >>>> >>>> [search >>>> >>>>db=../signin/data/signin.db&grSSKUdatarq=1&asSTUDENT_NAMELsort=1&asSTUD >>>>ENT_N >>>> AMEFsort=2] >>>> [text show=f]RBN_ASSIGNMENT=nada[/text] >>>> [founditems] >>>> [search >>>> >>>>db=recordsbyname.db&geSSKU2datarq=1&eqCR_NAMEFdata=[STUDENT_NAMEF]&eqCR >>>>_NAME >>>> Ldatarq=[STUDENT_NAMEL]] >>>> [founditems] >>>> [showif >>>> [Url][STUDENT_NAMEF][/Url]=[CR_NAMEF]] HERE 1 >>>> [showif >>>> [Url][STUDENT_NAMEL][/Url]=[CR_NAMEL]] HERE 2 >>>> Output >>>> Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
>>>> [showif >>>> [Url][RBN_ASSIGNMENT][/Url]=Makeup] >>>> >>>> HERE 3 >>>> [/showif] >>>> [/showif] >>>> [/showif] >>>> [/founditems][/search] >>>> [/founditems][/search] >>>> >>>> -----Original Message----- >>>> From: Terry Nair [mailto:terrynair@prism4u.com] >>>> Sent: Monday, November 18, 2013 4:05 PM >>>> To: talk@webdna.us >>>> Subject: RE: [WebDNA] Nested Searches >>>> >>>> There is a "&" missing where ^^^ is shown .... >>>> db=recordsbyname.db&geSSKU2data=1 ^^^ eqCR_NAMEFdata >>>> >>>> -----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 >>>> >>>> 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] 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. >>>> Any ideas would be greatly appreciated. >>>> Thank you, >>>> sfb >>>> >>>> >>>> >>>> >>>> [search >>>> >>>>db=../signin/data/signin.db&grSSKUdata=1&asSTUDENT_NAMELsort=1&asSTUDEN >>>>T_NAM >>>> EFsort=2][founditems] >>>> [search >>>> >>>>db=recordsbyname.db&geSSKU2data=1eqCR_NAMEFdata=[STUDENT_NAMEF]&eqCR_NA >>>>MELda >>>> tarq=[STUDENT_NAMEL]][founditems] >>>> [showif [STUDENT_NAMEF]=[CR_NAMEF]] HERE 1 >>>> [showif >>>> [STUDENT_NAMEL]=[CR_NAMEL]] HERE 2 >>>> Output >>>> Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
>>>> [showif >>>> [RBN_ASSIGNMENT]=Makeup] >>>> >>>> HERE 3 >>>> [/showif] >>>> [/showif] >>>> [/showif] >>>> [/founditems][/search] >>>> >>>>[/founditems][/search]------------------------------------------------- >>>>----- >>>> >>>> >>>> --------------------------------------------------------- >>>> 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 >>> >>> --------------------------------------------------------- >>> 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 >> >> --------------------------------------------------------- >> 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 > >--------------------------------------------------------- >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:
It just means contains. So it would show you any instance of [ASSIGNMENT1] that includes Properties in it. It could be Properties A, Propertieszzzz, or just Properties. On 12/2/13 12:53 PM, "Stephen Braun" wrote: >So why does [showif [ASSIGNMENT1]^Properties] some code [/showif] > work, and > [showif [ASSIGNMENT1]=Properties] some other >code [/showif] does not work. > >What is the mathematical operation of the ^ symbol? >I've never used it before. >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 >> >> [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. >>> >>> Database fields are: >>> SSKU2 CR_NAMEF CR_NAMEL ASSIGNMENT1 >>> >>> Data is >>> 5001 Stephen Braun Properties >>> >>> [showif [CR_NAMEL]=Braun] some code [/showif] works fine. >>> [showif [ASSIGNMENT1]=Properties] 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? >>>> >>>> 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? >>>> >>>> My WebDNA is rusty, so take it for what it's worth: >>>> >>>> [search >>>> >>>>db=../signin/data/signin.db&grSSKUdatarq=1&asSTUDENT_NAMELsort=1&asSTUD >>>>ENT_N >>>> AMEFsort=2] >>>> [text show=f]RBN_ASSIGNMENT=nada[/text] >>>> [founditems] >>>> [search >>>> >>>>db=recordsbyname.db&geSSKU2datarq=1&eqCR_NAMEFdata=[STUDENT_NAMEF]&eqCR >>>>_NAME >>>> Ldatarq=[STUDENT_NAMEL]] >>>> [founditems] >>>> [showif >>>> [url][STUDENT_NAMEF][/Url]=[CR_NAMEF]] HERE 1 >>>> [showif >>>> [url][STUDENT_NAMEL][/Url]=[CR_NAMEL]] HERE 2 >>>> Output >>>> Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
>>>> [showif >>>> [url][RBN_ASSIGNMENT][/Url]=Makeup] >>>> >>>> HERE 3 >>>> [/showif] >>>> [/showif] >>>> [/showif] >>>> [/founditems][/search] >>>> [/founditems][/search] >>>> >>>> -----Original Message----- >>>> From: Terry Nair [mailto:terrynair@prism4u.com] >>>> Sent: Monday, November 18, 2013 4:05 PM >>>> To: talk@webdna.us >>>> Subject: RE: [WebDNA] Nested Searches >>>> >>>> There is a "&" missing where ^^^ is shown .... >>>> db=recordsbyname.db&geSSKU2data=1 ^^^ eqCR_NAMEFdata >>>> >>>> -----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 >>>> >>>> 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] 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. >>>> Any ideas would be greatly appreciated. >>>> Thank you, >>>> sfb >>>> >>>> >>>> >>>> >>>> [search >>>> >>>>db=../signin/data/signin.db&grSSKUdata=1&asSTUDENT_NAMELsort=1&asSTUDEN >>>>T_NAM >>>> EFsort=2][founditems] >>>> [search >>>> >>>>db=recordsbyname.db&geSSKU2data=1eqCR_NAMEFdata=[STUDENT_NAMEF]&eqCR_NA >>>>MELda >>>> tarq=[STUDENT_NAMEL]][founditems] >>>> [showif [STUDENT_NAMEF]=[CR_NAMEF]] HERE 1 >>>> [showif >>>> [STUDENT_NAMEL]=[CR_NAMEL]] HERE 2 >>>> Output >>>> Text: [CR_NAMEF] [CR_NAMEL] [RBN_ASSIGNMENT]
>>>> [showif >>>> [RBN_ASSIGNMENT]=Makeup] >>>> >>>> HERE 3 >>>> [/showif] >>>> [/showif] >>>> [/showif] >>>> [/founditems][/search] >>>> >>>>[/founditems][/search]------------------------------------------------- >>>>----- >>>> >>>> >>>> --------------------------------------------------------- >>>> 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 >>> >>> --------------------------------------------------------- >>> 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 >> >> --------------------------------------------------------- >> 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 > >--------------------------------------------------------- >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
Eddie Z
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:
spaces in [texta] (1998)
auto-stripping of spaces (1997)
Shopping Cart w/Multiple Databases (1998)
Bug Report, maybe (1997)
Re[2]: Hiding files/images. (2000)
Change 2.0 to 2.1: Carts files not written to disk automatically (1998)
apostrophe in search item (1997)
External Images (1998)
WARNING: deletedb anomaly (2002)
Micro-managing External Links (2006)
WebCat2 beta 11 - new prefs ... (1997)
Design Help Needed (1998)
shipcost vs shiptotal (1998)
Bug In Admin Templates (2003)
Signal Raised (1997)
Re:Emailer and encryption (1997)
Big Databases (1997)
Virtual hosting and webcatNT (1997)
Finding max value for a field (1997)
WebDNA Challenge - Was: Why WebDNA is not popular (2002)