Ah... times such as these when Access really makes you happy... So I have an email field... unique, and people who think they are smart have signed up with a lowercase email, and then again with an uppercase email.
Yes it is my fault for not converting to lowercase before validating. (well I did it in ajax validation, but not when I actually insert to the db) So what is the best way for removing these duplicated records ? Should I iterate through every record, and then keep a dictionary in memory of how many times this email has been used, and if it has already been used, delete that row? -Thadeus
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.