I posted this earlier but didn't get any responses...so one last time I ask:
I have a query template that produces multiple Valuelists. As the number of
variables from the first query dynamic I've set it up like so:
<CFQUERY NAME="getvariables" DATASOURCE="#request.dsn#" DBTYPE="ODBC">
SELECT ItemId, ItemName
FROM ItemTable
</CFQUERY>
Now theses variables belong to more than one category and I wish to call
them up for display, so...
<CFOUTPUT QUERY="getVariables">
<CFQUERY NAME="getCategories" DATASOURCE="#request.dsn#"
DBTYPE="ODBC">
SELECT categoryName
FROM CategoryTable
WHERE ItemId = #itemId#
</CFQUERY>
<CFSET "List#ItemId#" = ValueList(getCategories.categoryName)>
</CFOUTPUT>
My question is this, how do I mark this ("List#ItemId#" ) as an exit
variable in the qry_template.cfm and an entry variable in my
dsp_template.cfm fusedocs so that's clear to the person who ends up coding
for it? ?
Thanks for any suggestions
Ronan O'Donohoe
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
