Query results differ in SQL Mgmt and CFQuery

Question

executing the following query in the SQL management studio yields results, whereas this is not through cfquery ...

select distinct locationid, locationname, locationaliasname
from vwLocationsWithAlias
where 1 = 0
or (LocationName = N'the' or LocationAliasName = N'the')
or (LocationName = N'the republic' or LocationAliasName = N'the republic')

Expected results are returned from Mgmt Studio SQL, but nothing is returned from CFQuery. WTF !?

Answer 1

Run the profiler when you send a request from Coldfusion and see if it sends what you expected.

Answer 2

I assume that it has the TransactSQL Unicode ("N") indicator, which you have on string constraints. I suspect that the SQL parser in CF does not understand this.

Does CF give an error or just don't return any rows?

Datasource sql- , , DB :

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=datasources_ADV_MJS_11.html

Answer 3

, ( db):)

Answer 4

preserveSingleQuotes , .

Answer 5

, , "group by"

Answer 6

nvarchar vs varchar, N'the' "" - , where.

, , coldfusion, , .

coldfusion , .

.

Answer 7

, SSMS CFQuery "SET" ? .

, SQL Profiler, , " ". ( , , , ...) cfquery SELECT @@OPTIONS SELECT SESSIONATTRIBUTE(...).

, , - .