[Mono-list] help with MySqlParameter

Rob.Tillie@Student.tUL.EDU Rob.Tillie@Student.tUL.EDU
Mon, 15 Nov 2004 22:06:38 +0100


Ah, I didn't know that :).
Sorry for the accusation, my apologies.

Greetz,
-- Rob.

> -----Original Message-----
> From: Reggie Burnett [mailto:rykr@comcast.net]
> Sent: Monday, November 15, 2004 10:02 PM
> To: petervyvey@village.uunet.be; mono-list@lists.ximian.com
> Subject: RE: [Mono-list] help with MySqlParameter
> 
> 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
> 
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list