I have a MySql database, containing a table with two columns: day is a DATE
column, amount is DECIMAL(4,2).
I have the following stored procedure:
CREATE [EMAIL PROTECTED] PROCEDURE `insertdata`(IN p_day DATE, IN
p_amount DECIMAL(4,2))
BEGIN
INSERT INTO table1 (day, amount) VALUES (p_day, p_amount);
END
If I call this procedure from the MySql console, everything works. The
values are inserted into the table.
When I call this procedure from the following C# code, I get an "Unknown
column 'p_day' in 'field list'" error:
string connStr = "Server=localhost;Database=test;Uid=test;Pwd=*****;use
procedure bodies=false;";
MySqlConnection conn = new MySqlConnection(connStr);
conn.Open();
MySqlCommand dCmd = new MySqlCommand("verlof_toevoegen", conn);
dCmd.CommandType = CommandType.StoredProcedure;
dCmd.Parameters.AddWithValue("p_day", string.Format("'{0:yyyy-MM-dd}'",
DateTime.Now));
dCmd.Parameters.AddWithValue("p_amount", 9);
dCmd.ExecuteNonQuery();
I tried changing the parameter name, used a name without an underscore,
nothing helps.
What is causing the error?
--
View this message in context:
http://www.nabble.com/Unknown-column-error-when-calling-MySql-stored-procedure-from-Mono-C--tp19347812p19347812.html
Sent from the Mono - General mailing list archive at Nabble.com.
_______________________________________________
Mono-list maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list
