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