Re: [WebDNA] Nested Searches
This WebDNA talk-list message is from 2013
It keeps the original formatting.
numero = 110951
interpreted = N
texte = 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 On 3 Dec 2013, at 5:53 am, Stephen Braun
wrote: > 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: >>> SSKU2 CR_NAMEF CR_NAMEL = ASSIGNMENT1 >>>=20 >>> Data is=20 >>> 5001 Stephen Braun Properties >>>=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
Associated Messages, from the most recent to the oldest:
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 On 3 Dec 2013, at 5:53 am, Stephen Braun wrote: > 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: >>> SSKU2 CR_NAMEF CR_NAMEL = ASSIGNMENT1 >>>=20 >>> Data is=20 >>> 5001 Stephen Braun Properties >>>=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
WebDNA
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:
[tcpsend] (2001)
template security preferences????? (1998)
suffix mapping for NT? (1997)
WebCat2 beta 11 - new prefs ... (1997)
DreamWeaver (2002)
no global [username] or [password] displayed ... (1997)
Forbidden CGI Error (1997)
WCS Newbie question (1997)
Browser Problem?!? POST forms and NN 4.0+ browsers (1997)
Problem about [CART] number (1998)
Keep away (1997)
Requiring that certain fields be completed (1997)
Download URL & access on the fly ? (1997)
FAX orders (1996)
shipping calculations, lookup command (1997)
hmmm (2006)
[WebDNA] Hard-coded db write delay when running certain code? (2011)
WebCat2 - [format thousands] (1997)
[TaxableTotal] - not working with AOL and IE (1997)
best way to test for the existence of a parameter in a url (2003)