"Function Does Not Exist"

I'm using the following code in my 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.Directio

Access to Stored Procedure Solved

I figured out a problem I was having, and just wanted to pass the solution along to anyone who may run into the same problem in the future. I've got a new problem now, but I'll deal with that in a separate message (if necessary). I was getting the error, "#42000SELECT command denied to user [EMAI

How to list priviledges

Is there a way to list the privilidges that a user has in MySQL? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

How to list priviledges

Is there a way to list the privilidges that a user has in MySQL? Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Command Denied on Stored Procedure

I'm trying to execute a MySQL Stored Procedure from my ASP.NET page: Cmd=New MySqlCommand("sp_InsertNewCamper",Conn) Cmd.CommandType = CommandType.StoredProcedure paramReqID = Cmd.Parameters.Add("return",SqlDbType.Int) paramReqID.Direction = ParameterDirection.ReturnValue Cmd.Parame

Format for saving date field.

When doing an update or insert into a database with a date field, the format for the data on the screen is m/d/. However, I believe that MySQL is expecting it in the format of -mm-dd. I'm using MySQL in an ASP.Net application. Is there an EASY way to convert to the data to a format that

MySQL .NET Connector

I'm using the MySQL .Net connector to access my MySQL database from my ASP.Net application. I've got kind of a catch 22 thing going on here. I'm getting an error, which indicates that I need to set the debug="true" in my web.config file (I realize this isn't a MySQL problem, but bare with me...).

Does BLOB=Memo?

I'm a bit new to MySQL. I need to create a Memo field (a field that could contain a lot of information). I know that in some languages, BLOB is a Memo field. Is that the case with MySQL? If so, are there some parameters that I need to use here, or should I use another type to represent my Memo

rename database

How can I rename a database in MySQL 5? I've tried renaming he folder, and that just causes other problems. Some one sent me a stored procedure to try, but it will not execute. There are probably several places that need to be changed, but I don't know where those are. Could someone point me in

Stored Procedure Question

I've got a stored procedure I'm trying to convert from MS SQL. I've gotton so far with it, but it's complaining about the INSERT command. It's a very simple stored procedure, so it should easy to figure out, but I'm not familiar with the MySQL Stored Procedure syntax. If someone can point out wha

SQL Statement Conversion

I'm converting an application from SQL Server to MySQL. I have the following query that I need to convert: SELECT A.*, CO = CASE CounselorOnly WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END FROM Activities a ORDER BY Activity What is the proper syntax for this in MySQL? Thanks, Jesse -- MySQL Genera

Stored Procedure Conversion

I am converting a MS SQL Server ASP application over to use MySQL. I have two simple stored procedures that I need to convert. I have very little experience with MS SQL stored procedures, and none-what-so-ever with stored procedures in MySQL, so I really don't know what this should look like. I'll

How to rename a database

I need to rename a database. I read somewhere that I could simply stop the MySQL database server and rename the folder that contains the data, re-start MySQL, and I'm good-to-go. However, I tried this, and while it appears to have worked initially, when I try to access one of the tables in the da