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.

Reply via email to