Sign In/My Account | View Cart  

advertisement

AddThis Social Bookmark Button

Article:
  Rolling with Ruby on Rails Revisited
Subject:   is the code complete ?
Date:   2006-12-18 06:26:00
From:   bill_walton
Response to: is the code complete ?

Hi Will,


Much of Rails' magic requires transaction support which, in MySQL, is only available via the InnoDB engine. From the MySQL developer documentation (http://dev.mysql.com/doc/refman/4.1/en/create-table.html ) "In MySQL 3.23.44 or later, InnoDB tables support checking of foreign key constraints. [...] For other storage engines, MySQL Server parses and ignores the FOREIGN KEY and REFERENCES syntax in CREATE TABLE statements."


Best regards,
Bill

Full Threads Oldest First

Showing messages 1 through 3 of 3.

  • is the code complete ?
    2007-07-10 13:38:15  RaagSrinivasan [View]

    Bill,

    I am not sure I understood your comment in the sense; as a developer what am I supposed to do to get over the tutorial not working?

    Would you recommend that I change the SQL to
    -- category_id int null,
    which naturally solves the problem??

    Ruby and Rails Newbie
    -- Raag
    • is the code complete ?
      2007-07-11 05:57:47  Bill Walton | [View]

      Hi Raag,

      I'm sorry you're having a problem. This section of the feedback got a little tangled, but if you take a look at my reply a few items above, dated 2006-12-20 at 13:49:02, I think you'll find what you're looking for. Basically, the tutorial doesn't tell you to do what you're trying to do. Unfortunately, I didn't explicitly tell you not to do it either. Your code's not broken. It's just not complete for what you're trying to do. It becomes complete in Part 2.

      Best regards,
      Bill
      • is the code complete ?
        2007-07-12 14:32:45  RaagSrinivasan [View]

        Thank you and a very nice tutorial.

        -- Raag