Friday, November 09, 2007
I came to a point in my project when I had to query the database using a dynamic column name. It was easy to get the query right:
but it was tricky to print out the results of the query. After playing around with # signs and String functions, I searched for the solution online and discovered an
<cfquery name="myQuery" datasource="myDataSource">
SELECT #dynamic_column_name#
FROM #my_table_name#
</cfquery>
but it was tricky to print out the results of the query. After playing around with # signs and String functions, I searched for the solution online and discovered an
evaluate()
function:
<cfloop query="getDetails">
<cfoutput>
<field>
#evaluate(column)#
</field>
</cfoutput>
</cfloop>
Tuesday, November 06, 2007
Colors in flex: converting strings to R, G, B triples and back
here
here
Subscribe to:
Posts (Atom)