topic md5 function in QV? in QlikView

md5 function in QV?

Thu, 30 Jul 2009 21:57:07 GMT

We are using Section Access to invoke row-level security in an app. We also have a table for user logins and passwords (password saved as an md5 hash in the table).

?Is there an md5( function in QlikView that will give us the correct hash that our database already generated, so I can compare the two to see if the password the user typed in was correct?

md5 function in QV?

hector — Thu, 30 Jul 2009 22:22:35 GMT

Maybe this can be a new feature request for the next release, this could be very usefull, including others algorithms like sha1(Microsoft).

Regards

PD. i found the source code in C, but i dont think that is very simple to develop in QV (Macro Function)

md5 function in QV?

Thu, 30 Jul 2009 23:00:24 GMT

You can download the md5.exe application which generate a hash code.

When reloading your application you can ask the password by a message box, then via a macro which run the md5, retrieve the hash code ?

This is not a perfect solution but that should be possible I think.

Rgds,

md5 function in QV?

peter_turner — Mon, 03 Aug 2009 22:40:50 GMT

Hello,

Was anyone successful using this MD5 function for storing passwords etc?

Thanks,
Peter.

md5 function in QV?

Anonymous — Tue, 04 Aug 2009 12:47:58 GMT

MD5 and VBScript combos can be found here:

http://www.naterice.com/articles/66

or here:

http://www.robvanderwoude.com/vbstech_files_md5.php