Kill the single quotes. No need to put them around an SQL var.
Chris
----------------------------------------------
Original Message
From: "sebastian palmigiani"<[EMAIL PROTECTED]>
Subject: Re: cfstored procedure problem
Date: Tue, 05 Dec 2000 22:29:16 -0600
>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
