somehow the last two cfprocparam's are not being included. I tried
switching the orders around but its always the last two that are not being
sent to the stored proc... Please help!
Thanks,
Tim
here is my code:
<cfstoredproc datasource="#Request.DSN_InSite#" procedure="Get_Claims"
returncode="Yes">
<cfprocresult name="Get_Claims">
<cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="@active" null="No"
type="In" value="#active#">
<cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="@litigated" null="No"
type="In" value="#litigated#">
<cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="@environmental"
null="No" type="In" value="#environmental#">
<cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="@incidentOnly" null="No"
type="In" value="#incidentOnly#">
<cfprocparam cfsqltype="CF_SQL_DATE" dbvarname="@incidentStart"
null="#iif(incidentStart NEQ "", DE("No"), DE("Yes"))#" type="In"
value="#incidentStart#">
<cfprocparam cfsqltype="CF_SQL_DATE" dbvarname="@incidentEnd"
null="#iif(incidentEnd NEQ "", DE("No"), DE("Yes"))#" type="In"
value="#incidentEnd#">
<cfprocparam cfsqltype="CF_SQL_DATE" dbvarname="@closedStart"
null="#iif(closedStart NEQ "", DE("No"), DE("Yes"))#" type="In"
value="#closedStart#">
<cfprocparam cfsqltype="CF_SQL_DATE" dbvarname="@closedEnd"
null="#iif(closedEnd NEQ "", DE("No"), DE("Yes"))#" type="In"
value="#closedEnd#">
<cfprocparam cfsqltype="CF_SQL_DATE" dbvarname="@assignStart"
null="#iif(IsDefined("Form.assignStart"), DE("No"), DE("Yes"))#" type="In"
value="#iif(IsDefined("Form.assignStart"), "Form.assignStart", DE(""))#">
<cfprocparam cfsqltype="CF_SQL_DATE" dbvarname="@assignEnd"
null="#iif(IsDefined("Form.assignEnd"), DE("No"), DE("Yes"))#" type="In"
value="#iif(IsDefined("Form.assignEnd"), "Form.assignEnd", DE(""))#">
<cfprocparam cfsqltype="CF_SQL_DATE" dbvarname="@reportedStart"
null="#iif(IsDefined("Form.reportedStart"), DE("No"), DE("Yes"))#" type="In"
value="#iif(IsDefined("Form.reportedStart"), "Form.reportedStart",
DE(""))#">
<cfprocparam cfsqltype="CF_SQL_DATE" dbvarname="@reportedEnd"
null="#iif(IsDefined("Form.reportedEnd"), DE("No"), DE("Yes"))#" type="In"
value="#iif(IsDefined("Form.reportedEnd"), "Form.reportedEnd", DE(""))#">
<cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@buildingNumber"
null="#iif(buildingNumber NEQ "", DE("No"), DE("Yes"))#" type="In"
value="#buildingNumber#">
<cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="@wnc" null="no"
value="#iif(IsDefined("wnc"), "wnc", DE("2"))#">
<cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="@incidentType"
null="#iif(IsDefined("Form.incidentType"), DE("No"), DE("Yes"))#" type="In"
value="#iif(IsDefined("Form.incidentType"), "Form.incidentType", DE(""))#">
</cfstoredproc>
and here is part of my stored proc:
CREATE PROC Get_Claims
(
@active integer
, @litigated integer
, @environmental integer
, @incidentOnly integer
, @incidentStart datetime
, @incidentEnd datetime
, @closedStart datetime
, @closedEnd datetime
, @assignStart datetime
, @assignEnd datetime
, @reportedStart datetime
, @reportedEnd datetime
, @buildingNumber varchar(6)
, @wnc integer
, @incidentType integer)
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
