Are you using CF 5 or something else older than CFMX? Evaluate() is generally slower than other methods and should be avoided if possible, but CFMX was the first version to eliminate most of the cases where it is necessary.
-----Original Message----- From: Nick Sweeney [mailto:[EMAIL PROTECTED] Sent: Friday, 29 July 2005 11:17 AM To: CF-Newbie Subject: RE: Dynamic Query Trouble Well - I tried this and I still get the error: [Table (rows 1 columns NATIONALITYID): [NATIONALITYID: [EMAIL PROTECTED] ] is not indexable by NationalityID Why should I not use Evaluate? Too much Processor time or something? -Nick -----Original Message----- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, July 28, 2005 7:36 PM To: CF-Newbie Subject: RE: Dynamic Query Trouble Don't use Evaluate(). You need <cfset S1 = qryGetSearchType1[ColID1][1]> (notice the row index as well). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
