What problem are you having? I don't see any issue with your syntax. Are you losing single quotes? If so, use PreserveSingleQuotes() like this:
<cffile action="write" output="#PreserveSingleQuotes(My_Embedded_CF_SQL_Code_Here)#" file="e:\mpath\#pagename#.cfm"> If you're losing other characters. A bit more detail about the problem you're having and I'm sure someone on this list can figure it out! Dave -----Original Message----- From: Protoculture [mailto:[EMAIL PROTECTED] Sent: Monday, July 25, 2005 8:02 AM To: CF-Talk Subject: How To... I need to build a .cfm page ( assume with cffile ). In other words I will be creating a cfml page using cffile, that will be using coldfusion functions, sql statements etc passed into it as part of the new file ... How can I safely pass cf functions/sql into the cffile output attribute? See below in the #My_Embedded_CF_SQL_Code_Here# variable. It is in this variable I wish to place actual CFML and SQL content. example... <cffile action="write" output="#My_Embedded_CF_SQL_Code_Here#" file="e:\mpath\#pagename#.cfm"> <cffile action="append" output="#My_Embedded_CF_SQL_Code_Here#" file="e:\mypath\#pagename#.cfm"> perhaps there's a better way to do this, but I will need to 'build' the page dynamically. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:212721 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
