similar to: how to search all fields for a string in SQL ?

Displaying 20 results from an estimated 2000 matches similar to: "how to search all fields for a string in SQL ?"

2007 Oct 20
2
where to put code for my own paginator ?
I had to make my own pagination class in SQL Server. What I am wondering is where is a good place to put the code so that every controller and template can have access to it ? Right now I have put it in application.rb, the controller base class. This seems to work well, I did a project last summer where I put stuff in the lib directory. The only problem with that is that if you change any code at
2008 Aug 20
2
Re: Stubbing out ThinkingSphinx for Rspec
Thanks Wolas! Sorry if this seems like a newbie question, what am I supposed replace the stubbed_method_name with? Also, I came across the only thread on the Interwebs which seems to cover this topic - it''s over a year old, but I think they have a solution which could work around the issues you pointed out. However, I couldn''t work out how to get their subbing approach to
2011 Aug 02
2
Positive experiences with Xapian
Hi Guys, I just wanted to take a moment to give some positive feedback regarding my experiences with Xapian recently. I've been doing a fair amount of research into search engines recently, as we have some fairly specific requirements with what we're attempting to do with them. Long story short, after a few weeks of playing around with just about everything under the sun (or at least,
2009 Mar 08
3
scaling full text indexing(ferret vs solr vs hyperstraier)
Hi, Does any have experience scaling full text search in RoR? Right now our project is running a simple setup with ferret and acts_as_ferret. We are thinking about deploying a feature that would send 50x more search requests. So we probably have to rethink our solution. How do services like search.twitter.com (the former Summize) use? Or in what direction should I look? -- Thanks, M.
2008 Sep 17
1
Stubbing Paperclip calls to Amazon S3 (for Rspec)
Would anyone happen to know how to stub a call to S3 from Paperclip? I''ve searched every where and no one seems to have posted anything about this. I''ve done very little in the way of spec''ing dependencies on external services, so any ideas on how to do this with Paperclip & S3 would be most appreciated. I''m happy with stubbing out Thinking Sphinx - would
2009 Mar 13
6
Using LIKE
I''ve heard that using LIKE is very slow, but I see it being used a lot in examples, blogs etc. Is it really that bad? Since Rails doesn''t directly support Fulltext search, this is the easiest way to get searching done, right? Or are there any other easier ways? I''m using acts_as_indexed right now, but it still doesn''t do what LIKE does.
2008 Jun 25
3
Need some suggestions on search strategy
I need some suggestions for the best way to implement search for my client. They have several models (project, request, usage, etc.) that they need to search for. Each model will have its own search page with a form that is similar to the one shown for editing. So the search needs to be across model fields and the results are limited to the model. Some of the model fields will be for
2007 Aug 29
12
ruby on rails search engine
He all, who can recommend me search engine(search for different models) for my web-site? ps: i know about ferret for example, but maybe there are some others? Thank you -- 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
2009 Mar 06
1
Ultrasphinx search error... Invalid class name
I''ve got Ultrasphinx powering the search on my Rails app. It''s working with all of my models when they''re first indexed, but then, after what seems like a random amount of time, I''ll get the following error on just *one* of my models: search#show (Ultrasphinx::UsageError) "Invalid class name \"Playlist \"" I set up this model like so:
2005 Nov 19
14
FULLTEXT search in MySQL on rails
I tried adding a FULLTEXT search index to a table of mine in MySQL, only to discover that the InnoDB table format doesn''t seem to support this feature. Switching to the MyISAM table type seemed to work, but I seem to have some recollection that ActiveRecord transactions aren''t fully atomic on MyISAM tables. Is this true or am I just remembering wrong? If so, does anyone have
2006 Mar 04
2
Using Migrations to Build a MySQL FULLTEXT index?
Can anyone point me to the proper syntax to build a FULLTEXT MySQL index via migrations? I''m really liking these things, and don''t want to step back into the world of manual intervention.
2008 Mar 31
1
problem in installlation of ferret search plugin in rails application
When i went to installation ferret in my rails application then i have faced a problem that is look like this ERROR: While executing gem ... (Gem::FilePermissionError) You don''t have write permissions into the /var/lib/gems/1.8 directory. i used this command for ferret install sudo gem install ferret --~--~---------~--~----~------------~-------~--~----~ You received this message
2006 Mar 29
2
1.1 ruby schema breaks MySQL FULLTEXT index
If you used MySQL FULLTEXT indexes and just upgraded to Rails 1.1, watch out for this one. Rails 1.1 now defaults to Ruby as your schema format. So instead of development-structure.sql, Rake will use schema.rb. That''s portable and good stuff overall but there is a slight compatibility issue. Ruby schema doesn''t know how to do FULLTEXT index syntax for MySQL. To work around it,
2012 Jul 31
1
puppet doc questions
Does puppet doc require a specific version of any gems (such as rdoc or rake) to operate? I''m getting some errors when I try to generate my rdoc now. # puppet doc --output /var/www/test --modulepath /etc/puppet/environments/test/modules -m rdoc RDoc::RDocError is deprecated and will be removed in RDoc 4 Could not generate documentation: uninitialized constant RDoc::RDoc::Generator
2006 Nov 30
2
non-searchable columns, normalization
Hello. I am new to Ferret. I am using it through Acts as Ferret. Let''s say I have such a table, and all columns are indexed using the default behavior provided by acts_as_ferret: ARTICLES -id -year -body [1] A typical request will be "select id from articles where KEYWORDS % body". Will id be indexed for fulltext searching? clearly the fulltext index on id will never be
2008 Sep 03
4
delta index in Sphinx
Hello, all! Help me please to solve problem with Sphinx and its delta index. Configuration file is located in attachment to this topic. ------------------------------------------------------------------- mysql> select id, e_mail from users where e_mail LIKE ''%test%''; -------------------------------------------------------------------
2008 Jul 20
1
Installing plugins from .tar.gz file, how?
First, thanks for your attention! I''m trying to install UltraSphinx plugin from svn but unfortunately it''s down. I have a .tar.gz package, how can i install it? ./script/install package.tar.gz - doesn''t work -- Regards, Luiz Vitor Martinez Cardoso cel.: (11) 8187-8662 blog: rubz.org engineer student at maua.br --~--~---------~--~----~------------~-------~--~----~
2006 May 17
8
How to implement full-text search with OR just like google?
The current full-text search will return the AND collection results,for example,if we use Article.search("aa bb"),then the articles that include "aa" and "bb" in the fields will be returned,how to return the articles that include "aa" OR "bb" effectly? A stumb method is to setup two queries respectly and collect them together with remove the
2019 Feb 11
4
Documentation doesn't get updated
Hi Tanya, Last time I noticed a problem with clang-tools-extra docs you could help solving them. If someone else is taking care of this part of the infrastructure now, please redirect appropriately. It looks like docs generated from rst (for LLVM, Clang and clang-tools-extra) don't get updated at the moment. They stopped updating somewhere between r353327
2015 Oct 27
2
Dovecot frequently full-text reindexes the whole maildir
Hi! I'm using Dovecot 2.2.13 (Debian Jessie package 1:2.2.13-12~deb8u1) on my personal mail server (the address I'm writing from is on this server). I use Maildirs, I have fts + fts_squat enabled, and I have a problem with it for a long time - dovecot seems to not update the index always "incrementally". Yesterday I've finally made a test by telneting to imap port and