psappenfield
Programmer
Hello,
I am having a problem with an SQL query string.
I have run it through SQL Query Analyzer, and there were no errors.
I am running the query on a SQL Server 7 database, and I had to make a name change on the table.
Does anyone know how to fix this?
Thanks in advance...
I am having a problem with an SQL query string.
Code:
strQry="select top 1 AvailableDayOfWeek from myMeetingAvailableTimeSlots WHERE ManagerName='sbaker'"
objRS.Open strQry,objConn,adOpenStatic,adLockOptimistic,adCmdTable
I have run it through SQL Query Analyzer, and there were no errors.
I am running the query on a SQL Server 7 database, and I had to make a name change on the table.
Does anyone know how to fix this?
Thanks in advance...