Is that from your conditions_for_collection on your status controller? I seem to recall you saying something earlier about having a deleted column where anything other than 0 means that column has been deleted (or was that someone else)?
Carl On Tue, Jun 2, 2009 at 11:28 AM, JannaB <[email protected]> wrote: > > I have a Model, Customers. And Customer: > belongs_to :status > belongs_to :origin > belongs_to :associate > has_and_belongs_to_many :associates, :join_table => > 'splits', :foreign_key => 'customer_id', :association_foreign_key => > 'associate_id' > > Each of the models status, origin and associate: > has_many :customers > > My CustomersController is very straightforward: > CustomersController < ApplicationController > > active_scaffold :customer do |config| > config.label = "Customers" > config.columns = > [:lastname, :firstname, :middlename, :status, :origin, :associate] > #list.columns.exclude :comments > config.columns[:status].form_ui = :select > #config.columns[:origin].form_ui = :select > #config.columns[:associate].form_ui = :select > end > > When I go to perform a "create" on an empty Customers table (which has > fields staus_id, origin_id and associates_id) I am getting the > following stack trace -- my question thus is where in AS is the > "statuses.deleted != 0" coming from in this??? Where does AS pick THAT > up from?? Thanks, Janna > > ActionView::TemplateError (Mysql::Error: Unknown column > 'statuses.deleted' in 'where clause': SELECT * FROM `origins` WHERE > ((statuses.deleted != 0)) ) on line #7 of vendor/plugins/ > active_scaffold/frontends/default/views/_form_attribute.html.erb: > 4: <label for="<%= active_scaffold_input_options(column, scope) > [:id] %>"><%= column.label %></label> > 5: </dt> > 6: <dd> > 7: <%= active_scaffold_input_for column, scope %> > 8: <% if column.description -%> > 9: <span class="description"><%= column.description %></span> > 10: <% end -%> > > vendor/plugins/active_scaffold/frontends/default/views/ > _form_attribute.html.erb:7 > vendor/plugins/active_scaffold/frontends/default/views/ > _form.html.erb:14 > vendor/plugins/active_scaffold/frontends/default/views/ > _form.html.erb:2 > vendor/plugins/active_scaffold/frontends/default/views/ > _create_form.html.erb:38 > > Rendered rescues/_trace (906.0ms) > Rendered rescues/_request_and_response (0.0ms) > Rendering rescues/layout (internal_server_error) > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "ActiveScaffold : Ruby on Rails plugin" 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/activescaffold?hl=en -~----------~----~----~----~------~----~------~--~---
