search for: total_com

...at the beginning from the "total_list_items" in the call from above. now comes the complicated part. i am trying to get a list of the most commented lists, and in that list i need all the information from above, but i also need to count "comments.list_id" and set that as "total_comments" or something. this is what i''ve come up with: SELECT lists.id, title, count(comments.list_id) AS total_comments, count(items.list_id) AS total_items FROM lists INNER JOIN comments ON comments.list_id = lists.id INNER JOIN items ON items.list_id = lists....

I''m trying desperately to get visuall effects callbacks working in rjs templates to no avail What I''m trying to do is fade an image, change the div with the image to a new image, and then fade the new image back in. How would I go about this in RJS Here''s a simple line from my rjs that I can''t get to work. It is not using callbacks so the