Database Systems Help

**raspberryh** · April 27 '07, 03:23 PM (#1)

Hey,

So, a client of ours wants to use this eblast module, Sendstudio, which only comes for mysql, not mssql... So I have to convert all the code the mssql

So, I'm trying to make an insert statement work... Well, they have one that uses the md5 function in mysql...

Code:

INSERT INTO %%TABLEPREFIX%%users(username, password, status, admintype, listadmintype, templateadmintype, createdate, lastloggedin, unlimitedmaxemails, infotips) values('admin', md5('password'), '1', 'a', 'a', 'a', UNIX_TIMESTAMP(NOW()), '0', '1', '1')

...but the md5 function is not defined in mssql! Does anybody know of any workarounds? I tried searching the web but didn't really find anything very useful. Oh btw, the whole thing is in PHP, not ASP (but I posted this here b/c of the MSSQL).

Thanks,
Heather