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:

raw field names (2001) Separate SSL Server (1997) [WebDNA] caret in db path? (2017) ShowNext example for GeneralStore (1997) WC2.0 Memory Requirements (1997) RE: WebCatalog2 for NT Beta Request (1997) Setting expiration dates for cookies (2000) Time Display from Database (1997) Modifying order output (1997) Error Lob.db records error message not name (1997) LOOP and IF statements (1997) Summing fields (1997) WebCatalog Prefs.ref file ? (1998) RE:formula.db problems (1999) SiteGuard Use Question (1997) GMT Date/Time (2000) WebCat2b13MacPlugin - nested [xxx] contexts (1997) [OT] Australian Dial-Up Access (2006) truncating email part II (1997) WebCat2b15MacPlugin - [protect] (1997)