>I hear you, but cfqueryparm was historically not "all good"... It > disables query caching via cachedwithin. This was always a frustrating > limitation and my understanding is that is has been fixed in CF8 but I > haven't played with cf8 yet to know for sure.
Not once have I needed to cache a query since I started January of 1998 version 3.1. It's probabaly just the types of apps I have built (more complex business apps than high traffic thus needing caching). So no skin off my nose on that one > Query parameter binding also has down-sides... It makes debugging via > SQL query profiling much harder (can't see the actual query & parameters > in an easy-to-read way); I don't recall if the query as seen in a > CF-generated error message looks different too. Well...that's a bit of grasping at straws IMHO. A pain for sure, but I'd rather have the performance all the time than the occasional PITA debugging a query ;-) Anyways...I think this is marks the 1 millionth time I've had this discussion....do I get a door prize?? ;-) 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 Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285764 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
