Re: [WebDNA] Nested Searches

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110892
interpreted = N
texte = Also, make sure you're inside the founditems of the second db. On Wed, 27 Nov 2013 08:54:15 +1100 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&asSTUDENT_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&asSTUDENT_NAM >> EFsort=2][founditems] >> [search >> db=recordsbyname.db&geSSKU2data=1eqCR_NAMEFdata=[STUDENT_NAMEF]&eqCR_NAMELda >> 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 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)
Also, make sure you're inside the founditems of the second db. On Wed, 27 Nov 2013 08:54:15 +1100 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&asSTUDENT_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&asSTUDENT_NAM >> EFsort=2][founditems] >> [search >> db=recordsbyname.db&geSSKU2data=1eqCR_NAMEFdata=[STUDENT_NAMEF]&eqCR_NAMELda >> 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 "Terry Wilson"

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:

Show next 2 examples that work (1997) [group] ? (1997) [input] [/input] (1997) WebDNA 6.0 Report (2004) b12 cannot limit records returned and more. (1997) delete after x (1998) 'does not contain' operator needed ... (1997) multi-paragraph fields (1997) Bug or syntax error on my part? (1997) WC2b12: Yes, Formulas.db is for real (1997) Trigger Admin acting up (2001) [WriteFile] problems (1997) many-to-one problem (1998) Sendmail strangie (2002) [ShowNext] (2007) Can I invoke an ssi plugin from within a webcat page (1997) shell problem (2003) File not found error message (1998) still having search problem, please help :) (2004) Emailer Chokes on bad address (1997)