<CFSTOREDPROC DATASOURCE="#application.datasource#" DBNAME="userpreferences"
PROCEDURE="GetUserID">
<CFPROCPARAM CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@SAMAccountName"
VALUE="#GetUser.SAMAccountName#" TYPE="In">
<!--- <CFPROCPARAM TYPE="Out" DBVARNAME="@UserID" VARIABLE="UserID"
CFSQLTYPE="CF_SQL_INTEGER"> --->
<CFPROCRESULT NAME="UserID>
</CFSTOREDPROC>
Your second call to CFPROCPARAM is specifying that your procedure accepts
two arguments. You only have one listed in your example, so I'm assuing
that you were calling the procedure in-correctly.
Joseph E. Sheble
a.k.a. Wizaerd
Wizaerd's Realm
Canvas, 3D, Graphics,
ColdFusion, PHP, and mySQL
http://www.wizaerd.com
=================================
> -----Original Message-----
> From: S R [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 05, 2000 2:46 PM
> To: CF-Talk
> Subject: cfstored procedure problem
>
>
> Hi everyone,
>
> I can't figure this one out. I'm using SQL Server 7.0 and CF 4.5
>
> This is my stored procedure in SQL:
>
> @SAMAccountName varchar
>
> AS
>
> SELECT UserID FROM PasUsers
> WHERE SAMAccountName = '@SAMAccountName'
>
> Here is my CF Code:
>
> <CFLDAP NAME="GetUser" SERVER="LDAPSERVER.COM" ACTION="QUERY"
> ATTRIBUTES="SAMAccountName" SCOPE="subtree"
> FILTER="SAMAccountName=#cgi.auth_user#" START=""
> USERNAME="mydomain\sal.rosales" PASSWORD="password" PORT="0000"
> TIMEOUT="30">
>
> <CFSTOREDPROC DATASOURCE="#application.datasource#"
> DBNAME="userpreferences"
> PROCEDURE="GetUserID">
> <CFPROCPARAM CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@SAMAccountName"
> VALUE="#GetUser.SAMAccountName#" TYPE="In">
> <CFPROCPARAM TYPE="Out" DBVARNAME="@UserID" VARIABLE="UserID"
> CFSQLTYPE="CF_SQL_INTEGER">
> </CFSTOREDPROC>
>
> <cfoutput>#UserID#</cfoutput>
>
> I keep getting a 'Data Access Error Unknown data'
>
> Sal
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
