------=_Part_10518_444952855.1196645258577
Content-Type: text/plain; charset=gbk
Content-Transfer-Encoding: quoted-printable

hi,guys:
Now i am in this situation:I want to use the cause "like",i wrote:
string commd =3D "select * from buyerinfo where BuyerName like '%?blurName%=
'";
MySqlParameter para =3D new MySqlParameter("?blurName", MySqlDbType.VarChar=
, 45, "BuyerName");
para.Value =3D blurName;
It didn't work.
I changed that like this:
string commd =3D "select * from buyerinfo where BuyerName like '%"+"?blurNa=
me"+"%'";
MySqlParameter para =3D new MySqlParameter("?blurName", MySqlDbType.VarChar=
, 45, "BuyerName");
para.Value =3D blurName;
or:
blurName=3D"'%"+"blurName"+"%'";
string commd =3D "select * from buyerinfo where BuyerName like ?blurName";
MySqlParameter para =3D new MySqlParameter("?blurName", MySqlDbType.VarChar=
, 45, "BuyerName");
para.Value =3D blurName;
It also didn't work, when executed ,It returned nothing ,which definitely w=
rong.
Any advise would be appreciated,thx!
--
Best regards=A3=A1
haitao
------=_Part_10518_444952855.1196645258577--

Haitao -
I would recommend trying something like this:

"select * from buyerinfo where BuyerName like concat('%', ?blurName, '%')"

Placing "?blurName" in the middle of a string literal will prevent the
parameter replacement from happening. A good way to debug a problem like
this is to enable query logging on the server and check what is actually
sent.

Jess

On Mon, Dec 03, 2007 at 09:27:38AM +0800, longhaitao wrote:
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=...ie.nctu.edu.tw