similar to: Activerecord equivalent of the SQL "SUM()" function.

Displaying 20 results from an estimated 6000 matches similar to: "Activerecord equivalent of the SQL "SUM()" function."

2006 Mar 04
16
Unacceptibly slow.
I currently have a fairly simple Rails application running on FreeBSD under Apache 1.3 and normal CGI, and the performance I''m getting is alarmingly poor. I realize CGI or WebBrick are quite a bit slower than FastCGI, and I''ll probably use one of those instead when I have the time. However, I''m just curious if CGI is really supposed to be that slow, or if
2005 Dec 27
3
created_on & updated_on - helper to display date only
All, My initial list is rather busy. I would like to shorten the created_on and updated_on fields to just display the date, not the time. Best wold be a simple 12/28/05 type of presentation. I''ve found the format helpers in rdoc. (ie. distance_of_time_in_words_to_now ), but none seem to be what I''m looking for. How do I control the date format of a timestamp field? Thanks
2006 Jun 14
4
Using now() to determine what should be displayed
I''m trying to create a paginated list that will take note of the "end_date" field in my table. This is what I have: @post_pages, @posts = paginate(:posts, :per_page => 10, :order_by => ''end_date'') in the controller. And for the view: <h1>Posts ending soon</h1> <ul><% for post in @posts do %> <strong>Post Title:
2006 Jun 13
17
reconstituting a date
In my view code, I have <%= datetime_select "in_out", "time_in" %> which returns in params :in_out: !map:HashWithIndifferentAccess time_in(1i): "2006" time_in(2i): "6" time_in(3i): "12" time_in(4i): "20" time_in(5i): "24" and I want to save that datetime to a column in the db... if
2006 Jan 07
8
Using find_by_sql to get the sum of a column
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
2006 Feb 09
17
complicated finds are eating my sole
I abandoned ruby way for find_by_sql and still can''t get this... @myplacement = Placement.find_by_sql( "select * from placement where :intake_date >= beg_intake_date and :intake_date <= end_intake_date") just a simple date range...it''s killing me - If I knew how to load placement controller into irb, I could probably try out finds interactive mode... Thanks
2005 Aug 23
10
Creating a simple sum (or: I suck at blocks!)
I''ve been hacking on this for awhile and am not even getting close. Consider the following... results = Sample.find(:all) total_counter = results.each{|result| #Add together result.counter} I just want to simply iterate through the list and sum the counter field for each row into an aggregation. I could do it in a full for loop, but is there a nice one liner I''m missing?
2006 May 10
7
AJAX effects
I was at http://rails.techno-weenie.net/ and I like what ajax does when you click on "login" how can I do this on my own website? Is this with the defualt JS libary? -- Posted via http://www.ruby-forum.com/.
2006 Jan 13
2
Change Password with acts_as_authenticated
I want to have a form to change a users password. I can''t figure out what the method in the controller should look like. I tried @user.save and @user.update_attributes, but can''t get it to work. My Form: ############################## <%= start_form_tag :action => "update_password", :id => @user.id %> <%= password_field ("user",
2006 Feb 08
8
Liquid with database?
Hello, Just wondering if someone here as successfully ported Liquid to use with a database. I would like to try it out but not sure how Liquid integrates with current templates. Thanks Frank --------------------------------- Yahoo! Mail - Helps protect you from nasty viruses. -------------- next part -------------- An HTML attachment was scrubbed... URL:
2006 Aug 10
6
Login Restfully
In DHH''s keynote, he alluded to doing logins with REST. Has anyone implemented this, and if so, would you mind elaborating on how you did it please? Thanks in advance. -- Posted via http://www.ruby-forum.com/.
2007 May 08
2
Install plugin acts_as_auth.. no access to techno-weenie.net
please help me get this plugin installed... I have no access to techo-weenie.net due to a firewall blocking the weenie crap in its domain name. more specifically, i''m trying to do this: script/plugin install http://svn.techno-weenie.net/projects/plugins and it bombs. On a machine w/ access to this repository, I did an svn checkout and tar''d up the contents... then
2006 Mar 23
3
migrations: how to have all data dumped into rb ?
Hi, I dumped the schema using rake db_schema_dump. Now how do I create a migration containing all the data I have in my dev db ? -- Jean-Christophe Michel
2005 Dec 27
3
execution timeout
Hi! I have a rails action controller method which takes long time to complete. After about 4-5 minutes running, I get a "execution expired" error which stops this method''s execution. I looked and looked, searched and searched, but could not find how to configure my ActionController''s timeout to be greater than the default. Could anyone help? -- Posted via
2006 Mar 01
4
STI, subclasses and callbacks
I have a STI class tree. I want to set some default values (calculated values so I can''t set it in the database as defaults) on every created instance regardless of what subclass is actually instantiated. So I figured adding a after_create callback in the top class in the hierarchy should do the trick. It seems it doesn''t get called :( Code: class SuperClass <
2006 Jan 03
5
Are cache sweepers used?
After drawing many virtual blank stares in the IRC channel and finding zero results on the wiki for ''sweeper'' I''m left to wonder whether these are actually officially supported, or are on their way toward being deprecated. Is there a better way of expiring caches on model saves and deletions? Sincerely, Tom Lieber tom@alltom.com http://AllTom.com/
2006 Feb 14
10
acts_as_versioned and getting authors
Hey guys and gals, I have the following object that has acts_as_versioned: class Note < ActiveRecord::Base acts_as_versioned belongs_to :user end The schema for my notes table is as follows: create_table :notes, :force => true do |t| t.column :id, :integer t.column :noteshare_id, :integer t.column :user_id, :integer t.column :title, :string
2006 Nov 20
7
Acts as attachement
Hi guys Question about acts as attachment still getting the following error undefined method `content_type'' I have set everything up according to the following page however i am still have trouble http://weblog.techno-weenie.net/articles/acts_as_attachment One thing, I have wanted to add this to an existing model in my system. I have not used the... script/generate
2005 Dec 21
5
ajax - multiple updates on single xmlhttprequest
Hello, I was wondering whether anybody would share a working example of a multiple html update on a single xmlhttprequest. Thank you in advance for your help. _________________________________________________________________ On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement
2006 Mar 07
4
should a AR object be able to see backwards?
I have two models, Stop and Station, they relate one station to many stops. Stop has_one :station Station belongs_to :stop So I can do @station.stops, but I cant do @stop.station, is this right? For example in the view I have: <% for @stop in @stops %> <tr> <td><%= @stop.station.name %></td> <td><%= @stop.time.hour.to_s + '':''