[Mono-list] help with MySqlParameter
Reggie Burnett
rykr@comcast.net
Mon, 15 Nov 2004 15:01:58 -0600
It didn't get broken. It got replaced by the ? syntax. You can use the old
@ syntax by specifying oldsyntax=yes on your connection string.
-----Original Message-----
From: mono-list-admin@lists.ximian.com
[mailto:mono-list-admin@lists.ximian.com] On Behalf Of
Rob.Tillie@Student.tUL.EDU
Sent: Monday, November 15, 2004 1:45 PM
To: petervyvey@village.uunet.be; mono-list@lists.ximian.com
Subject: RE: [Mono-list] help with MySqlParameter
Yes,
The @ char used to work, but got broken in a recent build.
(It used to work for me in the old bytefx drivers)
Greetz,
-- Rob.
> -----Original Message-----
> From: Peter [mailto:petervyvey@village.uunet.be]
> Sent: Monday, November 15, 2004 6:53 PM
> To: mono-list
> Subject: Re: [Mono-list] help with MySqlParameter
>
> Sergio,
>
> Try using '?user' for you parametername.
>
> You could try the following:
>
> string connstr = "... valid connection string here ...";
> MySqlParameter name = new MySqlParameter("?user",MySqlDbType.VarChar);
> name.Value="admin";
> DataRow usr = MySqlHelper.ExecuteDataRow(connstr, "SELECT * FROM usr WHERE
> username=?user", name);
>
> Peter
>
> _______________________________________________
> Mono-list maillist - Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
_______________________________________________
Mono-list maillist - Mono-list@lists.ximian.com
http://lists.ximian.com/mailman/listinfo/mono-list