RE: The query below will return a match without regard to the case

I'm using Access. Any ideas with that or would I need to use the solution you provided below with nested loops? There may be something for this in Access, but I don't know enough about Access to tell you. Are all password protected sites done with Cold Fusion non-case sensitive, or is a lot

Re: The query below will return a match without regard to the case

I figured it out using the compare function after getting a valid username and password from the db. This will check a username and password for case sensitivity. CFIF (login.recordcount eq 0) or (compare(form.password, login.password) neq 0) or (compare(form.username, login.username) neq 0)

Re: The query below will return a match without regard to the case

I'm using Access. Any ideas with that or would I need to use the solution you provided below with nested loops? Are all password protected sites done with Cold Fusion non-case sensitive, or is a lot of special processing done when Access is the db? -- Chris Giminez "password" in the

RE: The query below will return a match without regard to the case

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"

The query below will return a match without regard to the case

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