List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 7 2003 2:33am
Subject:Re: SELECT problem
View as plain text  
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>
>To: <mysql@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 :
>>  databasename.tablename.columnname....
>>  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
>>  data.....
>>  but when i'm try the same query in mysql client it just work fine...no
>error
>>  happen.....
>>
>>  does anyone know how/what should i do to make this query work in odbc....?
>>
>  > thanks


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
SELECT problemStikirana Yuana7 May
  • removing duplicate rowsBruce Douglas7 May
  • Selecting long string with non alpha'sScott Haneda7 May
    • Re: Selecting long string with non alpha'sPaul DuBois7 May
      • Re: Selecting long string with non alpha'sScott Haneda7 May
  • Re: SELECT problemStikirana Yuana7 May
    • Re: SELECT problemPaul DuBois7 May
Re: removing duplicate rowsJames Moe7 May