Something like this should do it:

<CFQUERY name="login" datasource="#dsn#">
SELECT *
FROM Users
WHERE UserName='#username#'
AND Pwd = '#pwd#'
</CFQUERY>

Of course your...