similar to: Searching ActiveRecord sets

Hey all, I''m just starting in rails and am working on my first app. I need to do inline editing for 2-15 rows of data on a page. I found Ajax Scaffolding here: http://www.ajaxscaffold.com/ And it is EXACTLY what I want in my app. But I''ve also been trying to read a bit up on RJS Templates. Are they basically the same things except RJS is built into rails or is the

I have some graphs and everything is working great, but I''d like to set a minimum height so to speak on the vertical scale. Is there a method to do that with Gruff? I''ve tried looking through the docs but can''t seem to get it to work. So for example, if the highest datapoint in my graph was say 500, is it possible to have the minimum vertical scale on the left set

I have an issue where I am getting a large number of records from the database and I cant afford to keep it in the memory due to performance issues. Therefore using the following would be ideal, User.find_each(:batch_size => 5000, :start => 2000) do |user| NewsLetter.weekly_deliver(user) end however, I would like to use find_by_sql since my query is user defined. Question is, is it

I know that Mongrel is a web server that hosts rails applications. But i don''t understand what part Lighttpd (or Apache) has in the setup. I know that you can use Mongrel on its own. What does Lighttpd improve on? Thanks, Chris -- Posted via http://www.ruby-forum.com/.

I''m playing around with the Practical Rails Projects code, and was attempting to make a change for graphing data differently using groupings. Basically the code went from: total_weight = @exercise.activities.collect {|e| e.repetitions * e.resistance} workout_dates = @exercise.activities.collect {|e| e.workout.date.to_s} To: total_weight =

Hi there, Is there a neat and easy way to implement pagination with letters rather than numbers eg : A B C D ... Z Rob

I have found various posts about instance variables, session variables and parameters (each of which seems to use differnet syntax and have different view on the "best practice") I would like to find a single, reliable source that provides a good overview on all of it. Specifically, I would like to learn how to pass parameters between controllers and how to set session variables so

Hi, I''m doing a find_by_sql and am getting an odd error when trying to render the result to xml. The find is: children_list = find_by_sql("SELECT components.componentid, components.logicalname, versions.level, versions.branch, versions.sequence FROM components, versions where components.componentid = ''" + component_id + "''" + " AND

I''ve got a publications table that contains an author_id foreign key and a pubrole_id foreign key. What I want to do is query the DB using AR so that I can get a list of all publications that belong_to a particular author, and group the results by the pubrole.role_name (Author, Joint Author, Editor, etc.) so that the results look something like: Author book1 info book2 info etc.

URLS: - http://raa.ruby-lang.org/project/arrayfields/ - http://www.codeforpeople.com/lib/ruby/arrayfields/ - http://rubyforge.org/projects/arrayfields/ SYNOPSIS: allow keyword access to arrays: require ''arrayfields'' fields = ''name'', ''age'' row = [ ''bob'', 30 ] row.fields = fields row[

Consider the following scenario: Book has_and_belong_to_many Category. In other words, a category may have a lot of books, and a book can have more than one category. What is the best practice to query all books related to some specified categories. For example, if I have following books "From Java To Ruby" - Category: Java, Ruby "Ruby Programming" - Category: Ruby

Hi, I''m having what I believe to be a typecast problem with ActiveRecord and Associations. In the code below, I need to flag a contact record for deletion if the contact doesn''t have any addresses or books records: sql = "select id, delete_flag from contacts where id = #{params[:id]}" contact = Contact.find_by_sql(sql) if (contact[0].addresses.count +

Hi There, I''m gettings the following errors while accessing my application. Can someone please tell what is the possible cause and can it be resolved. " ActiveRecord::StatementInvalid in Site#showalladdress Showing site/showalladdress.rhtml where line #3 raised: Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

Hello, I''m new to Ruby & Rails, and I''m trying to figure out if this behavior by ActiveRecord is by design, or if I''m doing something incorrectly. Here''s the deal: I have a class based on ActiveRecord::Base that defines a method that creates a query using find_by_sql(). The fields retrieved by joins with other tables are being returned as Strings,

I have models with large TEXT, BLOB columns and I don''t wanna fetch them everytime. Is it possible to omit columns when fetching records from DB? Sorry, if it''s trivial, but I can''t find helpful information in docs.

I''m wondering if this is a typical thing. What I''m doing is getting about 5000+ records from a database and displaying all of it on a page. I''ve used the benchmark helper to benchmark the views for that page and that takes about 25 seconds to render that view. Is this pretty typical? What I''m doing is using find_by_sql to get all the values that I need from

I have these sql code in postgresql "SELECT * from convenios where id NOT IN (SELECT convenio_id from solicituds where usuario_id=?" but don''t find a way of used it in rails except find_by_sql. There is a another way?? class Usuario < ActiveRecord::Base belongs_to :persona has_many :solicituds, :dependent => :destroy has_many :convenios, :through =>

Model: class AdminQueue < ActiveRecord::Base set_table_name ''adminqueue'' end Interacting with it in script/console >> AdminQueue.new => #<AdminQueue:0x240a910 @attributes={"topic_id"=>nil, "resolved"=>nil, "updated_on"=>nil, "action"=>nil, "type"=>nil, "post_id"=>nil,

Howdy. I''m trying to work with a legacy SQL Server database where some of the table names have spaces in them. I''ve done set_table_name "tablename with spaces", but I can''t get find(:all) to work. I get the following error (because apparently it''s not putting [ ] around the name as is required for SQL Server for names with spaces.

Hello to all, I ran into a weird problem with an ActivRecord. I have a table named "build_order" with a column named "type" that is a foreign key to a table called "building_type". In a controller I try to read all the build_orders with "BuildOrder.find :all" and get the following error and stack trace: (eval):1:in `instance_eval'': compile