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 workingPeter de Bruine23 Aug
  • Re: Parameters with ? Not working in MySQL Connector Net 1.0.9 whilewith @ are workingDG @ NEFACOMP23 Aug
    • RE: Parameters with ? Not working in MySQL Connector Net 1.0.9 while with @ are workingPeter de Bruine23 Aug
      • Re: Parameters with ? Not working in MySQL Connector Net 1.0.9while with @ are workingDavid Anderson23 Aug
        • RE: Parameters with ? Not working in MySQL Connector Net 1.0.9 while with @ are workingPeter de Bruine23 Aug
          • Re: Parameters with ? Not working in MySQL Connector Net 1.0.9 whilewith @ are workingReggie Burnett23 Aug