Re: Stored Procedure in ASP.NET with MySQLConnector - Jesse - com.mysql.lists.dotnet

4 messages in com.mysql.lists.dotnetRe: Stored Procedure in ASP.NET with ...

From	Sent On	Attachments
Jesse	04 Jul 2006 05:26
DG...@ NEFACOMP	04 Jul 2006 05:54
Jesse	04 Jul 2006 05:54
Jesse	04 Jul 2006 06:02

Subject:	Re: Stored Procedure in ASP.NET with MySQLConnector
From:	Jesse (jl...@msdlg.com)
Date:	07/04/2006 06:02:16 AM
List:	com.mysql.lists.dotnet

Use Cmd.Parameters.Add("?ChapterID",nChapterID) (Note the question mark <<?>> before the parameter name.)

Yes, while browsing for a fix, I recently found this. In addition to this, the parameter name in the SP is actually "nChapterID", so I changed this code to read, "Cmd.Parameters.Add("?nChapterID",nChapterID)" However, I'm still getting the same error. I've done the same with the "Invno" parameter: "Cmd.Parameters.Add("?cInvNo",MySQLDBType.VarChar)". This hasn't made any difference either. This is getting very frustrating.