Re: Cannot find uppercase user from mysql.user table

2003-06-04 Thread Paul DuBois
At 18:30 -0500 6/2/03, Michael Franch wrote: To whom it may concern, I am using MySql v.4.0.13 and am trying to query the user table from Visual Basic using ADO. If the user has an entry, that is uppercase lowercase, e.g. Jim, and my query is:select user from mysql.user where user ='Jim' the

Cannot find uppercase user from mysql.user table

2003-06-03 Thread Michael Franch
To whom it may concern, I am using MySql v.4.0.13 and am trying to query the user table from Visual Basic using ADO. If the user has an entry, that is uppercase lowercase, e.g. Jim, and my query is:select user from mysql.user where user ='Jim' the recordset returned is empty. But, if

Re: Cannot find uppercase user from mysql.user table

2003-06-03 Thread Joel Rees
I am using MySql v.4.0.13 and am trying to query the user table from Visual Basic using ADO. If the user has an entry, that is uppercase lowercase, e.g. Jim, and my query is:select user from mysql.user where user ='Jim' the recordset returned is empty. But, if the entry in the user field is