Skip to content

Instantly share code, notes, and snippets.

@arika

arika/gist:183708

Created September 9, 2009 13:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save arika/183708 to your computer and use it in GitHub Desktop.
Save arika/183708 to your computer and use it in GitHub Desktop.
Download ZIP
re: gist:183701
Raw
gistfile1.txt
pinned = Pin.find(:all,:conditions => [ 'pins.eid = last_modifieds.eid AND user_id = ?','arika' ], :joins => 'LEFT OUTER JOIN last_modifieds', :order => 'last_modifieds.date desc',:offset =>0,:limit => 10)
D,[22:27:06.977] Pin Load (0.0ms) Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (pins.eid = last_modifieds.eid AND user_id = 'arika') ORDER BY last_modif' at line 1: SELECT `pins`.* FROM `pins` LEFT OUTER JOIN last_modifieds WHERE (pins.eid = last_modifieds.eid AND user_id = 'arika') ORDER BY last_modifieds.date desc LIMIT 0, 10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment