No - remember (unless I read him wrong), he said Request.thisQuery was the _name_ of the query, ie, request.thisQuery = "GetUsers", and what he really wants is GetUsers.Name. (Did I read you right Mike?)
======================================================================= 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 > -----Original Message----- > From: Ryan Emerle [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 07, 2003 3:34 PM > To: CF-Talk > Subject: RE: Using Evaluate > > > This should work: > > #Request.thisQuery["Name"]# > > -Ryan > -----Original Message----- > From: Mike Alberts [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 07, 2003 3:51 PM > To: CF-Talk > Subject: Using Evaluate > > > Hello All, > > I've read many of you discouraging the use of the 'Evaluate' > function, for > performance reasons. So I ask ... > > Say I have code like this (within a cfoutput): > > #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? > > 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)? > > Thanks for any help, > > Mike Alberts > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4