sqlString = "SELECT TOP 100 PERCENT dbo.codept.deptdesc, dbo.corooms.roomname, " & _ "dbo.meetings.begintime, dbo.meetproc.description, dbo.coper.lastname, dbo.coper.firstname, dbo." & _ "codept.deptid, dbo.corooms.roomid, dbo.meetings.meetingnumber FROM dbo.meetings " & _ "INNER JOIN dbo.patients ON dbo.meetings.patientid = dbo.patients.patientid INNER" & _ " JOIN dbo.meetproc ON dbo.meetings.meetingnumber = dbo.meetproc.meetingnumber IN" & _ "NER JOIN dbo.corooms ON dbo.meetings.roomid = dbo.corooms.roomid INNER JOIN dbo." & _ "codept ON dbo.meetings.deptid = dbo.codept.deptid LEFT OUTER JOIN dbo.coper ON d" & _ "bo.meetproc.coperid = dbo.coper.coperid WHERE (dbo.meetings.iscancelled = 0) AND" & _ " (dbo.meetings.isblock = 0) AND (dbo.meetings.roomclosed = 0) AND " & _ "(dbo.meetproc.coperid = 1)" OleDbSelectCommand1.CommandText = sqlStringI am trying to change the last line to:
"(dbo.meetproc.coperid = " & docID & ")"docID is a publicly defined variable as a String and has the correct value (I'm displaying it on the page when the page loads)