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:

Limitations on fields? Server is crashing (1997) using showpage and showcart commands (1996) Variables (1999) OT - royalty free images (2002) multi-paragraph fields (1997) Forumulas.db & Variables (2002) verify email address (1998) show all problem (1997) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) Fufillment e-mail? (1998) Re:2nd WebCatalog2 Feature Request (1996) inconsistent webcat calculation? (1997) Secure server question (1997) [WebDNA] .htm files (2008) Nav. 4 probs with cart - Serious problem (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Cart vs database (1998) Reverse dating (1999) [SHOWIF AND/OR] (1997) Multiple condition showif's (2004)