>>Can someone help me with a problem I am having with an adodb sql statement?
>>The following lines work fine in the vfp command window:
>>
>>

>>xStartTime = CTOT("04/25/04 07:00:00")
>>xEndTime = CTOT("04/25/04 17:00:00")
>>SELECT * from meetings WHERE BETWEEN(starttime,xStartTime,xEndTime)
>>

>>
>>the SELECT statement returns all of the records whose StartTimes are between xStartTime and xEndTime.
>>
>>But when I attempt to use the statement in the context of adodb I hit the wall.
>>For example:
>>
>>

>>oConnection = CREATEOBJECT("adodb.connection")
>>oConnection.ConnectionString="Provider=VFPOLEDB.1;data source=C:\Inetpub\wwwroot\2004_gmg\data\Appointments.dbc"
>>Connection.Open()
>>oConnection.Errors.Clear()
>>

>>
>>No matter how I build mySQL I seem to get it wrong:
>>

>>mySQL =  "SELECT * from meetings WHERE BETWEEN" + "(" + "StartTime" +;
> ", "  +  TRANSFORM(xStartTime) + ", " + TRANSFORM(xEndTime) + ")"
>>rs=oConnection.Execute(mySQL)
>>? rs.GetString()										
>>RELEASE oConnection
>>

>>
>>This generates an error stating that a function is missing a “)”. But nothing I attempt works.
>>
>>Please assist me in the proper syntax of mySQL to pass into oConnection.Execute.
>>Thank you
>>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