similar to: Like Query Across Multiple Tables

Hello all and thank you for reading this message. I am new to RoR, and ruby too, but i am quite excited about it. I am developing a RoR project and with active record associations in the following manner # Tables (all tables have only one record) CREATE TABLE `webcars_development`.`cars` ( `id` int(11) NOT NULL auto_increment, `model_id` int(11) NOT NULL default ''0'',

I have a model, listings. Listings habtm categories and subcategories, which are seperate models. What I want to do is search categories for certain items, like so: @categories = Category.find(:all, :conditions => ["name LIKE ?", "#%{:search_string}%" and subcategories for the same: @subcategories = Subcategory.find(:all, :conditions => ["name LIKE ?",

Hi, currently I execute 2-3 AJAX-Calls (located at the end of html-body) on loading the page. I run into problems now because they are executed parallel of course :) How can I garuantee that the Calls are executed when the page has loaded completely ? And, more interesing, how can I make one AJAX-Call start when the previous has completely finished ? I''ve read about Effect.Queues - is

OK, general question for the community -- what''s the coolest startup using Rails? I don''t think "37 Signals" is a fair answer. I''m curious as to what kind of other developments are happening. Are there a lot of startups using Rails in the first place? Or do most of you who are lucky enough to do Rails for a living (I''m coding Java, bleah) work in large

I was recently having problems accessing attributes in an object. Can somebody explain to me why this is, and if it is a bug? I have the following code: @archives = RapturePost.find_by_sql "select distinct date_format(rapture_posts.date_created,''%Y-%m'') date_created from rapture_posts where rapture_posts.site_id = 1 order by rapture_posts.date_created desc" I

Any success stories using rails against a DB2 database on an as400? If so, how? Thanks Ed Schechter -- Posted via http://www.ruby-forum.com/.

Hi All Not specifically a scriptaculous question, but I was wondering how people were going about maintaining access to their applications via standard urls. Say for example I''ve a shop at www.shop.com, and its pure ajax to load in products. Now customer A wants to show a friend a product on the site - giving him the url www.shop.com and telling him to click on a series of links

I am using acts_as_taggable in my application and on the tagging side of things, no problem at all. Running edge Rails and PostgreSQL 8.1. I am then trying to find all my AR objects with a certain tag. The tag is: lasvegas and I know that there are at least 3 records with that tag. So, I''m doing this: @lists = List.find_tagged_with :any => @search_string, :separator =>

Here''s the scenario. I have a main tree-like table (actually it''s more of a hierarchy), where the entries (or at least some of them) can be categorised as one or more of a fixed number of types (prob about 6 poss types). So an entry could be a Type A and a Type D; a Type C, D, E; just a Type F; etc. Having a join table would seem like it might get rather expensive since

Hello everyone, Recently Nathan March reported on centos-virt list he's getting frequent Linux kernel crashes with Linux 4.9 LTS kernel because of the missing patch "tty: Fix ldisc crash on reopened tty". The patch was already merged upstream here: https://git.kernel.org/pub/scm/linux/kernel/git/torvalds/linux.git/commit/?id=71472fa9c52b1da27663c275d416d8654b905f05 but then

Somebody suggested SmallCap and that sounds great. This is by no stretch of the imagination Capistrano, so it might better be named MicroCap but it may be useful to some who have (as I do) modest needs in this regard, especially for on-server versioning. Here''s a preview of the usage: Usage: ruby smallcap.rb [options] -s, --server=SERVER Copies app to specified

Hi, I have a problem with the form select. In the value field I have the generated html... <%= f.select :brand_id, options_for_select([[''Brands'', 0]] + @search_brands.map { |b| [b.name, b.id]}), {:id => ''cbxBrand'', :tabindex => (@tabindex += 1)} %> This is the html: <select name="search[brand_id]"

Hello, Is it possible to trigger an action in a controller when a table from database changes? I thought about using an utility like cron (railscron) to check every, e.g. 2 s, if the table changed, but I am wondering if there is a solution a bit more ''elegant'': to trigger an action exactly when the change is made. Best regards, -- Kuba Nowak

I''m trying to implement a basic name search on a People table with separate first_name and last_name columns. I am using the will_paginate plugin and have the following search method in the model: def self.search(search, page) paginate :page => page, :conditions => ["lower(last_name) like ? or lower(first_name) like ?",

Hi. I would like to do code refactoring: @beers = [] Beer.all.each do |beer| unless @beers.find{|c| c.brand_id == beer.brand_id} @beers << beer end break if @beers.size > 29 end So I achieved this by writing scope (on PostgreSQL): scope :with_unique_brand, select("DISTINCT ON (beers.brand_id) beers.*") Using this scope alone is working

I have a model Product with an attribute ''brand''. Currently it is a simple attribute, however, I am migrating it to a separate model Brand so that I can have other attributes with each brand. I created the the model and created and ran the migration to create the new table. So far so good. Then I created a separate migration to transfer the data. The up method

is there anybody who knows how we can get child values using libxml (Reader class) def xml_import_to_brands require''xml'' reader = XML::Reader.file(''c:/brands.xml'') . . .

Hello. Is it possible to update multiple DIVs during? For example I have DIV for @flash[:notice], and one for content and I need to render both DIVs after executing action.

Guys, I understand the logic behind using image_tag in rhtml to maintain app portability, but how do you link to images in a stylesheet maintaining that same portability? Thanks for your help! B.A. -- B.A. Baracus: I thought you weren''t crazy no more? Murdock: Only on paper. -- Posted with http://DevLists.com. Sign up and save your mailbox.

I want to send myself an email when someone comments on my site. I setup actionmailer in the environment.rb file, but how do I actually send an email? Is it right after "post.save" or something? If so, what''s the syntax? Thanks for any help. -- Posted via http://www.ruby-forum.com/.