Macromedia has posted an article onUsing Stored Procedures with ColdFusion for the beginner.
The scenario: You are a ColdFusion developer and your boss has asked you to create a simple web-based employee directory using ColdFusion to access stored procedures that the database administration group of your company created. For security reasons, you can only use stored procedures, not direct queries, to access the data from a sensitive personnel database. How do you succeed at developing the application?
Worth a look if you are thinking about using Stored Procedures in your Coldfusion, but you don't know where to start.