search for: t1_r2

...0) [0;37mSHOW FIELDS FROM todos [4;33mWhens Columns (0.000000) [1;37mSHOW FIELDS FROM whens [4;35mTodo Load Including Associations (0.000000) [0;37mSELECT todos.position AS t0_r6, todos.due AS t0_r7, whens.todo_id AS t1_r0, whens.id AS t1_r1, todos.repeat_id AS t0_r0, whens.category_id AS t1_r2, todos.hour AS t0_r1, todos.priority AS t0_r2, todos.id AS t0_r3, todos.description AS t0_r4, todos.kind_id AS t0_r5 FROM todos LEFT OUTER JOIN whens ON whens.todo_id = todos.id ORDER BY position ASC [4;33mCategory Load (0.000000) [1;37mSELECT * FROM categories WHERE ckey = ''where'...

...display etc The code of links_Controller is like below. def list @links = Genre.find(:all,:include => :link) end Below is the mysql log. SELECT genres.`id` AS t0_r0, genres.`genre_n ame` AS t0_r1, genres.`genre_order` AS t0_r2, links.`id` AS t1_r0, links.`genre_ id` AS t1_r1, links.`name` AS t1_r2, links.`symbol` AS t1_r3, links.`url` AS t1_ r4, links.`order` AS t1_r5, links.`display` AS t1_r6, links.`etc` AS t1_r7 FROM genres LEFT OUTER JOIN links ON links.genre_id = genres.id But I don''t know the way to show them in the view. How do I have to write the code in the view(list.rht...

...Call Load Including Associations (0.002511) SELECT calls."id" AS t0_r0, calls."login_id" AS t0_r1, calls."created_at" AS t0_r2, calls."comment" AS t0_r3, logins."id" AS t1_r0, logins."login" AS t1_r1, logins."employee_id" AS t1_r2 FROM calls LEFT OUTER JOIN logins ON logins.id = calls.login_id Completed in 0.08172 (12 reqs/sec) | Rendering: 0.03247 (39%) | DB: 0.00363 (4%) | 200 OK [http://localhost/calls/show/1] which certainly looks to be close to the desired output: thufir@arrakis ~/goodfellow-tool $ sqlite3 db/deve...

...nclude parameter for the .find method, ActiveRecord generates incorrect query which brings to SQL error "ambiguous column name". So, for the fist case (self-refferal join), ActiveRecord will generate this query: SELECT keywords.id AS t1_r0, keywords.id AS t0_r0, keywords.group_id AS t1_r2, keywords.group_id AS t0_r2, FROM keywords LEFT OUTER JOIN keywords ON keywords.id = keywords.group_id; My point is to use AS statement to refer JOIN''ed tables as aliases, so we can produce query like: SELECT keywords_t1.id AS t1_r0, keywords.id AS t0_r0, keywords_t1.group_id AS t1_r...

...ot; AS t2_r4, matches."matchtime_start" AS t2_r5, matches."id" AS t1_r0, matches."matchtime_stop" AS t2_r6, matches."awayteam_goals" AS t1_r1, teams_seasons."id" AS t0_r0, matches."season_id" AS t2_r7, matches."hometeam_goals" AS t1_r2, teams_seasons."team_id" AS t0_r1, matches."league_id" AS t2_r8, matches."awayteam_id" AS t1_r3, teams_seasons."season_id" AS t0_r2, matches."venue_id" AS t2_r9, matches."division_id" AS t1_r10, matches."hometeam_id" AS t1_r4, te...

...r2, publications.title AS t0_r3, publications.lang AS t0_r4, publications.keywords AS t0_r5, publications.cvsdir AS t0_r6, publications.publishername AS t0_r7, publications.publisherorg AS t0_r8, publications.release_state_id AS t0_r9, doc_types.id AS t1_r0, doc_types.code AS t1_r1, doc_types.en AS t1_r2, doc_types.es AS t1_r3, doc_types.sv AS t1_r4, doc_types.descr AS t1_r5, release_states.id AS t2_r0, release_states.code AS t2_r1, release_states.name AS t2_r2, release_states.descr AS t2_r3 FROM publications LEFT OUTER JOIN doc_types ON doc_types.publication_id = publications.id LEFT OUTER JOIN...

...find(1, :include => :user) in Rails console. From the log, I can see the sql is: Package Load Including Associations (0.000309) SELECT `packages`.`id` AS t0_r0, `packages`.`name` AS t0_r1, `packages`.`user_name` AS t0_r2, `users`.`id` AS t1_r0, `users`.`name` AS t1_r1, `users`.`full_name` AS t1_r2 FROM `packages` LEFT OUTER JOIN `users` ON `users`.id = `packages`.user_name WHERE (`packages`.`id` = 1) But I cannot find the parameters for belongs_to to set associated_foreign_key like has_and_belongs_to_many. I don''t know how to deal with it. Please help. Thanks. -- Posted via http:/...

...ees.`address` AS t0_r6, employees.`comments` AS t0_r7, employees.`creation_date` AS t0_r9, employees.`last_update` AS t0_r10, employees.`is_featured` AS t0_r11, employees.`is_deleted` AS t0_r12, employees.`is_hidden` AS t0_r13, skills.`id` AS t1_r0, skills.`parent_id` AS t1_r1, skills.`name` AS t1_r2, skills.`desc_short` AS t1_r3 FROM employees LEFT OUTER JOIN skills_employees ON skills_employees.recipe_id = employees.id LEFT OUTER JOIN skills ON skills.id = skills_employees.skill_id WHERE (skill_id = 3) But remember, I want to use this in a Pagination scenario, and that''ll requir...

When I do this: term = Term.find(1, :include => :definition) term.definition.term Two SQL queries are fired, why? -- Posted via http://www.ruby-forum.com/.

...t0_r0, gb_entries.`name` AS t0_r1, gb_entries.`email` AS t0_r2, gb_entries.`homepage` AS t0_r3, gb_entries.`message` AS t0_r4, gb_entries.`created_at` AS t0_r5, gb_entries.`parent_id` AS t0_r6, childrens_gb_entries.`id` AS t1_r0, childrens_gb_entries.`name` AS t1_r1, childrens_gb_entries.`email` AS t1_r2, childrens_gb_entries.`homepage` AS t1_r3, childrens_gb_entries.`message` AS t1_r4, childrens_gb_entries.`created_at` AS t1_r5, childrens_gb_entries.`parent_id` AS t1_r6 FROM gb_entries LEFT OUTER JOIN gb_entries childrens_gb_entries ON childrens_gb_entries.parent_id = gb_entries.id WHERE gb_entr...

I have this Product.find(:all, :include => [:brand, :category, :type], :group => "description"), but it dont group by description why? Bruno -- Posted via http://www.ruby-forum.com/.

Ruby 1.8.2, edge Rails (and 1.0), Mac OS X 10.4.3. Here''s the SQL that gets generated for an eager load: SELECT events.`id` AS t1_r0, events.`user_id` AS t1_r1, addresses.`id` AS t0_r0, events.`name` AS t1_r2, addresses.`name` AS t0_r1, events.`meet_at` AS t1_r3, addresses.`phone_number` AS t0_r2, events.`created_at` AS t1_r4, addresses.`phone_service` AS t0_r3, events.`location_id` AS t1_r5, addresses.`user_id` AS t0_r4 FROM addresses [" LEFT OUTER JOIN addresses_events ON addresses_events.ad...

I did some searches in the mailing list and on the web but I can''t seem to find the answer to this, but it''s pretty much a noob question. I have a Product object class Product < ActiveRecord::Base has_many :product_identifications has_one :product_identification_item_number has_one :product_identification_product_code end the product_identifications is using

...` AS t0_r24, grants.`updated_at` AS t0_r25, grants.`updated_on` AS t0_r26, grants. `lock_version` AS t0_r27, grants.`created_by` AS t0_r28, grants.`updated_by` AS t0_r29, sponsor_agencies.`id` AS t1_r0, sponsor_agencies.`name` AS t1_r1, sponso r_agencies.`address` AS t1_r2, sponsor_agencies.`phone` AS t1_r3, sponsor_agenci es.`contact_name` AS t1_r4, sponsor_agencies.`created_at` AS t1_r5, sponsor_agen cies.`created_on` AS t1_r6, sponsor_agencies.`updated_at` AS t1_r7, sponsor_agen cies.`updated_on` AS t1_r8, sponsor_agencies.`lock_version` AS t1_r9, s...

...SELECT `lexemes`.`id` AS t0_r0, `lexemes`.`name` AS t0_r1, `lexemes`.`ref_id` AS t0_r2, `lexemes`.`meta_id` AS t0_r3, `structures`.`id` AS t1_r0, `structures`.`ref_id` AS t1_r1, `structures`.`meta_id` AS t1_r2, FROM `lexemes` LEFT OUTER JOIN `structures` ON structures.ref_id = lexemes.id and structures.meta_id=0 WHERE (structures.id<10) For the second one ActiveRecord::StatementInvalid: Mysql::Error: Unknown column ''lexemes.ref_id'' in ''field list'': SELECT `lexemes...

I am working with an existing schema and thus limited in how much I can bend my existing column names. I have a table Users, and a table ForumUsers, for which I have a "has_one" relationship - a user has_one forumuser. When I look at my user records I wish to include some information from forumuser: @users = User.find :all, :include => :forum_user, :order =>

...blem is that: Blog.find(:all, :include => :published_posts).first.published_posts returns all the posts for the blog, not just the published ones. The SQL generated looks like this: SELECT posts.`id` AS t1_r0, posts.`blog_id` AS t1_r1, blogs.`id` AS t0_r0, posts.`subject` AS t1_r2, blogs.`name` AS t0_r1, posts.`content` AS t1_r3, posts.`published` AS t1_r4 FROM blogs LEFT OUTER JOIN posts ON posts.blog_id = blogs.id The following, on the other hand, returns just the posts marked as published: Blog.find(:all).first.published_posts If anyone wa...

...ent` AS t0_r3, `hosts`.`last_compile` AS t0_r4, `hosts`.`last_freshcheck` AS t0_r5, ` hosts`.`last_report` AS t0_r6, `hosts`.`updated_at` AS t0_r7, `hosts`.`source_file_id` AS t0_r8, `hosts`.`created_at` AS t0_r9, `resources`.`id` AS t1_r0, `resources`.`title` AS t1 _r1, `resources`.`restype` AS t1_r2, `resources`.`host_id` AS t1_r3, `resources`.`source_file_id` AS t1_r4, `resources`.`exported` AS t1_r5, `resources`.`line` AS t1_r6, `resources `.`updated_at` AS t1_r7, `resources`.`created_at` AS t1_r8, `param_values`.`id` AS t2_r0, `param_values`.`value` AS t2_r1, `param_values`.`param_name_...

Hi, I m very new to Ruby. I bought a book "Ruby on Rails" and I think I understand some concepts. My question is : Is there a way to not use "Cookies" or "Sessions Variables" to keep some information about the user. I ask this question because I would like to prevent some cases where the user browser won''t accept cookies. I m from Asp 3.0, and I

I offer my apologies in advance for the repost. On a list as busy as this, it is sometimes easy to get missed in the shuffle. I am trying to create, display and edit a referenced object''s text field on the same view as my root object. For example: ------------------------- Quiz: <<quiz.name>> Preamble: <<quiz.preamble_presentation.text>> Postamble: