Greetings all, I'm trying to figure out a way in CF7 to store CF variables in the database to be selected out later and evaluated just like regular CF variables.
For example, and I know this is a stupid example, but it's simple and makes the point, let's assume I have a database table called welcome_statements and it has a single column that contains string data such as "Welcome, #cookie.user_name#." In my home.cfm file, I write a query like select my_text from welcome_statements and have a CFOUTPUT block like <cfoutout>#myQuery.my_text#</cfoutput>. I've tried using various combinations of evaluate() and de() and replacing the # in the database with something that is replaced on evaluation in the query and in the cfoutput. All to no avail. I know you're wondering, "Why would you want to do a fool thing like that?" Well, I'm trying to figure out how to allow users to write form letters or MS Word-like mail-merge documents. I imagine it would be simpler in CF than to write some manner of database function/procedure which is why I'm asking for your assistance. Many thanks in advance. mf mark fennell athens regional medical center athens, ga ----------------------------------------------------------------------- This email is intended only for the named recipient(s). It may contain information that is proprietary, confidential or otherwise prohibited from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please reply immediately by email or telephone me at 706-475-4357 and delete all copies of the message. ----------------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
