search for: appointment_id

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