I am using a FullTextSqlQuery to grab some data from a SharePoint instance. Initially I had a fairly simple where clause in which I filtered the results by the content type and everything worked fine.
I then tried to add some date filtering which added a condition like:
AND mypublishstartdate <= '11/9/2011'
to the end. Unfortunately I am now getting the error:
Error HRESULT E_FAIL has been returned from a call to a COM component.
Exception Details: System.ServiceModel.FaultException`1[[System.ServiceModel.ExceptionDetail, System.ServiceModel, Version=126.96.36.199, Culture=neutral, PublicKeyToken=b77a5c561934e089]]: Error HRESULT E_FAIL has been returned from a call to a COM component.
Does anyone know what I am doing wrong here?