God, I'm so sorry. I found the problem, deep, deep in my code in a
place I never would have thought. Thanks for your patience. -Janna

On Jun 3, 4:22 am, "Sergio Cambra .:: entreCables S.L. ::."
<[email protected]> wrote:
> On Martes, 2 de Junio de 2009 17:14:16 JannaB escribió:
>
> > This is really melting down on me now, and I am too deep into AS on
> > this project to go another route.
>
> > Every table in my db has an int field 'deleted' which, if nonzero,
> > means that record is deleted. Thus, in my ApplicationController, I
> > have:
>
> >  def conditions_for_collection
> >       ['deleted = 0']
> >   end
>
> You can use acts_as_paranoid instead of adding a . I think you will get less
> problems.
>
>
>
>
>
> > Per your instructions here (maybe I did it wrong) I have:
>
> > 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 -- I have no idea at all how this can be coming
> > out of AS.....is it me? Am I doing something really stupid here -- or
> > is there a problem with AS? -Janna
>
> I would need debug your application to find the problem (bug in ActiveScaffold
> or your app, I don't know).
>
>
>
>
>
> > ctionView::TemplateError (Mysql::Error: Unknown column
> > 'statuses.deleted' in 'where clause': SELECT count(*) AS count_all
> > FROM `origins` WHERE ((statuses.deleted != 0)) ) on line #8 of vendor/
> > plugins/active_scaffold/frontends/default/views/
> > _form_association_footer.html.erb:
> > 5:   remote_controller = nil
> > 6: end
> > 7:
> > 8: show_add_existing = (!column.through_association? and
> > options_for_association_count(column.association) > 0)
> > 9:
> > 10: show_add_new = !column.through_association? and
> > (column.plural_association? or (column.singular_association? and not
> > associated.empty?))
> > 11: show_add_new = false unless @record.class.authorized_for?(:action
> > => :create)
>
> >     vendor/plugins/active_scaffold/frontends/default/views/
> > _form_association_footer.html.erb:8
> >     vendor/plugins/active_scaffold/frontends/default/views/
> > _horizontal_subform.html.erb:19
> >     vendor/plugins/active_scaffold/frontends/default/views/
> > _form_association.html.erb:18
> >     vendor/plugins/active_scaffold/frontends/default/views/
> > _form.html.erb:10
> >     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 (406.0ms)
> > Rendered rescues/_request_and_response (0.0ms)
> > Rendering rescues/layout (internal_server_error)
>
> > On Jun 2, 10:54 am, "Sergio Cambra .:: entreCables S.L. ::."
>
> > <[email protected]> wrote:
> > > On Martes, 2 de Junio de 2009 16:38:23 JannaB escribió:
> > > > Mr Banabas, No, that doesn;t do anything here. That just leaves me now
> > > > with a text field to input an integer. If I do
> > > >  config.columns[:status_id].form_ui = :select
> > > > if at least gives me a select box (though, there are no values in it)
>
> > > Probably you have removed status from config.columns, and added status_id
> > > to config.columns
> > > But you must use config.columns[:status].form_ui = :select, you mustn't
> > > use the foreign keys in config.columns
>
> > > > On Jun 2, 10:17 am, "[email protected]"
>
> > > > <[email protected]> wrote:
> > > > > I would give the following a try:
> > > > > config.columns[:status].form_ui = :select
>
> > > > > On Jun 2, 3:23 pm, JannaB <[email protected]> wrote:
> > > > > > I have the following models:
>
> > > > > > class Status < ActiveRecord::Base
> > > > > >    has_many :customers
> > > > > > end
>
> > > > > > class Customer < ActiveRecord::Base
> > > > > >   belongs_to :status
> > > > > > end
>
> > > > > > Then, in :
>
> > > > > > class CustomersController < ApplicationController
> > > > > >   before_filter :require_associate
>
> > > > > >   active_scaffold :customer do |config|
> > > > > >        config.columns[:status_id].form_ui = :select
> > > > > > ...
> > > > > > end
>
> > > > > > And I never get the select. Not for the status_id. or the id's into
> > > > > > any other tables. I have also tried ui_type, and again, nothing.
>
> > > > > > Am I doing something blatantly wrong that I cannot seem to get this
> > > > > > to work? Thanks, Janna
>
> > > --
> > > Sergio Cambra .:: entreCables S.L. ::.
> > > Nicolás Guillén 6, locales 2 y 3. 50.018 Zaragoza
> > > T) 902 021 404 F) 976 52 98 07 E) [email protected]
>
> --
> Sergio Cambra .:: entreCables S.L. ::.
> Nicolás Guillén 6, locales 2 y 3. 50.018 Zaragoza
> T) 902 021 404 F) 976 52 98 07 E) [email protected]
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to