Viewing 6 posts - 1 through 6 (of 6 total)
Problem solved. The incoming parameters need to be stated in the executesql :
CREATE PROCEDURE newPrimaryMainContact
@FName varchar(255),
@LName varchar(255),
@Email varchar(255)
AS
DECLARE @PeopleID int
DECLARE @SQLString NVARCHAR(1000)
DECLARE @params nvarchar(500)
SET @params =...
March 9, 2006 at 10:58 am
@PeopleID has already been declared.
So the update to this is that I didnt have the 'sp_executesql in the EXECUTE statement - having added that, now its choking on the @FName...
March 9, 2006 at 10:20 am
It is a stored procedure. CF has a tag that passes variables to the sp in sqlserver.
I just dont get it, as it runs fine in query analyzer but bails...
March 8, 2006 at 4:18 pm
Yes - today coldfusion is spitting this back at me (yesterday it was different although that could have been typos for all I know):
[Macromedia][SQLServer JDBC Driver][SQLServer]The name 'SELECT @PeopleID =...
March 8, 2006 at 4:03 pm
Done TY
March 8, 2006 at 3:28 pm
I have a similar problem Im trying to solve.
I need to create a stored procedure which holds 3 different insert statements - one of the inserts occurs on a table...
March 8, 2006 at 2:26 pm
Viewing 6 posts - 1 through 6 (of 6 total)