Cold Fusion Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingCold Fusion Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old June 2nd, 2003, 06:27 AM
DJ_Back-Q DJ_Back-Q is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2003
Posts: 1 DJ_Back-Q User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Exclamation Populating drop down based on another drop down

Here is what I'm triing to do.

I have a database with a state table and a province table... witch are linked.

I have to drop down menus, 1 for the state, and one for the city.

I want to fill the one with city's based on what was given to me in the state drop down.

I know how to do it with coldfusion and refresh the page with a new query. But I want to do it without refreshing the page. There will be probably javascript involved.

Thank you

Reply With Quote
  #2  
Old June 2nd, 2003, 07:15 AM
stumpy's Avatar
stumpy stumpy is offline
May contain nuts.
Dev Articles Regular (2000 - 2499 posts)
 
Join Date: Aug 2002
Posts: 2,056 stumpy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 44 m 22 sec
Reputation Power: 0
Yes, you'll need Javascript to do it.

I've just implmented the same thing on a client's site.. it's a bit of a nightmare to do, as it causes all sort of problems if the user hits the back button to get back to the page (their selections aren't saved, and u get JS errors....)

anyway - here's the site , simply view source and have a poke around.

Also, here's a link to some source: http://www.js-examples.com/example/?ex=683&mode=2

Reply With Quote
  #3  
Old June 4th, 2003, 08:04 AM
ChiMex ChiMex is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Sep 2002
Location: Colorado
Posts: 22 ChiMex User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Take a look at www.fusionscript.com it has the ability to dynamically populate drop downs without refreshing the page.

Reply With Quote
  #4  
Old February 14th, 2004, 05:57 AM
sfrasier sfrasier is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 5 sfrasier User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Javascript -- definitely. these samples should help:

Quote:
Originally Posted by DJ_Back-Q
Here is what I'm triing to do.

I have a database with a state table and a province table... witch are linked.

I have to drop down menus, 1 for the state, and one for the city.

I want to fill the one with city's based on what was given to me in the state drop down.

I know how to do it with coldfusion and refresh the page with a new query. But I want to do it without refreshing the page. There will be probably javascript involved.

Thank you

Reply With Quote
  #5  
Old February 14th, 2004, 06:06 AM
sfrasier sfrasier is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2004
Posts: 5 sfrasier User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0

Reply With Quote
  #6  
Old November 15th, 2004, 06:57 PM
Uare Uare is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Location: BC, Canada
Posts: 9 Uare User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Lightbulb Another option for similar drop down lists

I was looking at this question and I remembered an article my company published a while back....
This script is better for longer lists and uses mentions PHP but it should work with all other server side languages. This is for pages that need the triple combo box idea but could really be simplified by doing direct server queries. A warning is that this technique does require newer browsers and JS enabled... But it could save some people hours. It has a live demo if you want to see it in action too
http://www.transparen.com/en/howto-refresh-page-parts
Kyle

Last edited by Uare : November 15th, 2004 at 06:59 PM. Reason: Link doesn't work...

Reply With Quote
  #7  
Old December 9th, 2004, 12:48 PM
Lmckinney Lmckinney is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Posts: 1 Lmckinney User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Post dependant dropdown in coldfusion

I have seen several ways in coldfusion to accomplish this, but the easiest I think is using this third party software called MXWidgets built by "Interakt". its actually pretty nice, although I have been using some custom cftags that came from "CFTagStore" Related Selects (Cross Browsers) - cf_select but had some problems using dynamic from a simple access db, After Rizal fixed this, it was the nutts, so I choose to stay with this, considering I have already bought it. And WebAssist has a dependant dropdown for coldfusion also, haven't seen the code but, well, I am sure they are good too. there are 2 related selects and 3 multiple selects that I seen some where and have somewhere that is free. Plus what I use does not refresh the browser, which is nice.



http://www.webassist.com/Products/Samples/1Sample.asp?PID=1
http://www.interaktonline.com/Products/Dreamweaver-Extensions/MXWidgets/Benefits/Details/Dependent+Drop-downs.html?id_sol=16
http://www.cftagstore.com/tags/related.cfm

Reply With Quote
  #8  
Old March 16th, 2005, 09:30 PM
amirul amirul is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Mar 2005
Posts: 1 amirul User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 11 m 4 sec
Reputation Power: 0
may i have the code

Quote:
Originally Posted by DJ_Back-Q
Here is what I'm triing to do.

I have a database with a state table and a province table... witch are linked.

I have to drop down menus, 1 for the state, and one for the city.

I want to fill the one with city's based on what was given to me in the state drop down.

I know how to do it with coldfusion and refresh the page with a new query. But I want to do it without refreshing the page. There will be probably javascript involved.

Thank you


May i have those code in coldfusion, cause i'm trying to do the same thing right here at my office ...it would be much more appreciate it ..if u can pass over the code to me ...for the dual downdown ..

Reply With Quote
  #9  
Old April 20th, 2005, 03:10 PM
errodr errodr is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2002
Posts: 7 errodr User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 46 m 22 sec
Reputation Power: 0
I need to do this I usually generate all my necessary lists when the page loads and set the visibilities to hidden, then based on the other drop-down selection I show the proper list.

Works great, and not a whole lot of JS involved.

Reply With Quote
  #10  
Old February 1st, 2007, 12:17 AM
Karthikeyanphp Karthikeyanphp is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Feb 2007
Posts: 1 Karthikeyanphp User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 7 m 22 sec
Reputation Power: 0
Drop Down Problem

i have two drop down boxes when i am selecting value from fisrt drop down the value in second drop down has to change accordingly without page refreshing can u pls give the sample code if u have bcos i have tried it many times

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingCold Fusion Development > Populating drop down based on another drop down


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap