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 + '':''