• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Stored Procedures > Using <cfstoredproc>

Using <cfstoredproc>

<cfstoredproc> can be used to execute existing stored procedures. The tag cannot, however, be used to create stored procedures—something <cfquery> can do.

<cfstoredproc> has two child tags that are used to pass parameters into the stored procedure and to receive data back. Parameters are sent to the stored procedure by the <cfprocparam> tag and can be received by either <cfprocparam> or <cfprocresult>. The most efficient way to receive record sets from a stored procedure is to use the <cfprocresult> tag because it returns data as a record set.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint