Hello! I am using the Database Connector (PHP) to connect to a SQL database. I can pull records from the database just fine, but whenever I try to filter the results I receive this:

SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'OUTPUT'.

It doesn't seem to matter what column I am filtering, or what filter type or value I use. Anyone have any ideas?

Thanks so much!

EDIT: After playing around some more, I've found that I can SORT just fine based on any column, but applying any sort of filter at all breaks my query. :-(

Hello,

Could you please provide a little more detailed information about what filter are you using and how are you applying it. Also - what is your server type/php version/database type?

Thanks for your response!

I am running Apache on Windows Server 2012. I am connected to a Microsoft SQL database using PHP 5.4.27.

Here is a screen capture of a very basic filter that is causing the error to occur:



It doesn't matter what sort of filter I apply -- as soon as I enter one, my database queries break:

I have rebuilt my database connections from scratch -- and then rebuilt my site -- and am having the exact same issue when I attempt to filter my database results. Any idea what might be causing the problem? Many thanks!