I've got this chuck of code:
<CFSTOREDPROC procedure="Holiday_RetrieveAllUserInfo" datasource="*****"
username="*****" password="****">
<cfprocparam type="in" dbvarname="@StaffNumber"
cfsqltype="cf_sql_integer" value="#session.user.staffnumber#">
<cfprocparam type="in" dbvarname="@YearStamp"
cfsqltype="cf_sql_integer" value="#session.user.staffnumber#">
<cfprocparam type="out" dbvarname="@TOTALDAYS"
cfsqltype="cf_sql_float" variable="TOTALDAYS">
<cfprocparam type="out" dbvarname="@HOLIDAY_SUM"
cfsqltype="cf_sql_float" variable="HOLIDAY_SUM">
<cfprocparam type="out" dbvarname="@REMAININGDAYS"
cfsqltype="cf_sql_float" variable="REMAININGDAYS">
<cfprocparam type="out" dbvarname="@SICKNESS"
cfsqltype="cf_sql_float" variable="SICKNESS">
<cfprocparam type="out" dbvarname="@permitted"
cfsqltype="cf_sql_float" variable="PERMITTED">
<cfprocparam type="out" dbvarname="@COMPASSIONATE"
cfsqltype="cf_sql_float" variable="COMPASSIONATE">
</CFSTOREDPROC>
On Cf5 it executes perfectly, but on CFMX 6.1 pointing at exactly the same
SQL7 Db and it doesn't return the expected results...
Has anything changed between the versions of CF?
Thanks,
Jb.
**********************************************************************
Copyright ERA Technology Ltd. 2003. (www.era.co.uk). All rights reserved. The information supplied in this Commercial Communication should be treated in confidence.
No liability whatsoever is accepted for any loss or damage
suffered as a result of accessing this message or any attachments.
**********************************************************************
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
