Perhaps like this?
for exit variables
<-- list#id of category# text
and for entry variables
--> list#id of category# text
You may want to put (dynamic variable) in really small text next to it though.
DRE
At 10:59 AM 2/20/2001 -0500, you wrote:
>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
