CFQUERY not working for some reason

[bfinelsen]

I have the following code to authenticate a password, and it is successful,
complete the <CFIF> Statement:

<cfquery name="checkpass" datasource="#request.ds#">
SELECT Count(tbl_Passwords.password) AS CPASS
FROM tbl_Passwords
WHERE tbl_Passwords.password='#FORM.password#';
</cfquery>

<cfif checkpass.CPASS GT 0>
Do something here........

However, it shoots right to the <CFELSE> part which says password cannot be
authenticated. The password exists and is in the database, so I'm confused as
to why this no longer works. Especially since I have not changed this code in
quite some time and it was working fine. Please help

[JaredJBlackburn]

If you haven't already, turn on CF debugging and see what query you are
actually sending to the SQL server. If you're problem isn't obvious at first
glance, paste the resulting sql code into query analyzer and run it there to
see what happens. You may also consider removing the count() aggr function
from the sql and letting it return rows - then <cfdump var="#checkpass"#> right
after you </cfquery> to see what actually got returned to coldfusion.