On Saturday, October 20, 2012 3:44:00 PM UTC-7, desbest wrote:
>
> I'm having problems with this query, which I've put on Github Gist for
> syntax highlighting so you can see what's going on better.
>
> What I want to do, is join the groups table to the posts table, which I've
> done. But I only want to retreive the tables that have their pond column,
> being more than 1.
>
> The link is here.
>
> https://gist.github.com/3925058
>
Your first error is "SQLite3::SQLException: no such column:
posts.datenumber", which should be obvious, that column doesn't exist in
that table. You didn't post the schema for the tables involved in the
query, but if I had to guess, you want groups__datenumber instead of
posts__datenumber.
Your second error is "comparison of Symbol with Integer failed", which is
because you are on ruby 1.9 and Sequel doesn't override the Symbol#>
method. Use a virtual row, switch "exclude(:posts__pond > 0)" to
"exclude{posts__pond > 0}".
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sequel-talk/-/eP8P-qM77X4J.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
