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 -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Monday, June 13, 2005 4:19 PM To: CF-Talk Subject: Re: Using CF Variables Returned from a SQL Query No No No....that's not what I said ;-) OK....the 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 the query 3) while outputting the query you: -EVALUATE the value of MyVar <cfset MyVarValue = Evaluate("MyVar")> -REPLACE the string #MyVar# (in MyField) with it's value <cfset MyNewField = ReplaceNoCase(MyField,"#MyVar#",MyVarValue,"ALL")> -use MyNewField as your output instead of the raw MyField All you did was replace a string with another string (even though it looked like a var). You have to replace the string with the evaluated value of the variable. <cfoutput query="MyQuery"> <cfset MyVarValue = Evaluate("MyVar")> <cfset MyNewField = ReplaceNoCase(MyField,"#MyVar#",MyVarValue,"ALL")> #MyNewField # </cfoutput> Hope that clears it up ;-) Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ----- Original Message ----- From: "Stewart, Ryan" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@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 suggested, and my text > outputted to the screen as: > > Some text here, some more text, a Evaluate("ColdFusion_Variable") here, > some more text, even more text. > > So then I tried changing my cfoutput statement to this: > > <cfoutput query="myQuery"> > #Evaluate("big_text")# > </cfoutput> > > But still no change. I also tried replacing the > Evaluate("ColdFusion_Variable") with #Evaluate("ColdFusion_Variable")# > but got the same thing. > > 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 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" <cf-talk@houseoffusion.com> > Sent: Monday, June 13, 2005 10:59 AM > Subject: Using CF Variables Returned from a SQL Query > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:209340 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
