Hello, I am newbie in Coldfusion development and I have a question:
I must make a application where I have to use a parameter in a database (and not written in the code).
Example: I have to show a text of a table with a "subtext" of other table. So I do this:
id = 1
text = "This is an #qry_2.subtext#"
id = 1
subtext = "example"
<cfquery datasource="#application.DSN#" name="qry_1"> SELECT text FROM table1 WHERE id = 1 </cfquery> <cfquery datasource="#application.DSN#" name="qry_2"> SELECT subtext FROM table2 WHERE id = 1 </cfquery> <cfoutput>#qry_1.text#</cfoutput>
But only appear "This is an #qry_2.subtext#", and not "This is an example". The Coldfusion can´t read the ## of the string of database and put the subtext of table2.
There is a solution to make the Coldfusion read a ## parameter of a database with process it?
Obs.: Sorry my poor english. I am brazilian. :)