Skip to content

Instantly share code, notes, and snippets.

@jgautsch

jgautsch/gist:5316097

Created April 5, 2013 02:17
Show Gist options
  • Save jgautsch/5316097 to your computer and use it in GitHub Desktop.
Save jgautsch/5316097 to your computer and use it in GitHub Desktop.
Download ZIP
Query fiddling
Raw
gistfile1.rb
1.9.3-p374 :015 > @books = @books.where(['substr(title,1,1) in ?', ('A'..'T').to_a])
Book Load (41.2ms) SELECT "books".* FROM "books" WHERE (substr(title,1,1) in 'A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T')
SQLite3::SQLException: near ",": syntax error: SELECT "books".* FROM "books" WHERE (substr(title,1,1) in 'A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T')
ActiveRecord::StatementInvalid: SQLite3::SQLException: near ",": syntax error: SELECT "books".* FROM "books" WHERE (substr(title,1,1) in 'A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S','T')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment