List:MySQL and .NET« Previous MessageNext Message »
From:Pyt Date:November 20 2005 9:55am
Subject:Re: "Function Does Not Exist"
View as plain text  
Does it work if you use a standard command type, and use "call
sp_InserNewCamper();" as the command string ?
 Pyt.

 On 11/18/05, Jesse Castleberry -
JesseC@stripped<+mysql+pyt+c1ac2e3ccd.JesseC#msdlg.com@
spamgourmet.com <http://spamgourmet.com>> wrote:
>
> I'm using the following code in my ASP.NET <http://ASP.NET> application to
> add a new record
> to the database, and return the added ID:
>
> Cmd=New MySqlCommand("sp_InsertNewCamper",Conn)
> Cmd.CommandType = CommandType.StoredProcedure
> paramReqID = Cmd.Parameters.Add("return",SqlDbType.Int)
> paramReqID.Direction = ParameterDirection.ReturnValue
> Cmd.Parameters.Add("FirstName",FirstName.Text)
> Cmd.Parameters.Add("LastName",LastName.Text)
> Cmd.Parameters.Add("UserName",UserName.Text)
> Cmd.Parameters.Add("Password",Password.Text)
>
> Cmd.ExecuteNonQuery()
> cID = CStr(Cmd.Parameters("return").Value)
>
> When I execute this code, I get the error, "#42000FUNCTION
> fccamp.sp_InsertNewCamper does not exist". However, it DOES exist. I can
> see it. It's named exactly the same, there are no misspellings or
> anything.
> One other difference is that this is calling it a "function" where it is
> actually a procedure. I could make this a function, I guess, however, I
> don't know how to write the code in ASP.NET <http://ASP.NET> to grab the
> return value.
>
> I've checked Google, and found very little on this error, and don't even
> know what to look for in the manual. Does anyone know what might be going
> on
> here?
>
> Thanks,
> Jesse
>
>
> --
> MySQL on .NET Mailing List
> For list archives: http://lists.mysql.com/dotnet
> To unsubscribe:
> http://lists.mysql.com/dotnet?unsub=1
>
>

Thread