Marnen Laibow-Koser wrote: > Scott Kulik wrote: >> Frederick Cheung wrote: >>> On Apr 25, 1:57�am, Scott Kulik <[email protected]> wrote: >>>> 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 >> >> Thanks Fred. The problem is i don't know the syntax for the join. Did >> you happen to know off the top of your head? > > Then please spend some quality time with an SQL reference. If you can't > write simple joins, then you are not yet ready to develop Web > applications that use SQL databases. > > Best, > -- > Marnen Laibow-Koser > http://www.marnen.org > [email protected]
Wow, that's harsh. Just because I don't know the syntax offhand without doing some research doesn't give you the right to bash me. If you really want to talk down to people then I don't think that you belong on a forum that is about helping people using Ruby on Rails. BTW, I have successfully developed a website that gets 750,000 to 1,000,000 page views a month. I thought this was a place I could come to get some insight without worrying about looking stupid. -- Posted via http://www.ruby-forum.com/. -- 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.
