Using mySQL and ADO

[<silrom68]

Hi list 

I need execute a statement  like 
"SELECT date1, ( TO_DAYS( date1 ) - TO_DAYS( now()) ) AS priority  FROM table1 ORDER BY
priority DESC"

If I execute it directly (for ex. in Mascon gui) the result is OK
but when i try to execute the same sql in an ADODB.Recordset ( with Open method) the
result is alaways 
an empty recordset, but without error messages.

The same thing always happens everytime I try to use a "select_expression" that is more
than a simple 
field name of the table, but if I don't use ADO  the same statements works correct!!!
I'm developing some ASP pages, so I can't leave ADO (now)

Please, there's anyone who knows why it happens ?
All help would be very appreciated

Ciao a tutti 
Silvio

(It's a Win2K, mySQL 3.23.39, ADO ver. 2.6)