vb3 Integration with custom ColdFusion application

[f150guy]

Hello All,

We have been long-time users of vb and ColdFusion. Today, we finally completed an upgrade from vb2.3.7 to vb3.0.7. Unfortunately, the upgrade effectively broke our links to our ColdFusion applications. We did use vb2's user table to authenticate people to our homegrown classifieds and photo gallery applications. The process was simple, with just a single hash of the user password input.

Things have become much more complicated with vb3, with the added hash and Salt.

Does anyone see why this would not work?

<CFSET password = hash(hash(form.password)&qGetUser.salt)>

Form.password is the unencrypted password supplied by the user.
qGetUser.salt is the salt value in the user table for the username provided.
hash is a function that converts a string using MD5.

Can someone point me in the right direction as to how to accomplish this integration with vb3?

Thanks in advance.

Steve

Well, it turns out that I did not even need to get ColdFusion functions involved. I was able to hash the plain text password and add the salt just via the MySQL query. Phew.