ColdFusion

Problem in dropdown list display

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

•

Join Date: Oct 2008

Posts: 1

Reputation: susan_151615 is an unknown quantity at this point

Solved Threads: 0

susan_151615 susan_151615 is offline

Offline

Newbie Poster

Problem in dropdown list display

Dec 22nd, 2008

Hi am new to cold fusion.
AM deigning a page where i need to list company names in dropdown1 and when i select any company i have to list the vendors belonging to the particularcompany in dropdown2.
When i select a partcular vendori n dropdown2 ,the address of the vendors must be displayed in the given 2 textboxes

I know how to accomplish this in java script but i wnt everyhing to be done in cold fusion.Can anyone help me in doing this by giving a sample code and am using a stored procedure from server sde instead of writing the select queries

•

Join Date: Dec 2008

Posts: 2

Reputation: elixir is an unknown quantity at this point

Solved Threads: 0

elixir

Offline

Newbie Poster

Re: Problem in dropdown list display

Dec 23rd, 2008

A CFC with 3 methods that can give you the companies,vendors,address

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<cfform name="detailsForm">
    <cfselect name="company" bind="cfc:myCFC.getCompanies()" bindonload="true">
        <option name="0">--Select Company--</option>
    </cfselect>
    <cfselect name="vendor" bind="cfc:myCFC.getvendor({company})">
        <option name="0">--Select Vendor--</option>
    </cfselect>
<cfinput name="address" type="text" label="Address:" bind="cfc:myCFC.getvendorAddress({vendor})">
</cfform>
<cfform name="detailsForm">
    <cfselect name="company" bind="cfc:myCFC.getCompanies()" bindonload="true">
        <option name="0">--Select Company--</option>
    </cfselect>
    <cfselect name="vendor" bind="cfc:myCFC.getvendor({company})">
        <option name="0">--Select Vendor--</option>
    </cfselect>
<cfinput name="address" type="text" label="Address:" bind="cfc:myCFC.getvendorAddress({vendor})">
</cfform>

If you want to do with a CFM then use it like

Help with Code Tags

ColdFusion Syntax (Toggle Plain Text)

bind="url:logic_page.cfm?getme="companies&of=";
....
bind="url:logic_page.cfm?getme="vendor&of={company}"
...

want more detail... ask..

All the best

•

Join Date: Sep 2009

Posts: 3

Reputation: ws1267 is an unknown quantity at this point

Solved Threads: 0

ws1267

Offline

Newbie Poster

Re: Problem in dropdown list display

Sep 14th, 2009

I've got a problem displaying cfselect dropdowns. I have several dropdowns, when choose one base on the selection before it, it works perfect. like country-state-city-zip.
But my problems, I need to let user able to choose from any dropdown and redraw others.
ie. Gender- school- sportType - gpa are dropdown selections. These dropdowns are populated from the same table by selecting distinct record. Just wondering if there is a way to populate the dropdowns matter user start from any dropdown first. Can I achieve it using cfselect?

Any help would be greatly appreciated.