Greg, Yes, that's pretty much what I do. You'll see it performs better and lets your database scale further, and, to me, it's a lot easier to read and manage (personal preference). You only lose the ability to have multiple result sets, easy to get around, and return codes from the stored proc, not usually useful.
-nathan strutz http://www.dopefly.com/ On 5/9/06, Greg Luce <[EMAIL PROTECTED]> wrote: > > Nathan, > If you don't use cfstoredproc, what do you do? Just exec the sp in a > cfquery > tag? Just curious because I've been going through an old application doing > the opposite. > > Thanks, > Greg > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239946 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
