similar to: use of SET command in find_by_sql

Hello, AV::paginate query first by a count, how access this value in the controller or view ? Why ? Because I''ll like to display the total number or records found w/o doing another expenssive Count. Thanks,

Quick question to see how I might re-sort an Activerecord data set. Let''s say I have this table: tablename: testscores | id | student | score | avg_for_year 1, steve, 85, 82 2, tom, 84, 92, 3, jim, 92, 95 In my controller, I have something like: t= Testscores.find(:all, :order => "score DESC", :limit => 2) ...where it would return the records for Jim and Steve.... My

I was trying to do SUM based mySQL query simliar to the following: SELECT SUM(updated_on - created_on) AS total from signups If I were to run this command in the mySQL console I would get a result. However, if I were to run it using the following command in Rails: Signup.find_by_sql("SELECT SUM(updated_on - created_on) AS total from signups") The query that is written to the log is:

Dears, Got a controller witch do a send_data for displaying a chart. like : send_data(g.to_blob, :filename => "any.png", :type => ''image/png'', :disposition=> ''inline'') I actually do a <img src="http://myhost:3000/stats/make_graph" /> Is there any way more clean to do that ? At minima don''t hardcode the beginning

Hi folks. I have a very small problem which is probably very simple. But I''ve scoured the api and the rails book with no luck. I''m trying to get information about the database definition out of active record. When I go into console and say ActiveRecord::Base.connection I get a MysqlAdapter object, with an instance variable called @config that''s a hash containing all

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

Dears, My railsapp run using ''/layout/application.rhtml'' and under some conditions ( Authenticated user, url parameter) I like to switch globally to another layout, let''s say custom.rhtml Like : class AppController < ApplicationController before_filter :context_layout def index end end # application.rb def context_layout if <context_condition>

Dears, [Rails 1.0.0] I''m working with a legacy schema, and around my 20+ models i''ve used some AR constructs. They are based on a finder_sql doing some dirty sql and using #{id} from the ''pivot'' model for extracting data in other tables. like : class Division < ActiveRecord::Base set_table_name "legacy_division" set_primary_key

I work at an organization that is very wrapped up in Microsoft products. I am trying to get a test application put in however I''m not sure what to do about the infratstructure. If it were up to me we would put in MySQL and Apache or Lighty, however its not up to me. The easiest way to get an application into production at our company would be to use the existing MS SQL server and IIS

I just spent the last two days trying to get Rails on IIS to work with Windows 2003/IIS 6.0. I think I''ve finally got it working, but it took more googling than I care to describe. Now I''ve got a few questions: 1) Is there some ''official'' Rails on IIS guide on this site on another official ruby site that''s known to work well? 2) If not, can someone

Interesting read...apologies if it has been posted already. http://www.oracle.com/technology/pub/articles/saternos-rails.html -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060706/619e650a/attachment.html

Dears, My Ror setup works.. but I can''t guess why <%= stylesheet_link_tag ''style'' , :media=> ''screen''%> is rended as <link href="/stylesheets/style.css?1154009736" media="screen" rel="Stylesheet" type="text/css" /> What is that number.. any usage ?? Or I misconfigured something ? Thanks

This must be really simple but I have looked everywhere. I have a <%= item.description -% in my view and I want to trim it to 10 words. The description can be long and I want to trim this in my preview? -- Posted via http://www.ruby-forum.com/.

the compiler tell me it: invalid column name: INSERT INTO ago.prova_stats (cognome, nome, id, telefono) VALUES(''Medda'', ''Ivan'', :id, 70565611) where ago.prova_stats is the table used by me and that have only the columns ''cognome'',''nome'' and ''telefono''. My table hasn''t the column

Dears, For obscure reasons I''ll like to reset a session key when request/action is outside a specific controller. Is there a common place in the app where I can put such code, instead of adding statements in each controllers ? DRY Thanks, Mathieu

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''m trying to install mod_fastcgi for my rails app. I use Apache 2.2 and FastCGI 2.4.2 in windows xp. I have modified the httpd.conf adding LoadModule fastcgi_module modules/mod_fastcgi.dll (with mod_fastcgi.dll and mod_fastcgi.so in the modules directory). Whe i try to start Apache i have this error ---------------------------- apache: Syntax error on line 122 of

I would like to have a table with flexible columns. For example i have the following table customers: id name email The user should be able to save other columns to the database as well : me = Customer.find(10) me.name = ''me company'' me.email = ''me-RPlE4GnVVoJHoQZOM9yvow@public.gmane.org'' me.msn = ''me1234'' # custom columns me.birthdate =

Greetings! I could really use some help understanding what Rails puts into the session store related to the objects it creates. I''ve found documentation on how _I_ can put / get info into it, but can''t find the docs on what _Rails_ puts into it. I''ve got a simple app that collects some data from the user, stores it in a db record, allows the user to edit it, display

Dears, What is this software runned as "e" showed on most Rails Videos and providing a tree browser (explorer) and editor ? Avail for Linux ? Gretz -- Mathieu