CFML from MSSQL

[KingScooby]

I am attempting to pull CFML, <cfoutput>'s, etc. from a database and have them
inserted into a .cfm page and executed at runtime. Instead of the CFML tags
are stripped and all the code within the <cf*> tags is displayed literally.

Example:

<cfquery name="qUsername" datasource="SQLServer" username="*****"
password="*****">
SELECT * FROM dbo.websiteUsers WHERE dbo.websiteUsers.lastname =
'<cfoutput>#URL.lastname#</cfoutput>' AND dbo.websiteUsers.firstname =
'<cfoutput>#URL.firstname#</cfoutput>' AND dbo.websiteUsers.username =
'<cfoutput>#URL.username#</cfoutput>' AND dbo.websiteUsers.email =
'<cfoutput>#URL.email#</cfoutput>'
</cfquery>

displays literally:

SELECT * FROM dbo.websiteUsers WHERE dbo.websiteUsers.lastname =
'#URL.lastname#' AND dbo.websiteUsers.firstname = '#URL.firstname#' AND
dbo.websiteUsers.username = '#URL.username#' AND dbo.websiteUsers.email =
'#URL.email#'

How can I pull CFML from a database and have it execute on the .cfm?

I've posed this question on [url]www.experts-exchange.com[/url] and the 'expert' told me
it couldn't be done...I'm really hoping he is wrong.
-adam.

[Neculai Macarie]

> I am attempting to pull CFML, <cfoutput>'s, etc. from a database and have
them

> inserted into a .cfm page and executed at runtime. Instead of the CFML

tags

> are stripped and all the code within the <cf*> tags is displayed

literally.

>
> Example:
>
> <cfquery name="qUsername" datasource="SQLServer" username="*****"
> password="*****">
> SELECT * FROM dbo.websiteUsers WHERE dbo.websiteUsers.lastname =
> '<cfoutput>#URL.lastname#</cfoutput>' AND dbo.websiteUsers.firstname =
> '<cfoutput>#URL.firstname#</cfoutput>' AND dbo.websiteUsers.username =
> '<cfoutput>#URL.username#</cfoutput>' AND dbo.websiteUsers.email =
> '<cfoutput>#URL.email#</cfoutput>'
> </cfquery>
>
> displays literally:
>
> SELECT * FROM dbo.websiteUsers WHERE dbo.websiteUsers.lastname =
> '#URL.lastname#' AND dbo.websiteUsers.firstname = '#URL.firstname#' AND
> dbo.websiteUsers.username = '#URL.username#' AND dbo.websiteUsers.email =
> '#URL.email#'
>
> How can I pull CFML from a database and have it execute on the .cfm?
>
> I've posed this question on [url]www.experts-exchange.com[/url] and the 'expert'

told me

> it couldn't be done...I'm really hoping he is wrong.

You need to write the content to a temporary file, cfinclude that file, then
delete it (to keep the place clean).

--
<mack />

[KingScooby]

Thanks for your response.

Would you be so kind as to provide some sample code?

[Neculai Macarie]

> Thanks for your response.

>
> Would you be so kind as to provide some sample code?

Something like this (untested):
<cffile action="write" file="#ExpandPath('.')#/temp.cfm"
output="#query.cfml_code_field#">

<cfinclude template="temp.cfm">

<cffile action="delete" file="#ExpandPath('.')#/temp.cfm">

--
<mack />