Procedure or function usp_tCode has too many arguments

[sush1512]

Hi all ,
My stored proc is as follows
if @Code Is Null
BEGIN
SELECT * FROM TCode (NOLOCK)

END

Else
BEGIN
SELECT * FROM TCode(NOLOCK) where Code LIKE @Code
END

and in the ASP page i have written as

Sql = usp_tCode " _
& "@Code=" & dbQuoteOrNull(Code) & ", " _
& "@FInd =" & dbQuoteOrNull(FInd) & ", " _
& "@SInd = " & dbQuoteOrNull(SInd) & " , " _
& "@HIInd = " & dbQuoteOrNull(HInd) & " , " _
& "@AInd = " & dbQuoteOrNull(AInd) & " , " _
& "@CInd = " & dbQuoteOrNull(CInd) & " , " _
& "@BInd = " & dbQuoteOrNull(BInd) & " , " _
& "@MInd = " & dbQuoteOrNull(MInd) & " , " _
& "@SHO =" & dbQuoteOrNull(SHO) & " "


Im gettin the error as Procedure or function usp_tCode has too many arguments
So this means tht there r too many arguments ? so i should chnage the Stored proc or the ASP cpde. Please help

thanks in advance

[shweta123]

Hi,

I think , the error is coming at the line where you are calling the stored procedure. Please refer this Article at "http://support.microsoft.com/kb/q164485/" , it explains how to call a stored procedure using ASP.

Hi all ,
My stored proc is as follows
if @Code Is Null
BEGIN
SELECT * FROM TCode (NOLOCK)

END

Else
BEGIN
SELECT * FROM TCode(NOLOCK) where Code LIKE @Code
END

and in the ASP page i have written as

Sql = usp_tCode " _
& "@Code=" & dbQuoteOrNull(Code) & ", " _
& "@FInd =" & dbQuoteOrNull(FInd) & ", " _
& "@SInd = " & dbQuoteOrNull(SInd) & " , " _
& "@HIInd = " & dbQuoteOrNull(HInd) & " , " _
& "@AInd = " & dbQuoteOrNull(AInd) & " , " _
& "@CInd = " & dbQuoteOrNull(CInd) & " , " _
& "@BInd = " & dbQuoteOrNull(BInd) & " , " _
& "@MInd = " & dbQuoteOrNull(MInd) & " , " _
& "@SHO =" & dbQuoteOrNull(SHO) & " "


Im gettin the error as Procedure or function usp_tCode has too many arguments
So this means tht there r too many arguments ? so i should chnage the Stored proc or the ASP cpde. Please help

thanks in advance

[jhardman]

Im gettin the error as Procedure or function usp_tCode has too many arguments
So this means tht there r too many arguments ? so i should chnage the Stored proc or the ASP cpde. Please help

thanks in advance

I think you may have a syntax error. What is usp_tCode?

Jared