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-513CBD347AD7Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=us-asciiYes, there are some invisible characters going into my database. %1DDunno 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.sfbOn 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-513CBD347AD7Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=us-asciiYes, =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
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: