You'll need to parse out and replace every CF variable in the text (i.e.
find this string #ColdFusion_Variable# and replace it with
Evaluate(ColdFusion_Variable) )
Hope that helps.have fun ;-)
Cheers
- Original Message -
From: Stewart, Ryan [EMAIL PROTECTED]
To: CF-Talk
can you wrap a cfoutput around the ## variable?
On 6/13/05, Stewart, Ryan [EMAIL PROTECTED] wrote:
I have a column in a SQL table that contains a string of text that
includes ColdFusion variables. When I query the text, I'd like the
values of the ColdFusion variables to output on the screen.
can you wrap a cfoutput around the ## variable?
How do you see that helping Greg? The cfoutput would still be part of the
variable being outputted (i.e. the text from the field in the DB).so
you'd see the cfoutput#MyVar#/cfoutput on the screen.
Bryan
.
Thanks for taking a stab at it, any more ideas?
-Ryan
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, June 13, 2005 2:04 PM
To: CF-Talk
Subject: Re: Using CF Variables Returned from a SQL Query
You'll need to parse out and replace every CF variable
PROTECTED]
Sent: Monday, June 13, 2005 2:04 PM
To: CF-Talk
Subject: Re: Using CF Variables Returned from a SQL Query
You'll need to parse out and replace every CF variable in the text (i.e.
find this string #ColdFusion_Variable# and replace it with
Evaluate(ColdFusion_Variable) )
Hope
Have you tried #evaluate(#big_text#)#?
-Original Message-
From: Stewart, Ryan [mailto:[EMAIL PROTECTED]
Sent: Monday, June 13, 2005 4:04 PM
To: CF-Talk
Subject: RE: Using CF Variables Returned from a SQL Query
It still isn't working. I've tried a couple of things. Before, my
query
Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]
Sent: Monday, June 13, 2005 2:04 PM
To: CF-Talk
Subject: Re: Using CF Variables Returned from a SQL Query
You'll need to parse out and replace every CF variable in the text (i.e.
find this string #ColdFusion_Variable# and replace
@houseoffusion.com
Sent: Monday, June 13, 2005 1:03 PM
Subject: RE: Using CF Variables Returned from a SQL Query
It still isn't working. I've tried a couple of things. Before, my
query statement was written as:
cfoutput query=myQuery
#big_text#
/cfoutput
So I went through and made the changes you
Subject: Re: Using CF Variables Returned from a SQL Query
No No Nothat's not what I said ;-)
OKthe stepped approach ;-)
assumptions:
-MyField is the anme of the field that conatins the CF vars -MyVar is the
name of one of the CF vars contained in MyField
1) retrieve data
2) output
Bryan Stevenson wrote:
can you wrap a cfoutput around the ## variable?
How do you see that helping Greg? The cfoutput would still be part of the
variable being outputted (i.e. the text from the field in the DB).so
you'd see the cfoutput#MyVar#/cfoutput on the screen.
Here's a repost
Of course you could use
cfset SetVariable(myvarvalue,myVar) instead of using an evaluate (I
heard
a rumor that evaluate had some performance considerations...).
- Calvin
Yepbut the point is he was simply replacing one string with another and
not with the actual evaluated value of the
: Using CF Variables Returned from a SQL Query
Of course you could use
cfset SetVariable(myvarvalue,myVar) instead of using an evaluate (I
heard
a rumor that evaluate had some performance considerations...).
- Calvin
Yepbut the point is he was simply replacing one string with another
12 matches
Mail list logo