On Apr 25, 1:57 am, Scott Kulik <[email protected]> wrote: > I have a table for private messages similar to: > > PMS: > title > body > sent_to (foreign key to users table) > sent_from (foreign key to users table) > > When I originally set it up I didn't have it automatically a users pm's > when that user was deleted. So...I have basically been manually > updating the database when a users has problems with their private > messages page. > > I'm wondering if someone knows a good way I could scan the the pm's > table and delete messages that no longer have a user for sent_to or > sent_from. >
sounds like a job for a left join. If I were you I'd also setup a foreign key constraint so that this sort of thing can't happen in the future Fred -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
