md5 hashing to store passwords with ms sql
When using md5 hashing to store passwords with ms mql everything works fine with alpha numeric values except space characters, which don't work when the user types in the password in the flex app, an unmatching m5d checksum is therefore being produced when space characters are in the password client side and passed to coldfusion and then to ms sql
<cfquery name="q" datasource="#d#">
select * from USERS
where userName = <cfqueryparam value="#arguments.value#" cfsqltype="cf_sql_varchar">
AND password = HashBytes('MD5', <cfqueryparam value="#arguments.password#" cfsqltype="cf_sql_varchar">
any ideas?