This is my third attempt to post this question. Hopefully it will show up this time.
******************************************************
The query below will return a match without regard to the case
"password" in the database returns a record when matched with "PASSWORD" or "PaSSwORd"
when I want
it to return a record with "password" exactly.
How can I force a case sensative query?
<CFQUERY NAME="login" DATASOURCE="datasourse">
SELECT Count(*) AS loggedin
FROM admin_pass
WHERE username = '#trim(FORM.username)#'
AND password = '#trim(FORM.password)#'
</CFQUERY>
Thanks,
Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
