I want all the "convenios" that don't have been requested by a particular user.
On 12 nov, 08:49, Colin Law <[email protected]> wrote: > On 11 November 2010 21:53, Ich <[email protected]> wrote: > > > I have these sql code in postgresql > > "SELECT * from convenios where id NOT IN > > (SELECT convenio_id from solicituds where usuario_id=?" > > That does not look like valid sql to me. Can you explain in words > what you are trying to achieve? I find this is often the best way of > working out how to code something. > > Colin > > > > > but don't find a way of used it in rails > > except > > find_by_sql. > > > There is a another way?? > > > class Usuario < ActiveRecord::Base > > belongs_to :persona > > has_many :solicituds, :dependent => :destroy > > has_many :convenios, :through => :solicituds > > has_many :nivelesacceso > > has_one :nomina > > end > > > class Convenio < ActiveRecord::Base > > has_many :solicituds, :dependent => :destroy > > has_many :personas, :through => :solicituds > > validates_presence_of :nombre, :serie, :descripcion > > validates_uniqueness_of :serie > > validates_format_of :serie, :with => /cci|cue/ > > validates_length_of :serie, :is => 8 > > end > > > class Solicitud < ActiveRecord::Base > > belongs_to :convenio > > belongs_to :usuario > > end > > > -- > > 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 > > athttp://groups.google.com/group/rubyonrails-talk?hl=en. -- 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.
