Displaying 3 results from an estimated 3 matches for "appointment_id".
2008 Sep 02
5
Appending a record to a table
Hi
I''m not too sure how best to explain this but here goes!
I am trying to write an appointment system. I have, through example,
just about got the dynamics correct. Even tried to play with some
table joins (and excuse me if I''ve used the incorrect terminlogy). But
no matter what I try I can''t seem to get the following code to work.
I have a cart filled with Treatment
2006 Jan 10
0
Day.find_all_with_appointments - INNER JOIN
.../simpler way to code an inner join, than the 4 lines below:
class Day < Foo
def self.find_all_with_appointments (*args)
find :all,
{ :select => ''distinct foos.*'',
:joins => ''INNER JOIN appointments ON days.appointment_id
= foos.id''
}.merge (extract_options_from_args!(args))
end
has_many :results , :class_name => "Result", :foreign_key
=> "event_id"
end
:include doesn''t help here, as it produces an outer join.
Alain
2009 Feb 25
3
Saving rich text to the database
...* FROM `users` WHERE
(`users`.`id` = 4) [0m
[4;36;1mInstruction Columns (0.003000) [0m [0;1mSHOW FIELDS FROM
`instructions` [0m
[4;35;1mSQL (0.000000) [0m [0mBEGIN [0m
[4;36;1mInstruction Create (0.000000) [0m [0;1mINSERT INTO
`instructions` (`start_day`, `title`, `description`, `appointment_id`,
`frequency`) VALUES(NULL, NULL, ''first\nsecond\nthird'', NULL, NULL)
[0m
[4;35;1mSQL (0.063000) [0m [0mCOMMIT [0m
NoMethodError (You have a nil object when you didn''t expect it!
The error occurred while evaluating nil.call):
How do I go about saving text from t...