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. ...bad password. try again. -- Chris Giminez Owner - Cyber Scriber Web Site Design 831-728-4469 ICQ# 2628000 > > I'm using Access

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

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 da

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? > > > SELECT Count(*) AS loggedin