similar to: Rails generates query with reserved word for field name

I am using ruby 1.8.4 with rails 1.0 under fedora core 3 on a WIntel platform. Rails appears to be losing key information under some circumstances. Specifically, in the Questions class that follows, the presentation_id property is apparently being lost. The STDOUT dump from the create method indicates that the presentation_id should be 42, but the dump from the database shows that it is 43,

This has the look of a "just don''t quite get it yet" problem. I am using the ActiveRecord.find_by_id method to identify the parent object (Quiz) to tie to the child object (Question) at create time. Here is the stdout log: 127.0.0.1 - - [31/Mar/2006:22:43:22 CST] "GET /question/new? parent_quiz=ff2d7022-be0a-11da-9f01-00400506faf5 HTTP/1.1" 200 806

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:

Hi, I am thinking about how to best design a quiz site in RoR. I think it should be fairly easy, but have run into a wall. In the simplest form, the view would grab all of the questions for a particular quiz and display them (e.g. multiple choice, so 4 option buttons per question). However, I can''t figure out how to "mark" the quiz. The form is submitted to the

I would appreciate any and all input. The Agile book is not useful in this context. :o( As near as I can tell, it doesn''t work at all. I would expect that clicking on the [Next Question] button in the browser would fire the next_question method in the current controller. Instead, it (apparently) does nothing. The tag in question <%= submit_tag ''Next

I am building a relatively trivial application to try to learn my way around Rails. I am having difficulty understanding how to navigate a heavily denormalized hierarchy. Could someone direct me to a bare-bones explanation of using rails to navigate database hierarchies? I am an experienced developer. Most of my work has been desktop client server, high performance, or server to server

So I have the following model class Topic < ActiveRecord::Base belongs_to :topic has_many :topics, :order => :position acts_as_tree :order => :position acts_as_list :scope => :topic_id end that I use for a site''s navigation. Everything (list, create, edit, even the drag&drop sort) works fine, except the destroy function, which the vanilla version def destroy

Hi Railers, I''ve got a Categories table. I want it to act as a list within the scope of the parent_id AND the site_id. Categories table : id label site_id parent_id So, in my Category class, I have : acts_as_list :scope => ''site_id = #{site_id} AND parent_id = # {parent_id}'' The problem is that when I try to move_up a Category with a parent_id that is null,

It looks like I am missing something obvious. ActiveRecord is generating _really_ bad SQL for this configuration, and I can''t quite figure it out. I''ve instrumented ActiveRecord enough to localize the problem somewhat, and generally by this time I would have a good idea of what I was missing because it''s all in the source. It appears that something in

I need an ordered (sortable tree) and I just was thinking if somehting like this is possible: class Item< ActiveRecord::Base acts_as_tree :order => "position" acts_as_list :scope => ''parent_id = #{self.id}'' end For my understanding mixing of two acts_as should be p?ssible, at least in this case, right? Unfortunatly the :scope is not working, I am not

I just switched from using the standard "id" column into using my own primary key and generating my own unique id for each record. But, this breaks acts_as_tree. Because my new primary key is not an integer, it breaks the SQL query as follows: StatementInvalid in PagesController#create --------------------------------------------------------------------------------------

Hi, If I have a db table categories - id - name - parent_id - position is it alright to have the Category model act_as_tree and for each level act_as_list? class Category < ActiveRecord::Base acts_as_tree :order => :position acts_as_list :scope => :parent_id end Thanks, Peter

Thank you in advance. Although I have many years of experience in general, including cross- platform processing, I am not an HTML/Javascript programmer. As a result, I do not have certain specific baseline skills and/or knowledge that are presumed in the Rails and Ajax documentation. I am experienced with DOM manipulations, so the bare mechanics of manipulating the browser GUI via Javascript

I am creating a database for movies (films) and television shows (shows) that will have has_and_belongs_to_many relationships with the pictures table. CREATE TABLE screenshots ( id serial NOT NULL, filename character varying NOT NULL, content_type character varying NOT NULL, primary key (id) ); CREATE TABLE films ( id serial NOT NULL, name character varying NOT NULL,

I''m using UUIDs as keys into my database (stored as CHAR(36)), and additionally have a model that is set to act as a list. In this scenario, I believe that the queries that Acts::List generate are invalid, caused by IDs being strings rather than integers. System info: Rails: 1.1.4 MySQL: 4.0.26 This is the failing query: mysql> SELECT * FROM children WHERE (parent_id =

Hello, I''m wondering if there is any plan to leverage SQL92 INFORMATION_SCHEMA in ActiveRecord? In a nutshell, INFORMATION_SCHEMA provides the meta information necessary to automatically discover all the associations between objects (primary and foreign keys, has_many, has_one and belongs_to, etc). Most relational databases do support this SQL92 standard one way or another*:

I have a model "Childmodel" that belongs_to two other models "Parent1" and "Parent2". "Parent1" "has_many :childmodels, :order => :positionp1" and "Parent2" "has_many :childmodels, :order => :positionp2". i.e. The child is independently positioned within each of its parents. This works fine and gets me the useful

Hello all, I''m having trouble using acts_as_list with acts_as_tree to order the "children". I''ve found a few old posts on the web that seem to indicate that this once worked. class Whatever < ActiveRecord::Base acts_as_tree :order => :position acts_as_list :scope => :parent_id Although the ''position'' field is being populated, it appears

Railsriders: Quizmeister James Edward Gray II selected the best 25 Ruby Quizzes from last year, then carefully collected answers and annotated them. The result is "The Best of Ruby Quiz", a wonderful book which will teach any Ruby programmer new techniques and approaches to coding. If you want to hone your programming skills, stick to the front part of the book and enjoy

ovf:Envelope/Content/Section[xsi:type='ovf:OperatingSystemSection_Type']/@ovf:id is actually the canonical UUID of the guest, and must correspond to the filename. If it doesn't, the VM cannot be deleted from the export domain. Fixes RHBZ#583536 --- lib/Sys/VirtV2V/Target/RHEV.pm | 6 ++---- 1 files changed, 2 insertions(+), 4 deletions(-) diff --git