<!--- Función para obtener el id de un usuario dado su nick name y
password--->
<cffunction access="public" name="GetUserId" output="false"
returntype="query">
<cfargument name="txtLogin" type="string" required="yes" default="">
<cfargument name="txtPass" type="string" required="yes" default="">
<cfstoredproc procedure="sp_comprobar_pass" datasource="DIGIDSN">
<cfprocresult name="User_DataSet">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="user"
value="#arguments.txtLogin#" maxlength="100" null="no">
<cfprocparam type="In" cfsqltype="CF_SQL_VARCHAR" variable="pass"
value="#arguments.txtPass#" maxlength="100" null="no">
</cfstoredproc>
<cfreturn User_DataSet>
</cffunction>
__
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 10:20 AM
To: CF-Talk
Subject: RE: differences with stored procs MX/5
Just tried that, it throws an error
The tag does not allow the attribute(s) VARNAME. The valid attribute(s)
are
CFSQLTYPE,CFVARNAME,DBVARNAME,MAXLENGTH,MAXROWS,NULL,SCALE,TYPE,VALUE,VA
RIAB
LE.
-----Original Message-----
From: Hassan Arteaga Rodriguez [mailto:[EMAIL PROTECTED]
Sent: 28 November 2003 17:11
To: CF-Talk
Subject: RE: differences with stored procs MX/5
Hi John !!
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]
