Posts

Showing posts from October, 2010

Dreamweaver 'Log In User' Server Behaviour not case sensitive

Never found a straight answer to my problem on Uncle Google so I thought I would blog it. When creating a 'Log In User' Server Behaviour (within Dreamweaver), you might notice that when logging in, the case for the password is not case sensitive. In order to make the login page case sensitive for passwords, adjust the following code; MM_loginSQL = MM_loginSQL & " FROM tblLogin WHERE username = ? AND password = ? to MM_loginSQL = MM_loginSQL & " FROM tblLogin WHERE username = ? AND strComp(password, ?,0)=0 It seems difficult to tell above, but the o's are numbers, not letters. Happy logging in!