This fixes my problem. Thanks!. Now to figure out where I got the ampersand
from I thought it was in an example.
On 12/2/05, Jesse Castleberry <[EMAIL PROTECTED]> wrote:
>
> Have you tried using "?" instead of "&"? I'm very new to both MySQL and
> Stored Procedures, but I've got seversl stored procedures working right
> now,
> and I had to put a question mark in front of the parameters before it
> would
> work:
>
> myCmd.Parameters.Add(New MySql.Data.MySqlClient.MySqlParameter("?tbl",
> "escdofficer"))
> myCmd.Parameters("?tbl").Direction = ParameterDirection.Input
>
> Jesse
>
> ----- Original Message -----
> From: "Rehcra" <[EMAIL PROTECTED]>
> To: <mysql@lists.mysql.com>
> Sent: Friday, December 02, 2005 2:28 PM
> Subject: DOT.NET Connector and Stored Procedures: Exception trying to
> retrieve parameter info
>
>
> I'm having a problem getting parameters working.
>
> Mysql 5.0.16
> mysql-connector-net-1.0.7
> VB.NET 1.1
>
> mysql> SHOW CREATE PROCEDURE tbl_slct \G
> *************************** 1. row ***************************
> Procedure: tbl_slct
> sql_mode:
> Create Procedure: CREATE PROCEDURE `tbl_slct`(IN tbl CHAR(64))
> READS SQL DATA
> BEGIN
> SET @s = CONCAT('SELECT * FROM ' , tbl);
> PREPARE stmt FROM @s;
> EXECUTE stmt;
> END
> 1 row in set (0.00 sec)
>
> Public Function Test() As DataTable
> If myConn.State <> ConnectionState.Open Then
> myConn.ConnectionString = myConnString
> myConn.Open()
> End If
>
> Test = New DataTable
>
> Dim myCmd As New MySql.Data.MySqlClient.MySqlCommand("tbl_slct", myConn)
> myCmd.CommandType = CommandType.StoredProcedure
>
> myCmd.Parameters.Clear()
> myCmd.Parameters.Add(New MySql.Data.MySqlClient.MySqlParameter("&tbl",
> "escdofficer"))
> myCmd.Parameters("&tbl").Direction = ParameterDirection.Input
>
> Dim myAdapter As New MySqlDataAdapter(myCmd)
> myAdapter.Fill(Test) '*** raises MySqlException
> End Function
>
> "Exception trying to retrieve parameter info for tbl_slct: Parameter 'tbl'
> is not defined"
>
> What am I missing?
>
> Thanks,
> Steve
>
>
--
Rehcra
