On 6/5/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > Title says it all. Using MS SQL Server, how do you call a stored > procedure using the CFQUERY tag?
Take your normal call from Query Analyzer and paste it into a CFQuery. <cfquery name="whatever" datasource="however"> EXEC your_procedure_name @Parmeter1 = #Parameter1Value#, @Parameter2 = '#Parameter2Value#' </cfquery> However, you're probably much better off using the CFSTOREDPROC / CFPROCPARAM tag set... it does validation and handles procedures quite nicely. HTH Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242527 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
