List:MySQL on Win32« Previous MessageNext Message »
From:Reggie Burnett Date:June 23 2005 1:46pm
Subject:RE: MySQL Parameter with MySQL .NET connector
View as plain text  
Early versions of the connector used @ but we switched to the ? Symbol since
@varname is special to MySQL.  If you have a lot of code that uses @, you
can add oldsyntax=yes to your connection string and still use the @ syntax. 

> -----Original Message-----
> From: Greg Quinn [mailto:greg@stripped] 
> Sent: Thursday, June 23, 2005 6:11 AM
> To: win32@stripped
> Subject: Re: MySQL Parameter with MySQL .NET connector
> 
> Don't worry, I eventually found one uses a ? instead of a @
> 
> ----- Original Message -----
> From: "Greg Quinn" <greg@stripped>
> To: <win32@stripped>
> Sent: Thursday, June 23, 2005 12:53 PM
> Subject: MySQL Parameter with MySQL .NET connector
> 
> 
> > Why is no value being inserted into my table when using the MySQL 
> > Parameter?
> >
> > sql = "insert into roles (rolename) ";
> > sql += "VALUES (@rolename)";
> >
> > MySqlCommand objCommand = new MySqlCommand(sql, objConnection);
> > objCommand.Parameters.Add(new MySqlParameter("@rolename", txtName));
> >
> > ???
> >
> > The value txtName I have checked and defniately has a value???
> >
> > -- 
> > MySQL Windows Mailing List
> > For list archives: http://lists.mysql.com/win32
> > To unsubscribe:    
> http://lists.mysql.com/win32?unsub=1
> > 
> 
> 
> -- 
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe:    http://lists.mysql.com/win32?unsub=1
> 
> 

Thread
compiled mysql with openssl support under win98sehormuzd irani23 Jun
  • MySQL Parameter with MySQL .NET connectorGreg Quinn23 Jun
  • Re: MySQL Parameter with MySQL .NET connectorGreg Quinn23 Jun
    • RE: MySQL Parameter with MySQL .NET connectorReggie Burnett23 Jun