Displaying 17 results from an estimated 17 matches for "t0_r3".
Did you mean:
t0_r0
2005 Apr 27
5
Eager load mysteriously deletes records
...) [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''
[4;35mCategory Load (0.000000) [0;37mSELECT * FROM ca...
2008 Feb 09
0
MVC interplay to query multiple models
...SELECT * FROM calls WHERE (calls."id" = 1)
Rendering within layouts/calls
Rendering calls/show
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]...
2006 Jan 09
3
Include with two references of one model of the same table
...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, teams_seasons."coach_id" AS t0_r3, matches."division_id" 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_se...
2009 Feb 22
2
Mysql error unknown column 'columns.user_id'
...ments to another user''s photo.
ActiveRecord::StatementInvalid in User photosController#show
Mysql::Error: Unknown column ''comments.user_id'' in ''on clause'': SELECT
photos.`id` AS t0_r0, photos.`user_id` AS t0_r1, photos.`title` AS
t0_r2, photos.`body` AS t0_r3, photos.`created_at` AS t0....
I did create a user_id column in the comments as such:
class CreateComments < ActiveRecord::Migration
def self.up
create_table :comments do |t|
t.column :photo_id, :integer
t.column :user_id, :integer
t.column :guest_name, :string
t....
2007 May 22
2
find :all :include broken on Oracle 10
...ublication.find(:all, :include => [:doc_type, :release_state] )
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, d...
2006 May 20
3
In a find, can''t you use both :include and :limit ?
...ees = Employee.find(
:all,
:include => :skills,
:conditions => ["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_r...
2006 May 23
5
AR Caching and Reflection
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/.
2006 Jul 17
1
acts_as_tree and :include
...ude => :children
when i run that, i get the followin error:
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,
chil...
2006 Apr 19
2
I need help in ActiveRecord..
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/.
2006 Mar 14
3
cascading eager loading patch not working in oracle
Notice the "AS" keyword appears many times. Oracle does not support this
keyword:
ActiveRecord::StatementInvalid: OCIError: ORA-00905: missing keyword:
SELECT tim
esheets.id AS t0_r0, timesheets.start_date AS t0_r1, timesheets.status
AS t0_r2,
timesheets.cost AS t0_r3, timesheets.charge AS t0_r4,
timesheets.employee AS t0
_r5, employees.id AS t1_r0, employees.name AS t1_r1,
employees.start_date AS t1_
r2, employees.cost AS t1_r3, employees.charge AS t1_r4,
employees.username AS t1.....
I have just installed edge rails.
--
Posted via http://www.ruby-forum.c...
2006 Feb 19
2
Another "escaping" problem
...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.address_id = addresses.id LEFT OUTER JOIN events ON
addresses_events.event_id = events.id "]WHERE (addresses.`phone_number`
= ''6129641828'...
2006 Nov 28
0
Eager loading: what am I doing wrong?
...ct on the initial query issued - though
not the desired on: it just 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 jus...
2009 Mar 10
5
'unknow column error' when using include and associated table condition in find
...first one
ActiveRecord::StatementInvalid: Mysql::Error: Unknown column
''lexemes.ref_id'' in ''field list'':
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
Activ...
2013 Oct 08
4
'puppet storeconfigs export' killed
...amined: 12712154 Rows_affected: 0 Rows_read: 18446744073709551613
# 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, `resou...
2006 Jul 04
13
NewBie question
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
2006 Mar 15
8
Tags to ruby interface: What I am missing? (repost)
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:
2010 Jul 08
25
Prepared SQL statements
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