I need execute a statement like
"SELECT date1, ( TO_DAYS( date1 ) - TO_DAYS( now()) ) AS priority FROM table1 ORDER BY
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
(It's a Win2K, mySQL 3.23.39, ADO ver. 2.6)
|• Using mySQL and ADO||silrom68||13 Jul|