I've found that you also need to specify the size of your data type.
Something like this...
@SAMAccountName varchar(50)
hope this helps!
-----Original Message-----
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 05, 2000 11:29 PM
To: CF-Talk
Subject: Re: cfstored procedure problem
on 12/5/00 3:46 PM, S R at [EMAIL PROTECTED] wrote:
> 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'
I don't know if you purposefully left it out but you need to have:
CREATE PROCEDURE myProceduresName (@SAMAccountName varchar (field lenght) )
For example:
CREATE PROCEDURE SelectUserID ( @SAMAccountName varchar (15) )
AS
etc.
Sebastian
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
