similar to: Searching within active record results - ror n00b

I have a search form; I grab the value and use it in a fulltext query: :conditions => ["idxfti @@ ''" + search_string + "''::tsquery and ...........] Characters in search_string like "?", ":", bomb active record. I tried a single tick and "\" to escape those, but active record still bombs (same queries via psql work). Suggestions?

Hi, How do you use Tsearch2 in Rails? Petr -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to

I''m sure people have encountered this before, but I''ve been unsuccessful at finding anything about it. Basically, I got a rails app that uses postgres and tsearch2 for some full text indexing and I''d like to be performing unit tests. Now, there''s the whole deal of how to get the test database to load all the tsearch2 information properly. I tried to come up

So I''ve worked through Agile Web Development with Rails and I''m now trying my first little app to get into the swing of things. Its a task tracking app where people can create tasks and assign them to others, and also log time against the tasks. I''m having trouble working out the model relationships. This is what I''ve got so far, but its not right as

Hello List, I''m a bit spent on this problem, and my code might be whack. I seem to be encountering a problem where the primary key on a join table is not being resolved correctly. I will elaborate after some code bits. I am creating the join table using migrations, and relevant model code is this: class Post < ActiveRecord::Base has_and_belongs_to_many :records

I am creating a database for movies (films) and television shows (shows) that will have has_and_belongs_to_many relationships with the pictures table. CREATE TABLE screenshots ( id serial NOT NULL, filename character varying NOT NULL, content_type character varying NOT NULL, primary key (id) ); CREATE TABLE films ( id serial NOT NULL, name character varying NOT NULL,

I''m trying to set up a directional self-referential HABTM to represent an arbitrary semi-hierarchical structure; it works for any data prepopulated into the db, but when I try to create a new relationship, I just get NULLs in both key columns (or 0''s if I turn on the no-null constraint). Here are the migrations: class CreateNodes < ActiveRecord::Migration def self.up

I''m just getting used to using HABTM structures. Something I''m trying to do now is create a site that has "sections" each section then could have a sub "section". So I built a "sections" table and in the model I included the line "has_and_belongs_to_many :sections" I also made a table called "sections_sections" to build the

Hi I''m pretty much a newbie to Rails and I have at least two projects under development that are going to need the same type of constructs and I''m struggling to get my head around how to achieve what I want using Rails models and relationships. In one project I have a hierarchy of (geographical) sites. For example: Earth Europe Ireland Cork Kerry Galway

Hi all, I was wondering whether anyone could guide me to docu and code examples how to create and use a has_and_belongs_to_many relationship with a joining table where TWO columns are used to identify the relation to TWO alternative tables. Example: table 1: mothers [mother_id, name] table 2: fathers [father_id, name] table 3: children [child_id, name] joining table 4: children_parent

Hey all, I haven''t heard much on the list in a while re: ActiveSearch, Ferret, Hyper Estraier, etc. in a while. Has anyone successfully used ActiveSearch on tables with rows in the order of hundreds of thousands, if not millions? (in our case, each row containing anywhere from a paragraph of text to many pages) Here''s some background on our search efforts. A. Hyper

Hi there, I try to develop a medical application using ruby on rails. There are many categories which can contain subcategories. I defined the model like this: class Category < ActiveRecord::Base has_and_belongs_to_many :notes belongs_to :parent_category, :class_name=>"Category", :foreign_key=>"category_id" has_many :sub_categories,

Total Ruby N00b here with a question about the Hibbs OnLamp tutorial. I''m trying to hook up to my cookbook database and I''m getting: ActiveRecord::StatementInvalid in Recipe#index Mysql::Error: #42S02Table ''cookbook.recipes'' doesn''t exist: SELECT COUNT(*) FROM recipes RAILS_ROOT: ./script/../config/.. My thoughts: I think I''m not actually

Hey all, How can I call a javascript function from my controller? Is it possible to simply call a javascript function from directly in the controller without needing an AJAX request to come through via link_to_remote or remote form? I''m not talking through an RJS link_to_remote AJAX etc. As an example I''ve tried: class RandomController < ApplicationController

Pretty new to this all and I'm completely confused.. I (think!) I've installed Photoshop CS5 and a desktop has now been created for it on the desktop but whenever I double-click it it appears to be loading and then stops. The program does not show up under 'Applications > Wine > Programs' - Thanks in advance

How do I uninstall Wine?

Hey, now with the DB is it possible to download the wineskins for the apps you're trying to download? I'm having problems playing a platinum games that are supposed to be on the list, http://appdb.winehq.org/objectManager.php?sClass=application&iId=6773 and

I have the same problem with Fedora 14 and wine 1.3.18 Photoshop splash screen starts and crashes when initializing. Here is my crash log: http://fpaste.org/rEBi/

Basically I'm trying to learn how to use Linux and Icecast/Icesource simultaniously. I got everything complied and installed. (Going to recompile Icesource now that I know what LAME is.) However I tried running the Icecast server I have installed just to see it would work. Using the default complied prefs, it loads me to the admin console. Cool. But when I try to make it load the pref

I installed wine on my desktop running ubuntu 10.04. All was working fine until I installed battlefield 1942. I had an issue so decided to uninstall wine and try again. When I reinstalled wine, I get no Programs item in the menu. I can browse to the folder when browsing the c drive. I started to uninstall BF1942 to try again and had a power cut during the process. Is there any way to completely