similar to: find_by_sql and xml_serializer problems

Hi, Is there an easy way of querying an active record for a maximum column value? I need to do queries like: SELECT MAX(salary) FROM employees TIA, Jeroen

Does anyone have a Perl or PHP Icecast2 Status Page Parser? Thanks. -greg. __________________________________________________________________________ Greg J. Ogonowski VP Product Development ORBAN / CRL, Inc. 1525 Alvarado St. San Leandro, CA 94577 USA TEL +1 510 351-3500 FAX +1 510 351-0500 greg@orban.com http://www.orban.com

Hi all, i''m trying to email multiple people based on certain criteria. i do a search like @stacks = Group.find(:all, :conditions => ["component_id = ?", 2]) this populates stack to contain multiple groups with component_id =2. How do i populate @recipients to contain all possible @stack.email. Let me clearify. Each stack has its own email, and i need to include each

We want crossfading so we need to use the SQRSoft crossfading Winamp output plugin. Ross. Stefan Neufeind wrote: > If thats the problem, why didn't you mention that before? > http://classic.winamp.com/plugins/detail.jhtml?componentId=28451 Null Output Plugin Null Output Plugin allows to run WinAMP without need of any soundcard installed in the system. [...] On 10 Jun 2003 at 8:21,

Hi! I got a class named EinsatzFilter which I serialized to session. Before saving to session it works afterwards I keep getting the message: "undefined method `to_s'' for #<Person:0x38c6ab8>". "Person" is a from ActiveRecord::Base inherited class. Code: class EinsatzFilter include ApplicationHelper attr_reader :personen, :monat, :projekte, :kunde

Hi all, In my controller I am doing the following to populate a nested form for a has_many through association: def new @specification = Specification.new Component.find_each.each do |component| @specification.component_specifications.build(:component_id => component.id) end The idea being whenever someone creates or edits a form, it will be populated with all

> > I'd like to set up two streams, one for broadband users & one for modem > users > > (and I want them to be playing the same thing at the same time). Is this > > possible with Icecast 2 and Oddcast, or any other win32-compatible OGG > > software combination? > > > > Thank you! > > > Use Oddsocks' stream Transcoder to lower the bitrate

I''ve been unserializing XML in PHP with the XML_Serializer class, and I''m wondering if anyone knows of such a class for Ruby. Nothing fancy, just perhaps a simple way of converting arbitrary XML to a Ruby object. Maybe this has been implemented somewhere already? Thanks, Raymond

Hi all, I am getting ActiveRecord to produce XML with render :xml => @user.to_xml However, on the client end it is a bit annoying for me to deal with attributes like first-name. I would much rather have first_name. Is there any way for me to turn off the behavior of converting _ to -? This seems to be done by a call to dasherize inside the to_xml of

All, I have need of getting at some underlying database metadata for ActiveRecord descendants. Does anyone know if I can get access to the following attributes of the underlying column for a given ActiveRecord object: Is it a currency object? Is it nullable? Is it a signed int? Is it searchable? Column length Column name Column precision Column scale Column data type - how specific can I get

I am struggling to find the best way to set up relationships to achieve this so that it fits the rails idioms. I have a table of products and I want to be able to create a bill of materials for a product.. So a product can either be a single item, or a package consisting of several other products. I have created a table: ---- class BomItem < ActiveRecord::Base belongs_to :product

im my web server app , i have an action to be used as a REST web service # GET /user/membership.xml?email=emailaddress def membership @user = User.find_by_email(params[:email]) respond_to do |format| format.xml { render :xml => @user.to_xml( :only => [ :first_name, :last_name, :display_name, :membership_type, :membership_at], :skip_types => true)} end end my

I''ve gone once through the Agile book and am now attempting my own rails app. I''ve created a table named ''volunteers'' with over 15 columns. The problem is the default list.rhtml that is created with the scaffold, shows all the columns. I only want to show 4 of them with the list view. Where would I start to only return a handfull of columns to the

Hello, In my database, I have a table "products" with attributes : - id - title ->string - desc -> text I use active record, but I don''t know why recover the type of this attribute with active record? I try attributes_before_type_cast but I don''t see the type Can you help me? Excuse for my english (I''am a young student french) -- Posted via

Hopefully an easy one, how do I merge two or more SQL query results? Example: result1 = find_by_sql(x) result2 = find_by_sql(y) What is the best way to merge result1 and result2? I want to be able to reference the objects as if they were obtained via one query. Cheers, Dan

Hello-- There must be a better way to do this. I have a class method in my model that finds averages and does a few calculations using find_by_sql. The problem I¹m encountering is that all computed columns from MySQL come back as type string. E.g., def self.find_averages(domain_id) if @@domain_average return @@domain_average else @@domain_average =

I can''t see how to use variables so I am using console to test things out... clients table - a column named first_name My very brief console session... >> clients = Client.find_by_sql("select * from clients where first_name = FN") ActiveRecord::StatementInvalid: RuntimeError: ERROR C42703 Mcolumn "fn" does not exist Fparse_expr.c L1034

Hi, I''m trying to execute something like this method in a model: def self.sql_for_rankings() sql = "SET @counter:=0;" sql << " SET @counter:=0; SELECT *, @counter:=@counter+1 AS rank FROM testscores. " find_by_sql(sql) end Where the new rank column is a kind of autoincrementer inside of

I want to find out what are the associations with another active record class. So If my class is as below: Class Component < ActiveRecord::Base has_many :branches end class Branch < ActiveRecord::Base belongs_to :component end and then I do Component.reflections[:branches].active_record I would expect that to be Branch but it is in fact Component. The inspection of

Hello, I''m just starting out with some Rails development and have the following table structure. I understand how to do a two table has many join but I actually need to relate a third table. Here is my structure: components id name updated_at elements id name updated_at element_types id name updated_at components_elements component_id element_id