Alias & WHERE

2002-05-29 Thread Massimo Colurcio
e WHERE field1 = 'abc' ORDER BY ABC Why I cannot use the alias 'ABC' in WHERE clause and I can use it in ORDER BY clause? I'm using mySQL 3.23.47 on W98 with ODBC (myODBC 3.51.02). TIA, Massimo. _______ Massimo Colurcio mailto:

Alias & WHERE

2002-05-28 Thread Massimo Colurcio
RE field1 = 'abc' ORDER BY ABC Why I cannot use the alias 'ABC' in WHERE clause and I can use it in ORDER BY clause? I'm using mySQL 3.23.46 on W98 with ODBC (myODBC 3.51.02). TIA, Massimo. _______ Massimo Colurcio mailto:[EMAI

Slow query

2002-03-15 Thread Massimo Colurcio
Hi all. I'm using MySQL server 3.23.47 (client 3.23.44) on Windows 98 (...sorry) accessing to database via ODBC (MySQL ODBC release 3.5.01.01) and VC++6.0 & MFC (CRecordset). I have noticed that queries are really slow... with a simple SELECT like this: SELECT ID_Field, Text_Field, Date_Fie

GetDefaultConnect

2002-02-18 Thread Massimo Colurcio
ssdb;PWD=;PORT=;OPTION=0;STMT=; Is there something wrong in the driver? Am I doing something wrong? TIA, Massimo. _______ Massimo Colurcio mailto:[EMAIL PROTECTED] http://www.softhor.com/developmentarea ICQ #9

GetDefaultConnect

2002-02-18 Thread Massimo Colurcio
ssdb;PWD=;PORT=;OPTION=0;STMT=; Is there something wrong in the driver? Am I doing something wrong? TIA, Massimo. _______ Massimo Colurcio mailto:[EMAIL PROTECTED] http://www.softhor.com/developmentarea ICQ #9