From: lams_yi <la...@ho...> - 2004-02-18 09:37:50
|
Thank you for your quick reply, Carlos. But I test the sqlCommand, it looks like it don't have this problem. Here is the code: string conString ="server=(local);Integrated Security=true;database=Northwind"; string sql = "update employees set PhotoPath = 'ta...@ho...' where EmployeeId = 9"; //memSQL.Text; SqlConnection con = new SqlConnection(conString); SqlCommand cmd = new SqlCommand(); cmd.Connection = con; cmd.CommandText = sql; con.Open(); cmd.ExecuteNonQuery(); con.Close(); The Employees.PhotoPath can update to 'ta...@ho...' correctly. Because I am using Object-Mapping class to map my object to create the query on runtime. So parameterized query is not a good solution for me :-( > ----- Original Message ----- > From: "Carlos Guzmán Álvarez" <car...@te...> > To: "tao lin" <la...@ho...> > Cc: <fir...@li...> > Sent: Wednesday, February 18, 2004 12:02 PM > Subject: Re: [Firebird-net-provider] Does Fb .net provider support IB open > source 6.0.20? > > > > Hello: > > > > > Do I miss something or FbCommand can not handle well with the '@' > > > <mailto:'@'>? > > > > This is a problem with the named paraters support, you can solve it > > using parametrized querys. > > > > > > > > > > -- > > Best regards > > > > Carlos Guzmán Álvarez > > Vigo-Spain > > > > > > ------------------------------------------------------- > > SF.Net is sponsored by: Speed Start Your Linux Apps Now. > > Build and deploy apps & Web services for Linux with > > a free DVD software kit from IBM. Click Now! > > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click > > _______________________________________________ > > Firebird-net-provider mailing list > > Fir...@li... > > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > > > |