At 8:54 +0800 5/7/03, Stikirana Yuana wrote:
>i dontt know what happens.... but when i change the query's character with
>lowercase the query run just fine....
>is this bug???
Does your server host have case-sensitive file and directory names?
>----- Original Message -----
>From: "Stikirana Yuana" <stikirana@stripped>
>Sent: Wednesday, May 07, 2003 8:27 AM
>Subject: SELECT problem
>> hi all...
>> i'm trying to migrate my app from db2 to mysql.... but i have a problem
>> because in my app there are much select queries that use format :
>> example :
>> SELECT USERID.TBL_USER.KD_USER
>> FROM USERID.TBL_USER
>> WHERE USERID.TBL_USER.KD_USER='007';
>> this query just error when i use in my app that use MyODBC to access
>> but when i'm try the same query in mysql client it just work fine...no
>> does anyone know how/what should i do to make this query work in odbc....?
> > thanks