Re: Dynamic drop downs

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 61288
interpreted = N
texte = Hi PaulTidied 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]  [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]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 :)>>>>>> >> Select ....>> [Search db=^countries.db&eqACTIVEdatarq=T&asSKUsort=1&SKUtype=num]>> [FoundItems]>> > [countryname]=[_country]]SELECTED[/ShowIf]>[countryname]>> [/FoundItems]>> [/Search]>> >>>>>>>>>> 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/>>RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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:

Re: Dynamic drop downs ( Stuart Tremain 2005) Re: Dynamic drop downs ( Stuart Tremain 2005) Re: Dynamic drop downs ( Stuart Tremain 2005) Re: Dynamic drop downs ( Kenneth Grome 2005) Re: Dynamic drop downs ( "Paul Berman" 2005) Re: Dynamic drop downs ( Stuart Tremain 2005) Dynamic drop downs ( stephen@msrit.com 2005)

Hi PaulTidied 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] [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]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 :)>>>>>> >> Select ....>> [Search db=^countries.db&eqACTIVEdatarq=T&asSKUsort=1&SKUtype=num]>> [founditems]>> > [countryname]=[_country]]SELECTED[/ShowIf]>[countryname]>> [/FoundItems]>> [/Search]>> >>>>>>>>>> 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/>>RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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

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:

MOOOOOO (2000) WebCat2b15MacPlugin - [protect] (1997) Quit revisited (1997) Linux Install Question (2000) Add all products to cart at once? (1997) Encrypting the URL Query String (2003) Help with [LineItems] in [OrderFile] on ShoppingCart.tpl (2003) WebCat2 - Getting to the browser's username/password data (1997) [WriteFile] problems (1997) Search returns all, not 20 (1997) reading a email (2000) [searchString] (1997) F2 to F3 rocky transition (1997) WebCat2 - storing unformatted date data? (1997) Credit card processing - UK (1997) Bug 4.0: Windows Virtual Directories (2000) Works! (1997) Running _every_ page through WebCat ? (1997) EIMS Problems (1997) PROBLEM (1997)