Hi Guys,I am using this query:



Dim rsProjectManager

Set rsProjectManager = server.createobject ("ADODB.recordset")

SQLProjectManage = "select *" _

				&"FROM tblProject,tblBAFContact" _

				&"WHERE projectManagerID = BAFContactID" _

				&"AND BAFContactID = " &

request.Cookies("LoginID")

				  rsProjectManager.Open

SQLProjectManage,cn,1



and I am getting this error:



Microsoft OLE DB Provider for SQL Server error '80040e14' 



Line 1: Incorrect syntax near '='. 



? 

I am very frustrated (It is not doing anything complex even...)



Any suggestions etc



Thanks



Sam