Different result from same SQL statement
the following sql statement brings records using query analyzer on sql server. when run in cold fusion page comes no results. idea why????????
select count(h.userid) hits, u.ocd
from dbo.tbl_hits h inner join
dbo.tlkp_users u on h.userid = u.pin
where (h.appname 'opwiz%') , (h.lu_date between '05/01/07' , '06/01/07')
group u.ocd
order u.ocd
select count(h.userid) hits, u.ocd
from dbo.tbl_hits h inner join
dbo.tlkp_users u on h.userid = u.pin
where (h.appname 'opwiz%') , (h.lu_date between '05/01/07' , '06/01/07')
group u.ocd
order u.ocd
perhaps sql server performing implicit type conversion date values date/time datatype when query run via query analyzer, conversion not happening coldfusion. happens if explicitly cast() date "strings" datetime?
phil
phil
More discussions in Database Access
adobe
Comments
Post a Comment