Well, what would I do? I'd "select primarykey, lower(emailfield) from table" and then assign the results to a dict. check the duplicates and remove them from the table.
On Jan 7, 6:59 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > 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.
