I'm trying to get html content as a string from an Access database and use that content to fill in a section of a cf page. The problem is that the content itself contains CF code which is not interpreted by ColdFusion after it is selected and displayed. How the ... do I get this to work ?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
htmlstring from DB to cf page 1
- Thread starter Kenvase
- Start date
-
1
- #2
Kenvase,
CF parses scripts, not data from DBs. You'd have to write the code to a .cfm file, and CFINCLUDE it in your target template:
<cfquery name="getcode" datasource="#dsn#">
select snippet from mytable
where #myparameters#
</cfquery>
<cffile action="write" file="#fullpathtoauniquefile#" output="#getcode.snippet#" nameconflict="overwrite">
<cfif FileExists("#fullpathtoauniquefile#"
>
<cfinclude template="#fullpathtoauniquefile#">
</cfif>
[tag and attribute accuracy not guaranteed; it's the weekend.]
HTH,
philh
CF parses scripts, not data from DBs. You'd have to write the code to a .cfm file, and CFINCLUDE it in your target template:
<cfquery name="getcode" datasource="#dsn#">
select snippet from mytable
where #myparameters#
</cfquery>
<cffile action="write" file="#fullpathtoauniquefile#" output="#getcode.snippet#" nameconflict="overwrite">
<cfif FileExists("#fullpathtoauniquefile#"
><cfinclude template="#fullpathtoauniquefile#">
</cfif>
[tag and attribute accuracy not guaranteed; it's the weekend.]
HTH,
philh
- Status