> > #Evaluate(Request.ThisQuery & ".Name")#, where > Request.ThisQuery is the name > of a query that I set and ".Name" refers to a column in the > table that I am > querying. Obviously this returns the value of the column for > that particular > record. > > 1. Is there another way to code this to not use Evaluate?
In MX, yes. If request.thisquery == the name of a local variable, you would do: #variables[request.thisQuery].name. > 2. If there ISN'T another way, would I be better off from a > performance > standpoint to run the Evaluate function once and set a > variable with the > value that it returns and just call that variable, instead of > using Evaluate > multiple times in the page (hope that made sense)? Yes, I would think so, unless the query is huge (since you would be making a copy of the entire query. WHy not make it easier on yourself. Create a structure (again, assuming not MX), called myQueries, and place your query in there. Then you can use bracket notation. ======================================================================= Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Email : [EMAIL PROTECTED] WWW : www.camdenfamily.com/morpheus Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
