Displaying 5 results from an estimated 5 matches for "skill_id".
2006 May 20
3
In a find, can''t you use both :include and :limit ?
...Employee table <-> Skills_Employees table <-> Skills table
Let''s say I want to find all the employees who have skill with ID = 3
(''axemanship'').
The actual SQL might be:
SELECT * FROM employee, employees_skills es
WHERE
es.employee_id = employee.id
AND
es.skill_id = 3
In Rails, I figured out that the right way to do that *may* be:
employees = 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.`t...
2008 Jan 12
1
Collection_Select not showing Selected option
...debug results for CallDriver
--- &id001 !ruby/object:CallDriver
attributes:
name: Billing (TV)
segment_id: "1"
platform_id: "1"
updated_at:
product_line_id: "3"
id: "2"
sub_product_line_id: "7"
consolidation_id: "1"
skill_id: "1"
created_at: 2008-01-10 20:04:04
attributes_cache: {}
Debug results for ProductLine;
- !ruby/object:ProductLine
attributes:
name: RHP
updated_at:
id: "1"
created_at: 2008-01-09 20:16:56
attributes_cache: {}
- !ruby/object:ProductLine
attributes:...
2006 Jun 11
2
HABTM Duplicates?
Hello all,
I''m working on a small Rails site for a game I play that will
be used to add new characters. Part of this addition process is choosing what
skills the character will have. For this, in MySQL, I have a characters table
and a skills table, as well as a characters_skills table that is used as the
join table in the habtm relationship between the two. I am presenting the
skills in
2008 Jan 08
1
Need input on DB/table design
I''m building a site.. Dah!! and it requires different skills for
different jobs in different states. the site will start off in only
one state but I want to make sure I''m ready for many states. I''m
thinking of a generic skills table with columns skill1 .... skillN.
then another table with columns state, job type, skill name, skill
column mapping to the column in the
2006 Mar 29
2
delete_all not resetting auto incement in database
Hey
I''m writing a simple admin interface thats reading user data (skills)
from a comma separated file.
To clear the database before inserting new skills, I use
Skill.delete_all
Then I insert the new values I read from a file. Everything goes well
up to the point where I see that auto-generated ID''s are not starting
from 1. They start off at 840 (responding to the number of