> Isaac's SQL abstraction layer would probably help in > instances like this as well. No need to convert all > those "TOP"s to "LIMiT"s ;-) (I'm guessing, as I > haven't checked it out yet, but it does sound like > a "good idea").
Well it's definitely a trade. :) The abstraction layer is always going to be less efficient than hand-coded ad-hoc SQL. I prefer it because it gives me a level of flexibility (both platform and syntax reuse) that wouldn't be available to me with ad-hoc SQL, but that doesn't necessarily mean it's going to be the right tool for every project. I'm not real certain how it wandered into a discussion of naming conventions. :) I did want to mention that the abstraction layer's application of "top" or "limit" functionality isn't unique to the framework. It uses the cfquery tag's maxrows attribute to produce that result, rather than relying on SQL syntax because SQL Server (and possibly others -- I haven't researched it much) doesn't support the standard "LIMIT" syntax. So that being said, just using ColdFusion gives you that capability. The exception would be with subqueries, but the framework doesn't let you apply top/limit to subqueries, so again in that respect it doesn't provide more than the hand-coded ad-hoc cfquery. s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237852 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
