Dear Experts,
I am an amateur with CF and have restarted using CF after quite a long break. I
am having trouble with a query in which I am comparing password entered in a
form field to that stored in my MS Access DB. The problem is that the
comparison is case-insensitive. How can I make it
Yep I have seen all those, but the API documentation is different from Facebook
Connect (http://developers.facebook.com/connect.php).
We are building a community app where the client wants the user to be able to
sign in using their Facebook account and then find other users in our system
who
Microsoft Access is terrible.
I recommend switching to *any* other database engine.
You should then be able to use the COLLATE SQL command to enforce
case-sensitivity on a column.
~|
Want to reach the ColdFusion community
the COMPARE function should do the trick for you.
http://livedocs.adobe.com/coldfusion/6/CFML_Reference/functions-pt138.htm
http://www.scandicweb.com/coldfusion/tutorials/tutorial90.cfm
~|
Want to reach the ColdFusion
No one has any suggestions for this issue?
_
From: Dawson, Michael [mailto:m...@evansville.edu]
Sent: Fri 6/12/2009 10:24 AM
To: cf-talk
Subject: User Authentication without Session Expiration
For the last seven years, I have used IIS and basic authentication to
log in to our
I suggest, you keep the credentials encrypted or decrypted as you wish, but
keep them on the Application server in the session scope and for the browser
thingeee use a simple cookie to maintain the heartbeat. You can use a
cookie by the name 'logedin' and set its value true. Every time a
Some pointers here:
http://www.bennadel.com/blog/1131-Ask-Ben-Ending-ColdFusion-Session-When-Use
r-Closes-Browser.htm
The idea is to set up the session expiration in CF admin to a few hours
(which should give the users enough time to complete the form), authenticate
the user using whatever
Microsoft Access is terrible.
Well, yet another legendary Access database bashing :-(
Access database are GREAT for any small/medium web application.
Most databases implement the string comparison to be case insensitive by
default.
They also have provisions to change it either globally or
the COMPARE function should do the trick for you.
The COMPARE function is a CF function. What is needed here is an SQL
function.
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House
Claude Schneegans wrote:
Microsoft Access is terrible.
Well, yet another legendary Access database bashing :-(
Access database are GREAT for any small/medium web application.
Most databases implement the string comparison to be case insensitive by
default.
They also have provisions to
10 matches
Mail list logo