2 Replies Latest reply on Jun 10, 2009 6:39 AM by zzipper7

    ADDT Forgot Email needs additional record filter due to multi items by same user


      My site has a feature that one user can own multiple products  with one email.


      Ex. Item 1 = username1 + email 1

            Item 2 = username2 + email 1

            Item 3 = username3 + email 1



      I need the forgot email to add the extra condition to check the username before looking up the email, otherwise it says there are mutilple records for that email address.


      I tried editing the trigger sql WHERE stment but it ignored it and returned the same. (it was my fault not the code obviously)


      most of this is a little over my head but I "get it" with some good direction.


      If someone has modified this funtion for this additional filter can you please share it?


      ADDT Newbie,