On Fri, Aug 6, 2010 at 10:52 AM, Tomasz Romanowski <[email protected]> wrote: > I'm trying to work with an existing Oracle schema which of course does > not follow the Rails conventions for table/column names or primary key > types. I used Scaffold to get everything going. I got the table name and > the column names set up and I can retrieve the records correctly. > However I cannot get the RESTful URLs to work, for Show or Edit. I > nailed it down to the issue with the identifier not being numeric. When > I update the primary key column - which is VARCHAR2(32) - to contain > integers then all URL issues disappear and I am able to Show, Edit and > Update. But when I fall back the original values I get "XXX_url failed > to generate..." errors.
Without any code, it's hard to say. However, I have a legacy DB I'm working with that has an alphanumeric primary key, where the model includes: set_primary_key "product" # e.g. "E70211A" and this link generates an appropriate path: <%= link_to product.product_name, product_path(product.product) %> HTH, -- Hassan Schroeder ------------------------ [email protected] twitter: @hassan -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

