Re: [WebDNA] Nested Searches

This WebDNA talk-list message is from

2013


It keeps the original formatting.
numero = 110952
interpreted = N
texte = --Apple-Mail=_9FD81CE8-A462-4042-831F-513CBD347AD7 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Yes, there are some invisible characters going into my database. %1D Dunno what that is or where it comes from, because I'm using a drop-down = menu to enter the data. At least it's a starting point. Thanks Brian & Stuart. sfb On Dec 2, 2013, at 4:43 PM, WebDNA wrote: > The reason I suggested using ^ is because ASSIGNMENT1 may have a space = or other white space before or after Properties, so if it does then = ASSIGNMENT1 will never =3D Properties. >=20 > If you do this: *[URL][ASSIGNMENT1][/URL]* you will see if there are = any other characters between the ** and help you determine if your data = is clean to start with. >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 3 Dec 2013, at 5:53 am, Stephen Braun wrote: >=20 >> So why does [showif [ASSIGNMENT1]^Properties] some code [/showif] = work, and >> [showif [ASSIGNMENT1]=3DProperties] some = other code [/showif] does not work. >>=20 >> 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. >>=20 >> Thanks, >> sfb >>=20 >>=20 >>=20 >>=20 >>=20 >> On Nov 26, 2013, at 4:54 PM, Stuart Tremain = wrote: >>=20 >>> 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: >>>> SSKU2CR_NAMEFCR_NAMEL= ASSIGNMENT1 >>>>=20 >>>> Data is=20 >>>> 5001StephenBraunProperties >>>>=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 >>=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 --Apple-Mail=_9FD81CE8-A462-4042-831F-513CBD347AD7 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Yes, = there are some invisible characters going into my database.
  =     %1D

Dunno what that is or where it = comes from, because I'm using a drop-down menu to enter the = data.
At least it's a starting = point.

Thanks Brian & = Stuart.
sfb




On Dec 2, 2013, at 4:43 PM, WebDNA <webdna@idfk.com.au> = wrote:

The reason I suggested using ^ is because ASSIGNMENT1 may = have a space or other white space before or after Properties, so if it = does then ASSIGNMENT1 will never =3D Properties.

If you do this: = *[URL][ASSIGNMENT1][/URL]* you will see if there are any other = characters between the ** and help you determine if your data is clean = to start with.

Regards

Stuart Tremain
IDFK Web = Developments
AUSTRALIA
webdna@idfk.com.au



<= br>On 3 Dec 2013, at 5:53 am, Stephen Braun <sbraun1@twcny.rr.com> = wrote:

So why does =     [showif [ASSIGNMENT1]^Properties] some code = [/showif]          work, = and
=             &n= bsp;           &nbs= p;  [showif [ASSIGNMENT1]=3DProperties] 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 <webdna@idfk.com.au> = 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 = <sbraun1@twcny.rr.com> 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_NAMEF= CR_NAMEL= = ASSIGNMENT1

Data is
5001Stephen= Braun= = Properties

[showif [CR_NAMEL]=3DBraun] some code [/showif] =          works = fine.
[showif [ASSIGNMENT1]=3DProperties] 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 <gary@garykrockover.com> 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=3D../signin/data/signin.db&grSSKUdatarq=3D= 1&asSTUDENT_NAMELsort=3D1&asSTUDENT_N
AMEFsort=3D2]
[text = show=3Df]RBN_ASSIGNMENT=3Dnada[/text]
[founditems]
= [search
db=3Drecordsbyname.db&geSSKU2datarq=3D1&eqCR_NAM= EFdata=3D[STUDENT_NAMEF]&eqCR_NAME
Ldatarq=3D[STUDENT_NAMEL]]
= [founditems]
= [showif
[Url][STUDENT_NAMEF][/Url]=3D[CR_NAMEF]]  HERE 1 =
= = = = = = [showif
[Url][STUDENT_NAMEL][/Url]=3D[CR_NAMEL]]  HERE = 2
 =           = Output
Text: [CR_NAMEF]  [CR_NAMEL]  [RBN_ASSIGNMENT] =     <br> =      
= [showif
[Url][RBN_ASSIGNMENT][/Url]=3DMakeup]  

HERE = 3
= = = = = = = = [/showif]
[/showif]
= [/showif]
= [/founditems][/search]
[/founditems][/search]

-----Origin= al 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=3Drecordsbyname.db&geSSKU2data=3D1 ^^^ = 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=3D../signin/data/signin.db&am= p;grSSKUdata=3D1&asSTUDENT_NAMELsort=3D1&asSTUDENT_NAM
EFsort=3D= 2][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
= [showif
[STUDENT_NAMEL]=3D[CR_NAMEL]]  HERE 2
 =           = Output
Text: [CR_NAMEF]  [CR_NAMEL]  [RBN_ASSIGNMENT] =     <br> =      
= [showif
[RBN_ASSIGNMENT]=3DMakeup]  

HERE = 3
= = = = = = = = [/showif]
[/showif]
[/showif] =         
= [/founditems][/search]
[/founditems][/search]-------------------= -----------------------------------


---------------------------= ------------------------------
This message is sent to you because = you are subscribed to
the mailing list <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
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 <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
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 <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
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 <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
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 <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: = http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: = support@webdna.us

= --Apple-Mail=_9FD81CE8-A462-4042-831F-513CBD347AD7-- 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)
--Apple-Mail=_9FD81CE8-A462-4042-831F-513CBD347AD7 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Yes, there are some invisible characters going into my database. %1D Dunno what that is or where it comes from, because I'm using a drop-down = menu to enter the data. At least it's a starting point. Thanks Brian & Stuart. sfb On Dec 2, 2013, at 4:43 PM, WebDNA wrote: > The reason I suggested using ^ is because ASSIGNMENT1 may have a space = or other white space before or after Properties, so if it does then = ASSIGNMENT1 will never =3D Properties. >=20 > If you do this: *[url][ASSIGNMENT1][/URL]* you will see if there are = any other characters between the ** and help you determine if your data = is clean to start with. >=20 > Regards >=20 > Stuart Tremain > IDFK Web Developments > AUSTRALIA > webdna@idfk.com.au >=20 >=20 >=20 >=20 > On 3 Dec 2013, at 5:53 am, Stephen Braun wrote: >=20 >> So why does [showif [ASSIGNMENT1]^Properties] some code [/showif] = work, and >> [showif [ASSIGNMENT1]=3DProperties] some = other code [/showif] does not work. >>=20 >> 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. >>=20 >> Thanks, >> sfb >>=20 >>=20 >>=20 >>=20 >>=20 >> On Nov 26, 2013, at 4:54 PM, Stuart Tremain = wrote: >>=20 >>> 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: >>>> SSKU2CR_NAMEFCR_NAMEL= ASSIGNMENT1 >>>>=20 >>>> Data is=20 >>>> 5001StephenBraunProperties >>>>=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 >>=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 --Apple-Mail=_9FD81CE8-A462-4042-831F-513CBD347AD7 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Yes, = there are some invisible characters going into my database.
  =     %1D

Dunno what that is or where it = comes from, because I'm using a drop-down menu to enter the = data.
At least it's a starting = point.

Thanks Brian & = Stuart.
sfb




On Dec 2, 2013, at 4:43 PM, WebDNA <webdna@idfk.com.au> = wrote:

The reason I suggested using ^ is because ASSIGNMENT1 may = have a space or other white space before or after Properties, so if it = does then ASSIGNMENT1 will never =3D Properties.

If you do this: = *[url][ASSIGNMENT1][/URL]* you will see if there are any other = characters between the ** and help you determine if your data is clean = to start with.

Regards

Stuart Tremain
IDFK Web = Developments
AUSTRALIA
webdna@idfk.com.au



<= br>On 3 Dec 2013, at 5:53 am, Stephen Braun <sbraun1@twcny.rr.com> = wrote:

So why does =     [showif [ASSIGNMENT1]^Properties] some code = [/showif]          work, = and
=             &n= bsp;           &nbs= p;  [showif [ASSIGNMENT1]=3DProperties] 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 <webdna@idfk.com.au> = 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 = <sbraun1@twcny.rr.com> 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_NAMEF= CR_NAMEL= = ASSIGNMENT1

Data is
5001Stephen= Braun= = Properties

[showif [CR_NAMEL]=3DBraun] some code [/showif] =          works = fine.
[showif [ASSIGNMENT1]=3DProperties] 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 <gary@garykrockover.com> 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=3D../signin/data/signin.db&grSSKUdatarq=3D= 1&asSTUDENT_NAMELsort=3D1&asSTUDENT_N
AMEFsort=3D2]
[text = show=3Df]RBN_ASSIGNMENT=3Dnada[/text]
[founditems]
= [search
db=3Drecordsbyname.db&geSSKU2datarq=3D1&eqCR_NAM= EFdata=3D[STUDENT_NAMEF]&eqCR_NAME
Ldatarq=3D[STUDENT_NAMEL]]
= [founditems]
= [showif
[url][STUDENT_NAMEF][/Url]=3D[CR_NAMEF]]  HERE 1 =
= = = = = = [showif
[url][STUDENT_NAMEL][/Url]=3D[CR_NAMEL]]  HERE = 2
 =           = Output
Text: [CR_NAMEF]  [CR_NAMEL]  [RBN_ASSIGNMENT] =     <br> =      
= [showif
[url][RBN_ASSIGNMENT][/Url]=3DMakeup]  

HERE = 3
= = = = = = = = [/showif]
[/showif]
= [/showif]
= [/founditems][/search]
[/founditems][/search]

-----Origin= al 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=3Drecordsbyname.db&geSSKU2data=3D1 ^^^ = 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=3D../signin/data/signin.db&am= p;grSSKUdata=3D1&asSTUDENT_NAMELsort=3D1&asSTUDENT_NAM
EFsort=3D= 2][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
= [showif
[STUDENT_NAMEL]=3D[CR_NAMEL]]  HERE 2
 =           = Output
Text: [CR_NAMEF]  [CR_NAMEL]  [RBN_ASSIGNMENT] =     <br> =      
= [showif
[RBN_ASSIGNMENT]=3DMakeup]  

HERE = 3
= = = = = = = = [/showif]
[/showif]
[/showif] =         
= [/founditems][/search]
[/founditems][/search]-------------------= -----------------------------------


---------------------------= ------------------------------
This message is sent to you because = you are subscribed to
the mailing list <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
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 <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
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 <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
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 <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
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 <talk@webdna.us>.
To = unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: = http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: = support@webdna.us

= --Apple-Mail=_9FD81CE8-A462-4042-831F-513CBD347AD7-- 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:

[replaceChars] would be nice ... (1997) Locking up with WebCatalog... (1997) Great product and great job ! (1997) off topic fetch vs PCS photomaster (1997) searching multiple databases (1997) MacOS X 10.1 Upgrade Error (2001) Sendmail & Time Issue (2001) Advice needed. (1998) Kaaaaahhhhhhhnnnnnnn! (1997) different browser, different result (2000) Email troubles (2005) ANYONE (1999) linetiems in thankyou.tpl (1997) "Advanced" Search Algorithm (2008) CMS (2003) WebCat2 - [format thousands] (1997) A good idea? (1998) Multiple Passwords (1997) quantity minimum problem (1997) Adding up weights (1998)