Output parameter problem....
Posted: Tue 18 Jan 2005 15:23
I'm having trouble with output parameters when using mysqldirect.net in Visual Studio with VB and ASP.NET.
Here is the problem:
First of all, for some reason if you look at the property building for a mysqlcommand and look at the parameters tab. It will no longer allow you to select what direction you want the parameter to be. Which is fine because I have just been setting it programmatically. (If some one could tell me why its doing this...it would be appreciated.
The real problem is that I can never get output parameters to work correctly. When ever I make a new output parameter and set its direction and source column and then run the query. It always tells me that the parameter is missing from the commandtext. So, is there something that I am supposed to put in the command text? Please advise. Thanks!
Here is the problem:
First of all, for some reason if you look at the property building for a mysqlcommand and look at the parameters tab. It will no longer allow you to select what direction you want the parameter to be. Which is fine because I have just been setting it programmatically. (If some one could tell me why its doing this...it would be appreciated.
The real problem is that I can never get output parameters to work correctly. When ever I make a new output parameter and set its direction and source column and then run the query. It always tells me that the parameter is missing from the commandtext. So, is there something that I am supposed to put in the command text? Please advise. Thanks!