cf won't evaluate your variable inside a variable (#users.recordcount# inside #FAQ.answer"). you best bet will be to either store that text in a cfm file and cfinclude it, or do it on the fly by pulling that text from db, writing it to a temp file and cfinclude that file.
another alternative may be to get your users.recordcount number in a variable in the page that displays the answer, and in your text in db store a placeholder, like $$usersnumber$$, and then at cfoutput replace the placeholder text with the actual number from the variable in the page. hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Phillip M. Vector wrote: > I have in my DB under the field of answer... > > We have currently #users.recordcount# players signed up with this site > that your event would reach. While it may not be many in the pure view, > if 7 come to your convention, that would pay for our services (Figuring > the room costs a total of $200 and you charge $30 for admission). Any > above that can't hurt your bottom line. > > exactly. The #users.recordcount# as well. > > When I run this code.. > > <cfoutput query="FAQ"> > <div class="FAQAnswer"> > #Evaluate("FAQ.Answer")# > </div> > </cfoutput> > > It shows #users.recordcount# (with the pound signs) and not 32 like I > would think it would.. I tried also just putting #FAQ.Answer#, but that > doesn't work either. > > How do I make CF treat data it pulls from the DB as variables and not a > string? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313700 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
