Re: dynamic related select box
>I like to write my own related selects but look for CF_TwoSelectsRelated by >Nate Weiss (there are also others that will relate more than 2 selects) I personally use the qForms API (pengoworks.com) to do these, since I usually already have it included to do my forms validation. It's a little more flexible and can handle any number and variation of cascading selects. Mary Jo Sminkey http://www.cfwebstore.com CFWebstore, ColdFusion E-commerce ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dynamic related select box
MXAJAX has this too, out of the box: http://www.indiankey.com/mxajax/examples/mxSelect1.cfm On 9/7/06, Jake Churchill <[EMAIL PROTECTED]> wrote: > CFAjax > > Ali Majdzadeh wrote: > > Hi everybody: > > I need a solution for dynamic related select box. For example when the user > > selects the state in the other select box all the cities of the selected > > state appear. > > Do you any free/easy way to do that. I use coldfusion/ms access. > > Thanks > > Benign -- CFAJAX docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252307 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: dynamic related select box
Here is one you could use. It is not a custom tag, but not near as difficult to format your html around it either. Just modify your queries etc... select categories.cat_id, categories.category, categories.parent_id from categories where categories.parent_id is null selected>#category# select categories.cat_id, categories.category, categories.parent_id from categories where categories.parent_id = #form.select_Main_Group# Select Subgroup selected>#category# - Original Message - From: "Bobby Hartsfield" <[EMAIL PROTECTED]> To: "CF-Talk" Sent: Wednesday, September 06, 2006 2:21 PM Subject: RE: dynamic related select box > I like to write my own related selects but look for CF_TwoSelectsRelated by > Nate Weiss (there are also others that will relate more than 2 selects) > > ..:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > > > > > > -Original Message- > From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 06, 2006 3:03 PM > To: CF-Talk > Subject: dynamic related select box > > Hi everybody: > I need a solution for dynamic related select box. For example when the user > selects the state in the other select box all the cities of the selected > state appear. > Do you any free/easy way to do that. I use coldfusion/ms access. > Thanks > Benign > > > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252273 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: dynamic related select box
I like to write my own related selects but look for CF_TwoSelectsRelated by Nate Weiss (there are also others that will relate more than 2 selects) ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ali Majdzadeh [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 06, 2006 3:03 PM To: CF-Talk Subject: dynamic related select box Hi everybody: I need a solution for dynamic related select box. For example when the user selects the state in the other select box all the cities of the selected state appear. Do you any free/easy way to do that. I use coldfusion/ms access. Thanks Benign ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252271 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dynamic related select box
> Hi everybody: > I need a solution for dynamic related select box. For example when the > user selects the state in the other select box all the cities of the > selected state appear. > Do you any free/easy way to do that. I use coldfusion/ms access. > Thanks > Benign The most commonly used CF solution is Nate Weiss' Two-Selects related custom tag: http://projects.nateweiss.com/nwdc/downloads/cf/CF_TwoSelectsRelated.zip very simple to use. Selene Bainum also has a good tutorial on related selects that you might want to check out. http://www.webtricks.com/sourcecode/code.cfm?CodeID=18 hth, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252259 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: dynamic related select box
CFAjax Ali Majdzadeh wrote: > Hi everybody: > I need a solution for dynamic related select box. For example when the user > selects the state in the other select box all the cities of the selected > state appear. > Do you any free/easy way to do that. I use coldfusion/ms access. > Thanks > Benign > > ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:252256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
