Passing database column names as varable

[KriZzZz]

I've tried all night to figure this one out..And I can't seem to find the
answear on the forums..

I've made a CustomTag-file that need these attributes:

KRISGRAPH.CFM:
<CFPARAM NAME="Attributes.Database_ColumnName">
<CFPARAM NAME="Attributes.DATASOURCE">
<CFPARAM NAME="Attributes.TABLE">

And then I pass the ColumnName to the CustomTag with these attribute values:
INDEX.CFM:
<CF_KRISGRAPH
DATASOURCE="MYFIRM"
TABLE="Customers"
Database_ColumnName="Customer_Name"

>

And then i want to output the particular column values from
#Attributes.Database_ColumnName#
<cfquery name="Graph_01" datasource="#Attributes.DATASOURCE#">
SELECT * FROM #Attributes.TABLE#
</cfquery>

<cfoutput query="Graph_01">
#Attributes.Database_ColumnName#, <br>
</cfoutput>

The result is ofcourse only the Customer_Name and not the value of it...:
Customer_Name,
Customer_Name,
Customer_Name,
Customer_Name,

I understand why it does it, but how can i get around it and nicly output the
value of it instead?

Cheers!

[BKBK]

<CFPARAM NAME="Attributes.Database_ColumnName">
<CFPARAM NAME="Attributes.DATASOURCE">
<CFPARAM NAME="Attributes.TABLE">

is not necessarily wrong. However, it's the usual practice to set the default
values, thus

<CFPARAM NAME="Attributes.Database_ColumnName" DEFAULT="Customer_Name">
<CFPARAM NAME="Attributes.DATASOURCE" DEFAULT="MYFIRM">
<CFPARAM NAME="Attributes.TABLE" DEFAULT="Customers">

> how can i get around it and nicly output the value of it instead?

<!--- Use query's structure-key format to identify each row, and iterate by
means of in-built variable, currentrow --->
<cfoutput query="Graph_01">
#Graph_01#, <br>
</cfoutput>

[Dan Bracuk]

Your custom tag will run more quickly if you select only attributes.column_name instead of *.

[KriZzZz]

Thank you so much! Love you!

BKBK: Yeah, my bad, but i only narrowed the code here to focus on the actual
problem i had. But the default values are going in there right this second. :)

It worked perfectly, but I haven't seen that particular code before. Im quite
on the "getting-started"-level of my coding.. As i translate it to my level of
understanding, the is a variable in cold fusion that picks out a new row
inside the loop..sort of? very neat :)

Dan: Yeah. again, just to focus on the problem, so i did a fast example.

Thanks again, both you!