Friday, November 09, 2007

If anyone wondered how to post XML pieces without browser trying to interpret it, here is a workaround solution.
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:

<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