Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 5 of 5
  1. #1
    Senior Member raspberryh's Avatar
    Join Date
    Aug 2004
    Location
    Erie, PA
    Posts
    882
    Member #
    7208
    Liked
    1 times
    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
    choosy developers choose gif!
    website | paintings | blog

  2.  

  3. #2
    Senior Member raspberryh's Avatar
    Join Date
    Aug 2004
    Location
    Erie, PA
    Posts
    882
    Member #
    7208
    Liked
    1 times
    ...actually, I just found an md5 function in the PHP manual... So, I think I'll try that.
    choosy developers choose gif!
    website | paintings | blog

  4. #3
    Senior Member
    Join Date
    Jun 2005
    Location
    Atlanta, GA
    Posts
    4,146
    Member #
    10263
    Liked
    1 times
    Yeah, you can md5 it in PHP. That's what I usually do to keep the db code portable.

  5. #4
    Senior Member raspberryh's Avatar
    Join Date
    Aug 2004
    Location
    Erie, PA
    Posts
    882
    Member #
    7208
    Liked
    1 times
    Cool, thanks shadow.
    choosy developers choose gif!
    website | paintings | blog

  6. #5
    Senior Member filburt1's Avatar
    Join Date
    Jul 2002
    Location
    Maryland, US
    Posts
    11,774
    Member #
    3
    Liked
    21 times
    http://www.codeproject.com/database/xp_md5.asp

    Although just using PHP is probably simpler.
    filburt1, Web Design Forums.net founder
    Site of the Month contest: submit your site or vote for the winner!


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 02:56 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com