In the era of the cloud, customers migrating away from their existing on-premise infrastructure. This requires lots of planning, strategies, and effort to identify their existing resources and determine how best to migrate. Datacenter migrations happen in four phases -
COURSE of the MONTH
13 days, 14 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Building or creating dynamic drop down
Posted on 2011-03-04
Experts,
I need to build a dynamic dropdown list based on the selection of a other dropdown. Also I don't want to submit
the form since I have other data entry field on my form and don't want to lose the user entered data.
What is the best way to achive it using CF and/or Java Script. An example would really help to save the time since it is kind of urgent.
My first query is : select state from mydatabse.states
My second query is : select counties from mydatabase.counties where state = #state#
Thanks in Advance
I need to build a dynamic dropdown list based on the selection of a other dropdown. Also I don't want to submit
the form since I have other data entry field on my form and don't want to lose the user entered data.
What is the best way to achive it using CF and/or Java Script. An example would really help to save the time since it is kind of urgent.
My first query is : select state from mydatabse.states
My second query is : select counties from mydatabase.counties where state = #state#
Thanks in Advance
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
3
2- +2
11 Comments
Thanks for the quick reply and example srikanthmadishetti:
Right now I am not using or don't want to use the CFC. So, can I just use the fuction in that example and build my second drop down in the same page? with regular HTML instead of CFSELCT etc.?
Right now I am not using or don't want to use the CFC. So, can I just use the fuction in that example and build my second drop down in the same page? with regular HTML instead of CFSELCT etc.?
Active 2 days ago
cf_twoselectsrelated
a CF custom tag that creates the javascript for you..
All you do is write a query that has a join between both items you want to display. For example, a query "getProducts" is a list of products and the options available to that product (let's say SIZE : small, medium...)
Then you just fill in the fields :
Name - the form's field name
Display - the column that will be show to the user in the select tag
Value - the column that will be the value of the select tag
emptytext - what should appear when nothing is selected
selected - the value of the field that should be shown when loaded
formName - the name of the form the select tags are put into
htmlBetween - any HTML that you want to appear between the two select tags, for example, maybe they are columns in a table so you would put </td><td> between the tags
<cf_twoselectsrelated query="getProducts"
name1="product_id"
name2="size_id"
display1="productName"
display2="optionName"
value1="company_id"
value2="annuity_id"
emptyText1="- Select a Product -"
emptyText2="- Select a Size"
selected1="#variables.product_id#"
selected2="#variables.size_id#"
htmlBetween="</td><td>"
formName="myForm"
>
>>Right now I am not using or don't want to use the CFC. So, can I just use the fuction in that example and build my second drop down in the same page? with regular HTML instead of CFSELCT etc.?
You can bind it to a CFM.. try below example
your form.cfm
Create a file test.cfm which will have the query to pull the information for second select
You can bind it to a CFM.. try below example
your form.cfm
<cfform name="UserForm" method="post" format="html">
<select name="CategorySearch">
<option value="1">Test1</option>
<option value="2">Test2</option>
</select>
<cfselect width="50" name="SubCategories" bind="url:test.cfm?keyword={CategorySearch}" display="name" value="Aid" />
</cfform>
Create a file test.cfm which will have the query to pull the information for second select
<cfset Category = queryNew("Aid, name")>
<cfset queryAddRow(Category,1)>
<cfset querySetCell(Category,'Aid',1)>
<cfset querySetCell(Category,'name','Test1')>
<cfset queryAddRow(Category,1)>
<cfset querySetCell(Category,'Aid',2)>
<cfset querySetCell(Category,'name','Test2')>
<cfquery name="getCatregory" dbtype="query">
select Aid, name
from Category
where Aid = #url.keyword#
</cfquery>
<cfoutput>
#serializeJSON(getCatregory)#
</cfoutput>
@brijesh Good to see you in EE :)
@Tpaul
>>>Right now I am not using or don't want to use the CFC. So, can I just use the fuction in that example and build my second drop down in the same page? with regular HTML instead of CFSELCT etc.?
Is there any specific reason for not using the cfselect or cfc
First it will be just few lines of code and second cfc will help you to reuse this code any where .
You can use it any form which has the state and country drop downs .
@Tpaul
>>>Right now I am not using or don't want to use the CFC. So, can I just use the fuction in that example and build my second drop down in the same page? with regular HTML instead of CFSELCT etc.?
Is there any specific reason for not using the cfselect or cfc
First it will be just few lines of code and second cfc will help you to reuse this code any where .
You can use it any form which has the state and country drop downs .
Hi Wanna Spend some Bucks! there are good dependent dropdownds in cftagstore!
here is ur search:
http://www.cftagstore.com/tags/related.cfm
http://www.cftagstore.com/tags/cfrelatedselectscontrol.cfm
http://www.cftagstore.com/tags/relatedselectmenuformcontrolcalculator.cfm
here is ur search:
http://www.cftagstore.com/tags/related.cfm
http://www.cftagstore.com/tags/cfrelatedselectscontrol.cfm
http://www.cftagstore.com/tags/relatedselectmenuformcontrolcalculator.cfm
I have old cold fusion code and the site is going away soon. So, no CFCs and don't want to spend money for buying the code -:(
I may look in to writing a custom tag, but need to find out if the tables are related to have one query.
May be an example would be helpful.
I may look in to writing a custom tag, but need to find out if the tables are related to have one query.
May be an example would be helpful.
Active 2 days ago
I provided you with a custom tag: cf_twoselectsrelated
http://projects.nateweiss.com/nwdc/workcode.htm
> but need to find out if the tables are related to have one query
The would have to be related, wouldn't they? Otherwise, you don't need two related select tags, you could just do two distinctly seperate tags, right?
http://projects.nateweiss.com/nwdc/workcode.htm
> but need to find out if the tables are related to have one query
The would have to be related, wouldn't they? Otherwise, you don't need two related select tags, you could just do two distinctly seperate tags, right?
Sorry about the delay and Thanks for all your inputs.
I was able to created a custom tag successfully with the exaple provided by gdemaria. THANKS.
now the problem is , if I go bak and edit my order, I should be able to pre-select the options which I have selected originally like following.
<option value="#myvalue#" <cfif #ListFind(preselectedValue
I am going to try it by adding another parameters to my customtag and use the similar condition like above. But if you have a better solution, please update me.
Thanks
I was able to created a custom tag successfully with the exaple provided by gdemaria. THANKS.
now the problem is , if I go bak and edit my order, I should be able to pre-select the options which I have selected originally like following.
<option value="#myvalue#" <cfif #ListFind(preselectedValue
I am going to try it by adding another parameters to my customtag and use the similar condition like above. But if you have a better solution, please update me.
Thanks
Featured Post
ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
PROBLEM: How to open a cfwindow or run a function on double click of a cfgrid row.
One of my clients wanted to be able to double click on a row item to get more detailed information about a transaction and to be able to modify the line items i…
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented.
Please …
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB.
How Percona can help
Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses
Course of the Month13 days, 14 hours left to enroll
800 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.