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 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>
>
> I can tell you how this works in SQL Server; when you install SQL Server,
it
> asks you what sort order to use. You can then pick case-sensitive
> or -insensitive. If you want to change later, you have to reinstall SQL
> Server and rebuild all your databases. The default is case-insensitive.
>
> So, if you had a default SQL Server install, you'd have to do a lot of
work
> with string functions to make this happen. For example, within your SQL
you
> could retrieve all the records that have a simple string match, then loop
> over each returned record, and within that loop have a nested loop that
> examines each string character-by-character. Alternatively, you could do
> that within CF.
.
------------------------------------------------------------------------------
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.
