ColdFusion

Problem with <cfselect

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Dec 2008

Posts: 2

Reputation: swskpper is an unknown quantity at this point

Solved Threads: 0

swskpper

Offline

Newbie Poster

Problem with <cfselect

Dec 9th, 2008

I am a newbie and hope that someone can help. I have a <cfform that adds and updates records. I have 3 <cfselect statements that are dynamic. I user the selected attribute to display the current value if this is an update. The first one works fine.

The 2nd and 3rd will not show the current value when updating. They both show the initial value. The values are saved in the table correctly. The values are not related. Here is a sample of 2 of the selects.

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<td>
 <cfselect enabled="No"
            	name="dept_code"
                size="1"
            	id="dept_code"
            	required="yes"
            	message="Please select a Valid Department Code"
            	multiple="no"
            	query="list_active_depts"
                value="dept_code"
                display="dept_code_desc"
                selected="#user_dept_code#" onChange="#user_dept_code#"
               	queryPosition="Below">
             </cfselect>
</td>
<tr>
<td>
<cfselect name="Fstp_code"
                size="1" id="Fstp_code"
            	required="yes"
            	message="Please select a Valid FSTP Code"
            	multiple="no"
            	query="list_active_fstp"
                value="fstp_code"
                display="fstp_code_desc"
               	queryPosition="below"
                selected="#user_fstp_code#"     onChange="#User_fstp_code#">
             </cfselect>
<td>
 <cfselect enabled="No"
            	name="dept_code"
                size="1"
            	id="dept_code"
            	required="yes"
            	message="Please select a Valid Department Code"
            	multiple="no"
            	query="list_active_depts"
                value="dept_code"
                display="dept_code_desc"
                selected="#user_dept_code#" onChange="#user_dept_code#"
               	queryPosition="Below">
             </cfselect>
</td>
<tr>
<td>
<cfselect name="Fstp_code"
                size="1" id="Fstp_code"
            	required="yes"
            	message="Please select a Valid FSTP Code"
            	multiple="no"
            	query="list_active_fstp"
                value="fstp_code"
                display="fstp_code_desc"
               	queryPosition="below"
                selected="#user_fstp_code#"     onChange="#User_fstp_code#">
             </cfselect>

Any help would be greatly appreciated.

•

Join Date: Dec 2008

Posts: 45

Reputation: arrgh is an unknown quantity at this point

Solved Threads: 6

arrgh

Offline

Light Poster

Re: Problem with <cfselect

Dec 10th, 2008

Did you verify the "selected" values actually exist in the query?

Other than that the code looks okay except for the onChange. OnChange accepts javascript/actionscript. But it looks like you are passing in the selected value instead, which probably wouldn't work.

•

Join Date: Dec 2008

Posts: 2

Reputation: swskpper is an unknown quantity at this point

Solved Threads: 0

swskpper

Offline

Newbie Poster

Re: Problem with <cfselect

Dec 11th, 2008

I took out the "onchange" and the 2nd cfselect began working. I believe that the values for the 3rd select are populated. I am trying to make sure of that now.

•

Join Date: Jan 2009

Posts: 20

Reputation: jedimatt is an unknown quantity at this point

Solved Threads: 1

jedimatt

Offline

Newbie Poster

Re: Problem with <cfselect

Jan 9th, 2009

Hi,

You may be better off using the bind attribute to link multiple selects together.

Have a look at Ben Fortas example using linked selects
url: http://www.forta.com/blog/index.cfm/...elated-Selects

This is new functionalty in CF8.

rgds

JM