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
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
We are trying to gain more information about potential attendees for Flash (Flex) Camp ATL. If you would like to help shape the direction of the event, please fill out the following survey:http://bit.ly/9SWSFThanks,thereshouldbeanannouncementsoonaboutlocationanddateoftheevent.Andy
Mark,
To be honest, I am still unsure what you are trying to accomplish.
You mention a mail merge. How is the merged document sent out? Are you
storing a copy of the file? Are you generating a document dynamically to
display on the screen for printing?
Color me curious...
Teddy
Another approach is using replace(). SO in your DB store
Welcome $:1 to the end of the Internet
Then use a function call to wrap things
fetchWelcomeText( cookie.username )
fetchWelcomeText() would look something like
cfquery name=myQuery datasource=dataSource
select myText from
As a last resort I have in the past written out and cfincluded a file based on
the contents of a database field. Obviously there are some security and
performance implications, but the ability to have CF interpret code (and not
just an expression) from a database can sometimes come in handy.
:
Thank you all very much for your suggestions, however, I'm afraid I didn't
fully explain the complexity of the situation. See, I'll need to select the
text of the form letter that contains the CF variables which will reference
other queries on the same page. So, for example, let's say we're
FWIW, I'll note that while I appreciate the cons of the idea, I also know
that others have seen the pros of it, and the BlueDragon engineers did as
well, and they added a Render function to let you execute CFML code as found
in any variable, whether from a DB query, a shared scope variable, etc.
I would love to attend this remotely.
I wonder if we could get Adobe to pay for the equipment to stream the
meetings at a couple of key cities - maybe Atlanta and DC?
All of the Adobe groups in town could share / pass around the equipment?
Live interaction wouldn't be necessary - but the ability