search for: relashinship

Displaying 9 results from an estimated 9 matches for "relashinship".

2006 Jul 03
6
help!
...rst, but i''m getting really caught up in trying to understand this and the docs aren''t giving me answer. i actually thought i knew how the sql commands work (like :include, :conditions, :etc) but obviously, i don''t. there are three models M1, M2, M3 joined by a habtam relashinship of M1 has_and_belongs_to_many M2 M2 has_and_belongs_to_many M1 M2 has_and_belongs_to_many M3 M3 has_and_belongs_to_many M2 and a MyController which is the backbone of the site. (although i haven''t specified exactly {model :M1} or something like that in the controller, but as far as i k...
2006 Jul 02
2
searchbar help!
Hi all, i am after hours unfold of trying to implement a searchbar in a table with a habtam relashinship, but alas ! with no success... i was hoping some kind gentle mind can help me through these diffucult times; i have now reached the point where out of sheer annoyance, i cannot see myself getting anywhere nearer to the target, and was hopefully hoping one of you out there could help me out.. s...
2006 Jul 10
9
ROR questions
Hi, ? I''m a Ruby on Rails newbie.? I''ve been tasked with building our office''s first ROR application, and I am the only one working on it, so I am muddling through with a couple of books...? Moving along slowly but need some discussion time with some people who KNOW it and can maybe offer some answers to questions I haven''t found in my books. ? First - what is
2006 Jul 10
4
find()
Can some1 help me on syntax with the find() function. I''m trying to pull up a table record, called chart, that has a particular field specified. ie chart has a field called record_id, which i know. How can i find the record that contains chart.record_id. something like chart = Chart.find(:conditions => "record_id = :id") this gives me an error. I''m passing
2006 Jul 18
5
Newbie RoR question
I am currently working on a small database project to track company assets. Right now my Database consists of 3 tables. 1 for the equipment, 1 for the users info, and 1 for the type of equipment. I have all 3 databases working on a model test site using RoR. Where i am having trouble is getting the databases to talk together. I can''t find this answer anywhere else. My main table
2006 Jul 02
18
JOIN conditions
Hi, how can I get Rails to generate SQL queries with conditions in the JOIN clause? What I would want is: SELECT * FROM people p LEFT OUTER JOIN jobs j (p.job_id = j.id AND j.salary > 9999999) I tried People.find(:all, :include => ''jobs'', :conditions => ''jobs.salary > 9999999'') but that generates SELECT * FROM people p LEFT OUTER
2006 Jun 29
1
search action/ in different groups
Hi all, thanks in advance for those who''ll take the time to help out... i have a list of users who are connected with a habtam relashinship to a set of groups (joint table of groups_users) and now am trying to implement a search operation that will go through all of the records of the users and output user results according to what group was chosen at the searchbar, and the text input(of the searchbar) basicly, it would be somethi...
2006 Jul 04
4
Please help me
Hi all, I''m getting the list of my projects in the page. But i want to get the list according the month, i.e., if i select july in the drop down then i should get the list of projects done in the month of july.. Please reply.. Regards, Harish -- Posted via http://www.ruby-forum.com/.
2006 Jun 29
7
sql question for rails
Hi, i was hoping someone could help me out with a small yet quite time-boggling task...i have a two tables users, groups joined in as a habtam relashinship (has and belongs to many) and i need to select from the mydb (mysql if it matters) users out of the User model, in accordance with TWO groups in one rails opperation to improve performance...basicly, say i have ten groups and ten users, and i wanted to take out seven(or whatever) of the ten use...