SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '>'. [#1185114]

This error is returned when attempting to create a View to query event nodes that have a date later than today. I set the filter for the date field to be greater than "now" as Date default. Once I save the change, the error occurs.

Thank you in advance for your help.

Comment	File	Size	Author
#1	screenshot.png	19.39 KB	jgiboney
	Error message.png	21.1 KB	rschuetzler
	Filter configuration.png	35.45 KB	rschuetzler

Comments

Comment #1

jgiboney commented 16 June 2011 at 16:57

Issue tags:

+date filter

Status	File	Size
new	screenshot.png	19.39 KB

As I am working on the same issue, I have noticed that the column names are not included in the query when using >, >=, <, or <= (see screen shot). If I use is empty or is not empty, the column names are included in the query.

Comment #2

damien tournoud commented 17 June 2011 at 07:40

That looks like a Views bug.

Comment #3

cosmicdreams commented 16 November 2011 at 18:46

I ran into this issue running a minimal drupal installation on MS SQL Server 2008 R2 + Apache. The error I received was slightly different. It was:

PDOException: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near ')'.: SELECT TOP(1) * FROM {menu_router} WHERE path IN () ORDER BY fit DESC; Array ( ) in menu_get_item() (line 450 of C:\xampp\htdocs\includes\menu.inc).

I think these might be related.