numero = 61288
interpreted = N
texte = Hi Paul Tidied things up a bit here: (you still need to fix your showif) [hideif [URL][lookup db=admin/sections.db&lookinfield=S_TYPE&value=M&returnfield=S_ID][/ URL]=] [search db=admin/sections.db&eqS_TYPEdatarq=M&S_RANKtype=number&asS_RANKsort=1] [founditems] [text]sect=[If ("[URL][lookup db=admin/ sections.db&lookinfield=S_RELATED&value=[s_id]&returnfield=S_ID¬found =][/URL]"="")][Then]F[/Then][Else]T[/Else][/If][/text] [text]prod=[search db=admin/ products.dbISIBLEdatarq=T&woSECTIONSdatarq=[s_id]&SECTIONSword=ww&max=1] [If ("[numfound]"="0")][Then]F[/Then][Else]T[/Else][/If][/search][/text] [hideif [sect][prod]=FF]
[/hideif] [include file=search_loop.inc&level=1] [/founditems][/search] [/hideif] On 04/03/2005, at 9:46 AM, Paul Berman wrote: > How would I do this to search the sections.db and bring up the > categories > and sub categories > > Called [S_NAME] in storebuilder > > > Being trying to do this for ages we currently just have a simple list > but > thsi would be earier to navigate > > [hideif [lookup > db=admin/sections.db&lookinfield=S_TYPE&value=M&returnfield=S_ID]=] > [search > db=admin/ > sections.db&eqS_TYPEdatarq=M&S_RANKtype=number&asS_RANKsort=1][foun > ditems] > [text]sect=[lookup > db=admin/ > sections.db&lookinfield=S_RELATED&value=[s_id]&returnfield=S_ID¬ > found=][/text] > [text]sect=[showif [sect]=]F[/showif][hideif [sect]=]T[/hideif][/text] > [text]prod=[search > db=admin/ > products.dbISIBLEdatarq=T&woSECTIONSdatarq=[s_id]&SECTIONSword=ww&m > ax=1][numfound][/search][/text] > [text]prod=[showif [prod]=0]F[/showif][hideif > [prod]=0]T[/hideif][/text] > [hideif [sect][prod]=FF]
![MAIN_SECTION_COLOR]]bgcolor="[MAIN_SECTION_COLOR]"[/ShowIf]> > href="default.tpl?cart=[cart]&id1=[s_id]&startat=1&-- > woSECTIONSdatarq=[s_id] > &--SECTIONSword=ww"> [S_NAME] > ([search > db=admin/ > products.db&VISIBLEdatarq=T&woSECTIONSdatarq=[s_id]&SECTIONSword=ww > &max=1][numfound][/search]) > [/hideif][include file=search_loop.inc&level=1] > [/founditems][/search][/hideif] > > > Thanks > Paul > ----- Original Message ----- > From: "Stuart Tremain" > To: "WebDNA Talk" > Sent: Thursday, March 03, 2005 11:08 PM > Subject: Re: Dynamic drop downs > > >> This should get you started :) >> >> >> >> >> >> >> >> On 04/03/2005, at 2:22 AM, stephen@msrit.com wrote: >> >>> Is there a simple way to make a drop down box values dynamic based on >>> a previous selection on the client side? >>> Example: In my first drop down I have Product names and based on >>> which one I select the second drop down shows me the manufacturers. >>> All values pull from the database. >>> >>> Thanks, >>> >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >> Regards >> >> Stuart Tremain >> idfk web developments >> 114a/40 yeo street neutral bay 2089 australia >> t +612 9908 2134 >> f +612 9908 4837 >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi Paul Tidied things up a bit here: (you still need to fix your showif) [hideif [url][lookup db=admin/sections.db&lookinfield=S_TYPE&value=M&returnfield=S_ID][/ URL]=] [search db=admin/sections.db&eqS_TYPEdatarq=M&S_RANKtype=number&asS_RANKsort=1] [founditems][text]sect=[If ("[url][lookup db=admin/ sections.db&lookinfield=S_RELATED&value=[s_id]&returnfield=S_ID¬found =][/URL]"="")][Then]F[/Then][Else]T[/Else][/If][/text] [text]prod=[search db=admin/ products.dbISIBLEdatarq=T&woSECTIONSdatarq=[s_id]&SECTIONSword=ww&max=1] [If ("[numfound]"="0")][Then]F[/Then][Else]T[/Else][/If][/search][/text] [hideif [sect][prod]=FF]
[/hideif] [include file=search_loop.inc&level=1] [/founditems][/search] [/hideif] On 04/03/2005, at 9:46 AM, Paul Berman wrote: > How would I do this to search the sections.db and bring up the > categories > and sub categories > > Called [S_NAME] in storebuilder > > > Being trying to do this for ages we currently just have a simple list > but > thsi would be earier to navigate > > [hideif [lookup > db=admin/sections.db&lookinfield=S_TYPE&value=M&returnfield=S_ID]=] > [search > db=admin/ > sections.db&eqS_TYPEdatarq=M&S_RANKtype=number&asS_RANKsort=1][foun > ditems] > [text]sect=[lookup > db=admin/ > sections.db&lookinfield=S_RELATED&value=[s_id]&returnfield=S_ID¬ > found=][/text] > [text]sect=[showif [sect]=]F[/showif][hideif [sect]=]T[/hideif][/text] > [text]prod=[search > db=admin/ > products.dbISIBLEdatarq=T&woSECTIONSdatarq=[s_id]&SECTIONSword=ww&m > ax=1][numfound][/search][/text] > [text]prod=[showif [prod]=0]F[/showif][hideif > [prod]=0]T[/hideif][/text] > [hideif [sect][prod]=FF]
![MAIN_SECTION_COLOR]]bgcolor="[MAIN_SECTION_COLOR]"[/ShowIf]> > href="default.tpl?cart=[cart]&id1=[s_id]&startat=1&-- > woSECTIONSdatarq=[s_id] > &--SECTIONSword=ww"> [S_NAME] > ([search > db=admin/ > products.db&VISIBLEdatarq=T&woSECTIONSdatarq=[s_id]&SECTIONSword=ww > &max=1][numfound][/search]) > [/hideif][include file=search_loop.inc&level=1] > [/founditems][/search][/hideif] > > > Thanks > Paul > ----- Original Message ----- > From: "Stuart Tremain" > To: "WebDNA Talk" > Sent: Thursday, March 03, 2005 11:08 PM > Subject: Re: Dynamic drop downs > > >> This should get you started :) >> >> >> >> >> >> >> >> On 04/03/2005, at 2:22 AM, stephen@msrit.com wrote: >> >>> Is there a simple way to make a drop down box values dynamic based on >>> a previous selection on the client side? >>> Example: In my first drop down I have Product names and based on >>> which one I select the second drop down shows me the manufacturers. >>> All values pull from the database. >>> >>> Thanks, >>> >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >> Regards >> >> Stuart Tremain >> idfk web developments >> 114a/40 yeo street neutral bay 2089 australia >> t +612 9908 2134 >> f +612 9908 4837 >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Stuart Tremain
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...