I figured it out, but if you have a more elegant solution, I'm open to
suggestions.
Here's my current solution.
<cfquery name="myQuery" datasource="dataSource">
select myText from welcome_statements
</cfquery>
<cfoutput>#evaluate("#de(myQuery.myText)#")#</cfoutput>
Thanks.
mf
-----Original Message-----
From: Fennell, Mark P.
Sent: Tuesday, June 30, 2009 4:57 PM
To: '[email protected]'
Subject: CF in the database?
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
-------------------------------------------------------------
