Well I can answer the on topic part. You access the recordcount the exact same way....queryname.recordcount ;-)
The second part may require more info.... Where are you disbaling select, update, delete? In CF Admin for the datasource? In SQL Server? It certainly make sense that if you disable select access that you would get that error....but perhaps I'm missing something ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 18, 2003 3:18 PM Subject: cfstoredproc questions SOT > 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
