Different result from same SQL statement

["Anthony Spears" <anthony.spears@xxxxxxx>]

The following SQL statement brings back records using query analyzer on the SQL 
server.  However when I run it in a cold fusion page it comes back with no 
results.  Any idea why????????

 SELECT     COUNT(h.userID) AS hits, u.OCD
 FROM         dbo.tbl_hits h INNER JOIN
                       dbo.tlkp_users u ON h.userID = u.PIN
 WHERE     (h.appName LIKE 'OPwiz%') AND (h.lu_date BETWEEN '05/01/07' AND 
'06/01/07')
 GROUP BY u.OCD
 ORDER BY u.OCD