Advanced Search

Return to Snippet

Revision: 27987
at June 29, 2010 00:43 by ChrisCantley
Initial Code 
-- This gets the data set using the CFStoredProc tag
<cfstoredProc datasource="#application.dsn.acw#" procedure="dbo.PrcVisitorsRequestInformationUpdate">
	<cfprocresult name="procReturn" >
	<cfprocparam dbvarname="firstName" value="#show.firstName#">
	<cfprocparam dbvarname="lastName" value="#show.Firstname#">
	<cfprocparam dbvarname="dayTelephone" value="#show.phoneNumber#">
	<cfprocparam dbvarname="postalcode" value="#show.zipCode#">
	<cfprocparam dbvarname="emailAddress" value="#show.Email#">
	<cfprocparam dbvarname="comments" value="#show.comment#">
	<cfprocparam dbvarname="postalcode" value="#show.zipCode#">
	<cfprocparam dbvarname="source" value="#session.siteName#">
</cfstoredProc>

-- This retrieves the the data set using CFQuery.  remember it is important to parameterize any variables you pass int.
<cfquery name="executeStoredProc" datasource="#application.dsn.acw#">
exec [dbo].[PrcVisitorsRequestInformationUpdate] '', 'TEST', 'test', '[email protected]', '5555555555', '123 Test St.', 'Memphis', 'TN', '38701', 'NotClayton', 'Comments', 'NOT Web'
</cfquery>
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Output Stored Procedure

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
ColdFusion