http://guruza.com/searches/show/1018 Questions recently submitted to Guruza that match the query: sqlite Thu, 28 Aug 2008 13:18:44 -0700 http://guruza.com/question/482/reward-0.00 I am trying to use sqlite3 for my dev database with my Rails app (1.2rc2). I am on OS X so sqlite3 is installed by default (I even installed the lastest version with darwinport), and I have done gem install sqlite3-ruby. However, when I try to do anything that has to do with ActiveRecord, I get errors. Here's an example: >> Domain.new ActiveRecord::StatementInvalid: ActiveRecord::StatementInvalid from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/connection_adapters/sqlite_adapter.rb:273:in `table_structure' from /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.3.1.5848/lib/active_support/core_ext/object/misc.rb:23:in `returning' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/connection_adapters/sqlite_adapter.rb:272:in `table_structure' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/connection_adapters/sqlite_adapter.rb:210:in `columns' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/base.rb:760:in `columns' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/base.rb:2048:in `attributes_from_column_definition_without_lock' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/locking/optimistic.rb:45:in `attributes_from_column_definition' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/base.rb:1490:in `initialize_without_callbacks' from /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.14.4.5848/lib/active_record/callbacks.rb:225:in `initialize' from (irb):1 Any idea? EDIT: The funny thing is that I use sqlite3 and it works great with another project I started some time ago... Mon, 15 Jan 2007 07:58:30 -0800 http://guruza.com/question/418/reward-25.00 In a RoR application I am making I have a sortable table made using a technique similar to this: http://dev.nozav.org/rails_ajax_table.html This is a two part question: Normally the table is 'unsorted' when you get to it even though the items are alreay in alphabetical order according to the first column. Because of this, the first time you click title to sort by name it appears to do nothing because it was going from 'unsorted' to 'sorted by name' and both are identical. On the first click it should go from 'sorted by name' to 'reverse sorted by name' and the sort_td_class_helper should have the 'sortdown' class applied to it when the page loads. **A solution would either include sample code or enough explanation that I can get it to work.** The other part of the question is how can I make the sorting case-insensive? **A solution would either include sample code or enough explanation that I can get it to work.** Thu, 21 Sep 2006 10:55:10 -0700