I recommend you check out this article by Samuel Neff: Learning Stored Procedure Basics in ColdFusion MX http://www.adobe.com/devnet/coldfusion/articles/stored_procs.html "Most ColdFusion applications center around a database. The key to creating efficient and secure ColdFusion applications is ensuring that all database interaction are both efficient and secure. Stored procedures help developers accomplish both of these goals and also accomplish greater abstraction between the application code and database details. In this article, we'll explore stored procedures and review a few examples using Oracle, Microsoft SQL Server (MSSQL), and Microsoft Access."
See also this by Darryl Bantarri: A Beginner's Guide to using Stored Procedures in ColdFusion http://www.adobe.com/devnet/coldfusion/articles/beg_storedproc.html -Steven Erat > -----Original Message----- > From: Terry Troxel [mailto:[EMAIL PROTECTED] > Sent: Friday, November 03, 2006 1:04 PM > To: CF-Talk > Subject: cfstoredproc > > I would really appreciate it if someone could > Show me a simple example of how to use cfstoreproc > With a MSSQL stored procedure and then the code to > Display the results of that. > > I have worked with Access for years and am relatively new > To MSSQL and have never used that tag. We have a new > software > In-house that uses MSSQL and the company that wrote it > utilizes > Stored procedures a lot, so I need to get up to speed on > using > CF with it. > > Terry Troxel ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
