Might be better to use a datagrid and specify the columns. John Mason [EMAIL PROTECTED] 770.337.8363
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, June 23, 2008 3:18 PM To: discussion Subject: [AFFUG Discuss] Binding to a non-displayed combo-box column I've got a combo box that is populated by a RemoteObject that returns two additional columns, name and address, and shows the building number. I need to display the other two columns in labels or text fields so the user knows they selected the correct building. They don't want to see all three in the combo box - I already tried that and they didn't go for it. I can't figure out the syntax to get the label text to populate when the combo box changes. Here's what I have so far: CFC: <cffunction name="FACILITY_NUMBERLookup" access="remote" output="false" returntype="query"> <cfset var qLookup=""> <cfquery name="qLookup" datasource="gte911_mdevl"> SELECT FAC_NUMBER, ABBR_NAME, ADDRESS FROM GT_FACILITY WHERE (STATUS = 'A') UNION SELECT ' ', ' ', ' ' FROM dual ORDER BY FAC_NUMBER </cfquery> <cfreturn qLookup> </cffunction> REMOTE OBJECT: <mx:RemoteObject id="referenceManager" showBusyCursor="true" destination="ColdFusion" source="gte911.components.cfgenerated.msag.MASTER_STREET_ADDRESS_TBLResource s"> <mx:method name="FACILITY_NUMBERLookup" result="MASTER_STREET_ADDRESS_TBL_FACILITY_NUMBERLookup_result(event)" fault="server_fault(event)" /> </mx:RemoteObject> COMBO_BOX: <cfComponents:BindableComboBox id="MASTER_STREET_ADDRESS_TBL_FACILITY_NUMBER" selectedItem="{this.detailObject.FACILITY_NUMBER}" valueField="FAC_NUMBER" labelFields="[FAC_NUMBER]" width="100%" /> *** Here I'm just displaying the selectedIndex as a bit of a sanity check *** <mx:Label width="100%" id="FACILITY_NAME" text="{this.MASTER_STREET_ADDRESS_TBL_FACILITY_NUMBER.selectedIndex}" /> -- Andy Fox Systems Analyst III Georgia Tech OIT-EIS 404-894-4413 ------------------------------------------------------------- To unsubscribe from this list, simply email the list with unsubscribe in the subject line For more info, see http://www.affug.com Archive @ http://www.mail-archive.com/discussion%40affug.com/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, simply email the list with unsubscribe in the subject line For more info, see http://www.affug.com Archive @ http://www.mail-archive.com/discussion%40affug.com/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
