I am using AxKit::XSP::ESQL to create a connection to a mysql database and
check whether a user exists. To do this I must look the user up and check
the password matches the one in the database. The following works fine.
<esql:query>
select * from user where userId =
<esql:parameter><xsp:expr><param:username /></xsp:expr></esql:parameter>
and password = <esql:parameter><xsp:expr><param:password
/></xsp:expr></esql:parameter>
</esql:query>
However, my password in the database is stored using MD5 encryption. So I
thought, simple... AxKit::XSP::MD5. But the MD5 taglib seems not to
actually produce a 32 bit MD5 encrypted string as it should. I have been
trying to use it like so:
<esql:query>
select * from user where userId =
<esql:parameter><xsp:expr><param:username /></xsp:expr></esql:parameter>
and password = <esql:parameter><xsp:expr><md5:md5><param:password
/><md5:md5></xsp:expr></esql:parameter>
</esql:query>
But it always fails. I tried to test the md5 taglib by just doing
<md5:md5>testphrase</md5:md5> on a blank xsp page and it gives the result
'????8"?u???}4'. This really doesn't look like a proper MD5 result. SO,
where am I going wrong!?
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
