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!

Comments

Popular posts from this blog

Create bootable CUC CUCM CUP Image / ISO

Configuring Oracle 12c backups on Veritas Backup Exec 16.

Configuring Cisco CME Voice Gateway (VG) for incoming and outgoing calls using Sipgate trunk