similar to: Displaying data in a table

I''ve got a publications table that contains an author_id foreign key and a pubrole_id foreign key. What I want to do is query the DB using AR so that I can get a list of all publications that belong_to a particular author, and group the results by the pubrole.role_name (Author, Joint Author, Editor, etc.) so that the results look something like: Author book1 info book2 info etc.

Hi all, Not really sure what to put in the title so hope people still open this! What I want to do is produce something like this Col1 Col2 Col3 data1 data2 data3 data4 data5 data6 data7 data8 data9 data.. data.. data.. data.. data.. data.. data-n data-n+1 data-n+2 I can get the data back from my db

Hello there, I have something odd happening to my image tags when displaying an image. Here''s what my ''<img src>'' tags are looking like: <img alt="2-thumb" src="/images/public/uploaded_images/2-thumb.jpg?" /> Notice the question mark at the end of the string. I have no idea where this coming from. Here are the important parts of my

I''m having a great deal of trouble getting rake to run migrations on our staging server. Everything works fine on my dev box, but trying to run the following on staging results in errors. ----- > rake db:migrate (in /var/www/apps/acadtech2/app) rake aborted! Don''t know how to build task ''db:migrate'' (See full trace by running task with --trace) ---- The

Some blog sites and others (ticketmaster, for example) require you to read a graphical representation of a word or number to prevent a form from being submitted programmatically. I''d like to do something similar on a new site I''m building. Two quick questions: 1. Is there a standard term for these graphical representations? i.e. how would I do a google search for this

Question for all: Right now i have a Table in a mySQL DB that has a row called Ingredients. When the data is entered into the DB its enter like so from a text area: 1 1/2 lbs. beef top sirloin, thinly sliced 1/3 cup white sugar 1/3 cup rice wine vinegar 2 tablespoons frozen OJ concentrate 1 teaspoon salt 1 tablespoon soy sauce 1 cup long grain rice 2 cups water 1/4 cup cornstarch 2 teaspoons

Hi, I''ve read that Dr. Dobbs Journal''s last issue has a cover article about Rails titled "Ruby On Rails - Java''s Successor?". Can''t find anything about it in http://www.ddj.com Does someone have the paper edition and can confirm that, and tell how the article looks like, and so on. Thanks, -- Jean-Fran?ois. -- ? la renverse.

Hi, Is this possible ive got layout "loggedout_layout", :only => [:login, :logout] but I also want to do somthing like layout "loggedin_layout", :except => [:login, :logout] When the second one is introduced it seems to cancel out the first request, any suggestions how to get around this? Scott -- Posted via http://www.ruby-forum.com/.

Hi all, Here''s another contribution for anyone interested. In Railscast episode 28, Ryan Bates showed us in_groups_of which allows you to group array members such as >> list = [1, 2, 3, 4, 5, 6, 7] => [1, 2, 3, 4, 5, 6, 7] >> list.in_groups_of(3) => [[1, 2, 3], [4, 5, 6], [7, nil, nil]] This allows you to iterate over the groups and, for example, display a list

I have set up some fixtures in test/fixtures/users.xml: # Read about fixtures at http://ar.rubyonrails.org/classes/Fixtures.html admin: id: 1 username: admin password: admin pbarry: id: 2 username: pbarry I have a unit test for my user model: require File.dirname(__FILE__) + ''/../test_helper'' class UserTest < Test::Unit::TestCase fixtures :users def

I love the routes feature for RoR...until now. I''m trying to write tests to make sure my urls are correctly mapping to the routes I expect them to map to. This is driving me nuts because I simply can''t get any of my tests to pass. I have thus concluded that routes must work differently than I thought. If someone could possibly point me in the right direction, I would really

After reading: <http://www.loudthinking.com/arc/000572.html> I''m trying to experiment with respond_to in order to not repeat myself and create atom feeds out of a "browse" view. In application controller I created a before filter that checks for the extension of the current url and changes the accept header: [code] def check_headers @headers["Accept"]

I was wondering if there is a Rails method that does something similar to the "About your application?s environment" link on the "Welcome Aboard" page you get when you first install Rails. What the link does is make and AJAX call, then blind down and up using AJAX. Thanks. -- Posted via http://www.ruby-forum.com/.

Hey there all, Is there some way to tell rails or sql server to ignore the time in a datetime field when doing a comparison? For example, if I do something like select * from users where registration_date = ?, @date where @date might equal some user input like ''03/14/2006'' The result is nothing returned, because in my tables the datetime field looks like this: 3/14/2006

Hello again: I''m hoping that somebody, anybody, can help with this question. How do I make sure that records in a join model are unique? Using the scenario outlined in Chad Fowler''s "Rails Recipies", number 16, "Many to Many Relationships Where the Relationship Iteself Has Data". Here are the tables: create_table :magazines do |t| t.column :title,

Hello, I''ve done === class HomeController < ApplicationController def index @country = Country.find(:all, :include => "cities") end end === And rhtml is: === <% @country.each do |country| %> <h1><%= country.name %></h1> <% country.cities.each do |city| %> - <%= link_to city.name, :action =>

I am very confused about where to put the belongs_to and the has_one (and other relationship identifiers). I have read the RDoc and the agile book many times about this and I think i still see it backwards. Let me outline my app so you have an understanding... I have 2 tables: Schools { id, school_name, address_id } and Addresses { street1, street2, city, state, zip, country } *** this

Greetings, I''m trying to convert a HABTM w/attributes join table in my database into a join model table in order to utilize the new has_many :through functionality introduced in Rails 1.1. Here''s the current table definition: licenses_user_groups: license_id, user_group_id, usage_notes Perhaps it was a mistake, but I made (license_id, user_group_id) the primary key. Now,

This seems like it must have been asked before - I really _did_ try to find it in the archives, so my apologies if it''s already out there. Utilizing ActiveRecord, I would like to specify a prefix for the column names in my table. For example, in ''Recipe 16 Integrating with Legacy Databases'' (Rails Recipes, from PragProg, by Fowler) they deal with integration with a

I''m not getting any love grouping controllers into separate namespaces and I''m hoping someone can tell me what I''m not getting: $ rails foo $ cd foo $ script/generate controller Namespace::Bar index $ script/server $ lynx http://localhost:3000/namespace/bar -> 404 -> Routing Error -> Recognition failed for "/namespace/bar" Many thanks in advance.