Hey Folks, First, the on-topic question. When using <cfstoredproc> is there an easy way to return a recordcount like that which is returned by <cfquery>?
Now for the SOT question... Sorry for this question, but I have searched high and low for this info and am now at my wits end so I am posting here. I have read in a number of places (including the cftalk archives) that, for security reasons, instead of using <cfquery> you should move your queries over to stored procs and limit user access to only execute stored procedures. So, with this wonderful idea in mind, I moved all my queries over (I'm using MS SQL 2000). The thing is, that if I disable select, update, delete access and only give access to the stored procedure, I throw an error saying that I don't have select rights. What am I missing. If anyone out there can point me in the right direction you will save me from losing the last remaining hairs on my head. :) --Jeff ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
