From: Struan Bartlett Date: March 18 1999 11:20am Subject: Access <-> MyODBC <-> MySQL problem List-Archive: http://lists.mysql.com/mysql/478 Message-Id: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Hi. I've an Access 97 database with MySQL (3.22.16a-gamma-log) tables linked via MyODBC 2.50.22. I've designed an Access Query such that the Access 'SQL View' says: SELECT RawM.Name, * FROM RawM WHERE (((RawM.Name) Like 'MYINFOBOX%')); However, the appropriate excerpt from the MyODBC log file says: MSACCESS de:aa ENTER SQLExecDirect HSTMT 0x008b24f0 UCHAR * 0x086513d4 [ -3] "SELECT RawM.ID FROM RawM WHERE (Name = 'MYINFOBOX%' ) " SDWORD -3 MSACCESS de:aa EXIT SQLExecDirect with return code 0 (SQL_SUCCESS) HSTMT 0x008b24f0 UCHAR * 0x086513d4 [ -3] "SELECT RawM.ID FROM RawM WHERE (Name = 'MYINFOBOX%' ) " SDWORD -3 MSACCESS de:aa ENTER SQLFetch HSTMT 0x008b24f0 MSACCESS de:aa EXIT SQLFetch with return code 100 (SQL_NO_DATA_FOUND) HSTMT 0x008b24f0 And here's the appropriate except from the MySQL log: 990318 11:01:52 2126 Connect struanb@stripped on newsnow 2126 Query SELECT Config, nValue FROM MSysConf 2126 Query SELECT RawM.ID FROM RawM WHERE (Name = 'MYINFOBOX%' ) 990318 11:02:35 2126 Query SELECT RawM.ID FROM RawM WHERE (Name = 'MYINFOBOX%' ) Umm?! Can anyone tell me how/why the SQL "Like" (in the original SQL statement) been changed to an "="? And by what? Or should I post this query to the MyODBC list? Thanks in advance. Kind regards, Struan Bartlett. ------------------------------------------------------------------ Struan Bartlett | The Premier UK News Aggregation Web site Managing Director | http://www.newsnow.co.uk/ NewsNow Publishing Ltd | Your remote control for news on the Net | Tel. : 0171 720 2727 | "The only straight lines found Mobile: 0958 686494 | in nature are those drawn by us" ------------------------------------------------------------------