Here's how you could dynamically create the XML for that combo box:
<?xml version="1.0" ?>
<cfsetting enablecfoutputonly="yes">
<cfquery name="mfg_list" datasource="carnivore">
SELECT MfgID, MfgName
FROM Mfg
</cfquery>
<cfoutput>
<combobox>
<cfloop query="mfg_list">
<item value="#MfgID#">#MfgName#</item>
</cfloop>
</combobox>
</cfoutput>
<cfsetting enablecfoutputonly="no">
HTH :)
Ps. If enough people are interested, I can put together an example and make
it available online. Just let me know :)
--
SCOTT VAN VLIET
SENIOR ANALYST
SBC SERVICES, INC
Tel: 858.886.3878
Fax: 858.653.6763
Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
-----Original Message-----
From: Douglas Brown [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 19, 2002 9:20 AM
To: CF-Talk
Subject: Flash MX and CF5
We prob need a CF-flashTalk list, but in the meantime I am just now
beginning my journey into dynamic content in flash, and was wondering if
someone had an idea of how to populate a combo box from a query...
I have this so far, please help.
Query
<CFQUERY DATASOURCE="carnivore" NAME="mfg_list">
SELECT *
FROM mfg
</CFQUERY>
<CFSET myList = ValueList(mfg_list.mfgid,",")>
<CFOUTPUT>&mfg=#myList#</CFOUTPUT>
Flash
Button action
on (release) {
loadVariablesNum("http://www.carnivorepc.com/console/qry/qry_mfg_list.cfm";,
0, "GET");
mfgList.addItem(mfg);
}
"Success is a journey, not a destination!!"
Doug Brown
______________________________________________________________________
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
