.NET Connector Output Values

2005-12-04 Thread Colin Shreffler
I have the following code: ... query = "INSERT INTO a_test_table (a_test_table_id,name,last_mod_date,create_date) VALUES (?a_test_table_id,?name,?last_mod_date,?create_date)"; ... command.Prepare(); ... command.Parameters.Add("?a_test_table_id", MySqlDbType.Int32); command.Parameters["?a_test_

Executing multiple queries at a time in Query Browser

2005-11-26 Thread Colin Shreffler
Does anyone know how to separate queries so that I can run multiple insert statements at once? For example, from within MySQL Query Browser, I want to load a file containing multiple inserts and then run it. It errors however on trying to run the following queries: insert into project_type (proj

calling procedures from the .NET provider

2005-11-22 Thread Colin Shreffler
I've seen a few posts out there regarding this subject, but no solutions that I could understand. I am unable to execute a stored procedure from the MySql data provider. I get a message that says: '42000 SELECT command denied to user' etc. Can anyone tell me what I need to do to enable my p

User Accounts

2005-10-22 Thread Colin Shreffler
After installing MySQL on OS X, there don¹t appear to be any user accounts created by default. Does anyone know what user account to use or if there is a convention that I should use when creating an ŒAdmin¹ account? Cheers -c