Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 3 of 3

Thread: Can I modify an anon's e-mail address w/ SQL statement?

  1. 03-09-2010, 03:38 PM #1
    StorageSolutions is offline Member
    Join Date
    Jun 2007
    Location
    Vero Beach, Florida
    Posts
    66

    Default Can I modify an anon's e-mail address w/ SQL statement?

    Hi
    We want to invalidate anon e-mail addresses in the db by preferably adding a 1 to the end of the e-mail address. Can you help me with an SQL statement that would accomplish this? We don't want to erase the e-mail addresses for many reasons but by adding a 1 to the end (.com1) would allow an anon customer to create an account on a return visit.

    Thanks in advance for your assistance!

    David
    ML 8.0.1.2
  2. 03-10-2010, 06:42 AM #2
    AspDotNetStorefront Staff - Scott's Avatar
    AspDotNetStorefront Staff - Scott is offline Administrator
    Join Date
    Mar 2007
    Location
    Ashland, OR
    Posts
    2,390

    Default

    You could use the SQL statement below to do that. Just make sure you've got a good backup of the database before running a query like this just in case.

    UPDATE Customer SET Email = Email + '1' WHERE IsRegistered=0
    ECommerce Shopping Cart
  3. 03-10-2010, 09:07 AM #3
    StorageSolutions is offline Member
    Join Date
    Jun 2007
    Location
    Vero Beach, Florida
    Posts
    66

    Default

    Thanks! I'll give this a try.
    ML 8.0.1.2