The only queries I have in my templates are for cached queries and then the query looks like:
<cfquery> exec usp_whatever </cfquery> I am a strong advocate of keeping the database work in the database itself. I use sp exclusively. ----- Original Message ----- From: "Bosky, Dave" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, December 07, 2001 11:45 AM Subject: Correct Usage of Stored Procedures > What's the best practice is using stored procedures, should they replace all > queries or just complex queries? > > Thanks, > Dave > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
