Hello.
I imported users from another database, and there were some that have multiple login names, which prevents these users from logging in at all. Is there a symbol in SQL that can search for duplicates so I can delete them? In filemaker, it is "!".

Thanks,
Carl
Songfacts.com

Not really a command to find duplicates. Threads uses user numbers, which use a unique column in the database.

Not sure why your import went wrong.

You'll need to delete the duplicates manually - I'd recommend using something like phpMyAdmin so you can easily see and manipulate the database.

Or - dume the user's table and try the import again.

Josh
www.joshuapettit.com
ThreadsDev.com Administrator | InfoPop Community Moderator
Register to see my How To/Site Help Library Forum at ThreadsDev.com.
My threads 'tweaking' abilities are for hire for upgrades, tweaks and modifications.