Question
Running in this order
I need to run several stored procedures in certain order
If I write them this way will they ran in this exact order? stored proc 1 is ran first then 2,3 and finally 4?
<cfstoredproc procedure="str_Proc_1" datasource="ABC">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@id" value="#session.id#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@fn" value="#url.fn#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@ln" value="#url.ln#">
</cfstoredproc>
<cfstoredproc procedure="str_Proc_2" datasource="ABC">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@value1" value="#somevalue#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@value1a" value="#somevalue#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@value1b" value="#somevalue#">
</cfstoredproc>
<cfstoredproc procedure="str_Proc_3" datasource="ABC">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@value2" value="#somevalue#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@value2a" value="#somevalue#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@value2b" value="#somevalue#">
</cfstoredproc>
<cfstoredproc procedure="str_Proc_4" datasource="ABC">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@value3" value="#somevalue#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@value3a" value="#somevalue#">
<cfprocparam type="in" cfsqltype="cf_sql_varchar" dbvarname="@value3b" value="#somevalue#">
</cfstoredproc>
AdChoices