myODBC command syntax for SELECT statement...

[Chris R.]

I'm trying to do what I thought was a fairly simple thing, select a group of
records from a mySQL database.
I'm not much of an SQL guy. The syntax I would use for Microsoft SQL is
shown on the "query =" line.
A myODBC error message indicates this is not supported syntax.
Can anyone help me?

{ ADO Startup Values and Creation using the .Open method}

{Create a COM object reference to ADO Recordset.}
recordset = COM_CreateObjec t("ADODB.Record set");

{ Open a Recordset }
query = "SELECT * FROM t_course_date
WHERE(modified> =CONVERT(DATETI ME,'1999-07-31 00:00:00',102)) ";
("modified" field above is a mySQL field name)

recordset.Open( query, 'connection id', adOpenDynamic,a dLockOptimistic ); <--
This statement fails...

Thanks
Chris R.