Ok... I am past the previous errors but now I have something new. The error states that either BOF or EOF is true. Requested operation requires a current record.

Some food for thought. StartTime in my table is in the form 04/25/2004 09:15:00 AM

Neil

>>>
>>>

>>>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
>
>It'd be an error if it didn't give the error :) Sorry my ignorance :
>
>

>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()
>oConnection.Close
>release oConnection			
>

Cetin