I had the same problem with MS SQL Server from MX 6 to MX6.1 and i tryed
to change(in your case)
dbvarname="@StaffNumber"
by
varname="StaffNumber"
And it works ok
Regards
__
MSc. Hassan Arteaga Rodríguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.
-----Original Message-----
From: John Beynon [mailto:[EMAIL PROTECTED]
Sent: Friday, November 28, 2003 09:57 AM
To: CF-Talk
Subject: differences with stored procs MX/5
Hi,
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]
