similar to: Using active record for SELECT MAX(column) FROM ...

I would like to create 15 box plots from two sets of data. Set1 - containts PayGrade, Min_Salary, Max_Salary data for 15 pay grades Set2 - contains PayGrade, Actual_Min, Actual_Max, and Actual_Mean for the 15 pay grades I would like 15 box plots (one for each paygrade) whose whiskers were the Min_Salary and Max_Salary data and whose ''box'' was Actual_Min, Actual_Mean,

Easy one: Let''s say I have a table called ''employees'' with a column called salaries, how can I add Employee.salaries_total to the model? Thanks! -- Posted via http://www.ruby-forum.com/.

Hi all! I am quite new to rails, and I would like to know if there is a tutorial, or if someone can tell me how to use rails with stored procedures and views. Any help would be appreciated. Thanks to all -- ------------------------------------------- Gioachino Bartolotta

I'm working on the across the subprogram call optimization, and let's say the following llvm IR, @ng0 = internal global [2 x i32] [i32 2, i32 0], align 4 %t7 = alloca [16 x i8], align 16 %add.ptr = getelementptr inbounds i8* %t1, i64 40 %call = call i8* @handle_value(i8* %add.ptr, i32 3) #3 %arraydecay = getelementptr inbounds [8 x i8]* %t3, i64 0, i64 0 %arraydecay1 =

Hi, I just moved from 1.08 to 1.10 and now have one example failing, which, under 1.08, passed. Is the due to a change in behaviour? Here''s my spec (removed some passing examples) require File.dirname(__FILE__) + ''/../spec_helper'' describe "A user" do before(:each) do @user = User.new @valid_user = User.new( :email =>

Hi, I''m looking to create a ruby script that loads a bunch of records and manipulates these. Where do I start? I got this to begin with: #!/usr/bin/env ruby require File.dirname(__FILE__) + ''/../config/boot'' players = Player.find :all But it complains about a DB connection. How do I set this up? Jeroen

To Whom It May Concern: I have an ActiveRecord-based application (non-Rails). Life was grand until I upgraded ActiveRecord yesterday, after which point I was getting TONNES of these errors from my app and in PostgreSQL''s logs: FATAL: terminating connection due to administrator command According to Google searching, this happens when an external process sends PostgreSQL SIGINT or

Hi, Just thought it was weird that Ruby doesn''t automatically cast ints to floats. Seems so un-rubyish irb(main):006:0> 12/16 => 0 irb(main):007:0> 12.to_f / 16.to_f => 0.75 Jeroen

I have some legacy tables that I used set_table_name on, I''m attempting to write a method that will get key value from a sequence table and then update it and return a value. I''m hoping to put this in the base ActiveRecord method so I would like to reference the table name with self.table_name or something... class Contacts < ActiveRecord::Base set_table_name

Hi, Whenever I restart mongrel on my production server, the first request in my browser always fails, I get this error: Processing Base#index (for 83.xx.xx.xx at 2006-09-03 16:08:47) [GET] Session ID: f1918346d193e19a70c3230286e5ce1a Parameters: {} TypeError (superclass mismatch for class Stats): /app/models/stats.rb:1 stats.rb:1 just contains a normal A/R line: class Stats <

Hi, I recently bought by first Mac and I''m looking for some alternatives for my windows applications. Does anybody know a decent gui admin app for postgresql? On windows I use postgresql manager: http://www.sqlmanager.net/en/products/postgresql/manager I find this a very good piece of software and it''s free, even though I paid a little for some extra features. I''d

A couple of questions please: What is the benefit of having more than one Mongrel/Rails instance on the same machine, could one instance not serve as many requests as say three instances? Is Mongrel Cluster a Apache add-in (like mod_*) or a separately running load balancer which runs on a separate port, I could not work it out from the sample Apache config... |# Redirect all non-static

I have a log table which has a column recording the number of hours worked on a task. So there''ll be multiple lines for a particular task. I want to retrieve the total number of hours worked on a task, so that I can include the information when one views the task details. I can write a sql query to do this easily enough, like "SELECT SUM(hours) AS total FROM tasklog WHERE

Hi, Are there any recommendations as to what is currently the most stable setup is for mongrel & apache? I read somewhere (probably here) that you should avoid using PStore for sessions. Are there any more of such recommendations? Also, what is currently the safest version of mongrel to use in production? Jeroen

Hi, I wrote a little helper that calulates someone''s age based on his/her date of birth. def age(dob) diff = Date.today - dob age = (diff / 365.25).floor age.to_s end It works fine, but it''s not completely accurate as it just takes the average days in a year. It should be able to calculate this more accurately, right? I can''t work it out

Hello, I was wondering if there was a method in Rails that returns the sum of a column. For example, I have a column called ''score'' and writing a SQL statement such a ''select sum(score) from table_name'' does return the sum of the values in the column. In the past (not too long ago being a newbie), I defined all sorts of methods only to discover that Rails

Hi, Is there a way to test if a certain (local) variable has been initialized? I''d like to do something like if isset(myvar) and myvar.true? #some code else #default behaviour end I have a lot of shared views that I call with params such as { show_pager => true Instead of having to explicitly say show_pager => false it should be possible to make false a default value, right?

Hi, Disclaimer: I''m pretty sure this isn''t a mongrel issue, as I''m pretty sure I had the same problem back in the lighty-fastcgi days.. After a postgres restart, my rails apps crash with this error: ActiveRecord::StatementInvalid (PGError: FATAL: terminating connection due to a dministrator command server closed the connection unexpectedly This probably

Hi, I''m trying to include a partial in an email template but it throws me this: undefined method `controller_path'' for SupportMailer:Class Extracted source (around line #12): 11: 12: <%= render :partial => ''footer'' %> I guess email views are a little different from normal ones as they don''t seem to have a access to a proper controller (?)

I''m sure this has been asked before but a quick search on the web didn''t give me any hints.. I''d like to do this: @person = Person.find_by_name throw_page_not_found unless @person Anybody know how to do this, do I have to manually tinker with the response object? -- Posted via http://www.ruby-forum.com/.