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: >>> SSKU2CR_NAMEFCR_NAMELASSIGNMENT1 >>> >>> Data is >>> 5001StephenBraunProperties >>> >>> [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:

    
  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)
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: >>> SSKU2CR_NAMEFCR_NAMELASSIGNMENT1 >>> >>> Data is >>> 5001StephenBraunProperties >>> >>> [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:

[math] storage of variables (1997) [WebDNA] An unknown error occured // Deadlock avoided (2011) [WebDNA] CRM System (2016) WC2f3 (1997) how to kill webcat ? (2002) [searchString] (1997) format problem on NT? (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) Emailer [cart] file names (1997) Free pack for the New UPS ratings and services tool (2000) Emailer error 571 (1998) Request for quote (2000) SSL (1998) Developers in Washington State (2004) Creating folders and deleting files (1997) No Wanna Duppys (1998) 2nd WebCatalog2 Feature Request (1996) [OT] Server check please (2006) Re(4): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998) Running 2 two WebCatalog.acgi's (1996)