> 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>
It looks to me like your stored procedure is returning a recordset, not a
parameter, but your CFSTOREDPROC tag is referencing an output parameter
instead of a recordset. Try this:
<cfstoredproc ...>
<cfprocparam cfsqltype="CF_SQL_VARCHAR" dbvarname="@SAMAccountName"
value="#GetUser.SAMAccountName#" type="in">
<cfprocresult name="MyUserID">
</cfstoredproc>
<cfoutput>#MyUserID.UserID#</cfoutput>
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
