| List: | MySQL and .NET | « Previous MessageNext Message » | |
| From: | Peter de Bruine | Date: | August 23 2007 8:53am |
| Subject: | Parameters with ? Not working in MySQL Connector Net 1.0.9 while with @ are working | ||
| View as plain text | |||
Hi all,
We have developed an application which uses the MySQL Connector Net to get
data from the database. Recently i upgraded to MySQL Connector Net 1.0.9 and
found that the application wasn't working anymore. We got error saying
"Parameter '?parametername' must be defined". Here a example:
MySqlCommand cmd = new MySqlCommand("SELECT something FROM sometable WHERE
id=?someid", conn);
cmd.Parameters.Add("someid", MySqlDbType.Int32).Value = someobject.Id;
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet("sometable");
da.Fill(ds, 0, 0, "sometable");
This code worked fine until 1.0.9. When we change the ? to @ the code works
again. Can anyone explain why this is?
Kind regards
Peter de Bruine
p.debruine@stripped
| Thread | ||
|---|---|---|
| • Parameters with ? Not working in MySQL Connector Net 1.0.9 while with @ are working | Peter de Bruine | 23 Aug |
| • Re: Parameters with ? Not working in MySQL Connector Net 1.0.9 whilewith @ are working | DG @ NEFACOMP | 23 Aug |
| • RE: Parameters with ? Not working in MySQL Connector Net 1.0.9 while with @ are working | Peter de Bruine | 23 Aug |
| • Re: Parameters with ? Not working in MySQL Connector Net 1.0.9while with @ are working | David Anderson | 23 Aug |
| • RE: Parameters with ? Not working in MySQL Connector Net 1.0.9 while with @ are working | Peter de Bruine | 23 Aug |
| • Re: Parameters with ? Not working in MySQL Connector Net 1.0.9 whilewith @ are working | Reggie Burnett | 23 Aug |
