search for: t0_r5

...ncluding 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'' [4;35mCategory Load (0.000000) [0;37mSELECT * FROM categories WHERE ckey = ''when'' [4...

...t; AS t2_r10, matches."id" AS t2_r0, matches."played" AS t1_r11, matches."matchtime_start" AS t1_r5, teams_seasons."manager_id" AS t0_r4, matches."played" AS t2_r11, matches."matchtime_stop" AS t1_r6, teams_seasons."league_id" AS t0_r5 FROM teams_seasons LEFT OUTER JOIN matches ON matches.hometeam_id = teams_seasons.id LEFT OUTER JOIN matches ON matches.awayteam_id = teams_seasons.id WHERE (teams_seasons.division_id = 1) | I''d like to know if this is an incorrect implementation detail or just a _don''t_do_th...

...ate] ) but I get the error: OCIError: ORA-00904: "DOC_TYPES"."PUBLICATION_ID": invalid identifier: SELECT publications.id AS t0_r0, publications.docid AS t0_r1, publications.doc_type_id AS t0_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_stat...

...ions => ["skill_id = ?",3] ) -- and it works. The SQL in development.log looks correct (if verbose): SELECT employees.`id` AS t0_r0, employees.`title` AS t0_r1, employees.`desc_short` AS t0_r2, employees.`picture_url` AS t0_r3, employees.`contract` AS t0_r4, employees.`available` AS t0_r5, employees.`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.`...

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/.

...ActiveRecord::StatementInvalid (Mysql::Error: #23000Column ''created_at'' in order clause is ambiguous: SELECT gb_entries.`id` AS 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.`par...

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/.

...mentions all the fields explicitly, but creates no joins: [4;36;1mCourse Load Including Associations (0.002771) [0m [0;1mSELECT courses.`id` AS t0_r0, courses.`name` AS t0_r1, courses.`reference` AS t0_r2, courses.`subject_id` AS t0_r3, courses.`course_type_id` AS t0_r4, courses.`description` AS t0_r5, courses.`credits` AS t0_r6, courses.`lock_version` AS t0_r7, courses.`created_on` AS t0_r8, courses.`updated_on` AS t0_r9 FROM courses ORDER BY name [0m And then, when rendering, it churns out the myriad of individual queries just as before. Can anybody help me out with this? --~--~---------~...

...ms ON mechanisms.id = grants.mechanism_i d WHERE ( ( title LI'' at line 1: SELECT grants.`id` AS t0_r0, grants.`brown_gra nt_identifier` AS t0_r1, grants.`account` AS t0_r2, grants.`grant_type_id` AS t0 _r3, grants.`mechanism_id` AS t0_r4, grants.`sponsor_agency_id` AS t0_r5, grants .`award_year_indicator_id` AS t0_r6, grants.`grant_home_id` AS t0_r7, grants.`sp onsor` AS t0_r8, grants.`fund_source` AS t0_r9, grants.`department_name` AS t0_r 10, grants.`start_date_overall` AS t0_r11, grants.`end_date_overall` AS t0_r12, grants.`start_da...

...Bytes_sent: 2426331478 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: A93 SET timestamp=1381244774; SELECT `hosts`.`id` AS t0_r0, `hosts`.`name` AS t0_r1, `hosts`.`ip` AS t0_r2, `hosts`.`environment` 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, `res...

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

Dear all great developers. I wonder if there is any work being done or thoughts being shared regarding prepared SQL statements. Currently I am in heavy need of tuning SQL INSERTS that insert large (3MB) images into blobs. I am using rails 2.3.5 with postgres adapter and pg driver. Any information would be appreciated. Jarl -- You received this message because you are subscribed to the