>>xStartTime = CTOT("04/25/04 07:00:00") >>xEndTime = CTOT("04/25/04 17:00:00") >>SELECT * from meetings WHERE BETWEEN(starttime,xStartTime,xEndTime) >>>>
>>oConnection = CREATEOBJECT("adodb.connection") >>oConnection.ConnectionString="Provider=VFPOLEDB.1;data source=C:\Inetpub\wwwroot\2004_gmg\data\Appointments.dbc" >>Connection.Open() >>oConnection.Errors.Clear() >>>>
>>mySQL = "SELECT * from meetings WHERE BETWEEN" + "(" + "StartTime" +; > ", " + TRANSFORM(xStartTime) + ", " + TRANSFORM(xEndTime) + ")" >>rs=oConnection.Execute(mySQL) >>? rs.GetString() >>RELEASE oConnection >>>>
>xStartTime = "^2004/04/25 07:00" >xEndTime = "^2004/04/25 17:00" >mySQL = "SELECT * from meetings WHERE StartTime BETWEEN "+; > "ctot(xStartTime) and ctot(xEndTime)" >rs=oConnection.Execute(mySQL) >? rs.GetString() >RELEASE oConnection >Cetin