Trying to avoid *fetch* (which isn't working either), I have the following
attempt for sequel:
SELECT hashtag, (tagcount/1000) AS tagcount
FROM myhashtags
WHERE status = 'new'
AND NOT hashtag = ANY (?)
ORDER BY tagcount DESC
LIMIT ? }, 'active', avoids, 29 ]
This is what I have:
DBL[:myhashtags].
where(:status => 'active').
select{ :hashtag, (Sequel.function(:tagcount/1000)) }. # => trouble
here
reverse(:tagcount).
limit(29)
My *avoids* is a list of tags to not include (avoid). I can't seem to get
the *:tagcount/1000* to work either. I can't seem to find anything in the
docs that shows me how to get that done.
Any insight appreciated as to how I can get this to work. Even .fetch
isn't working.
Cheers
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sequel-talk/7efa9f85-9b37-4756-b3e1-c904c4b400ec%40googlegroups.com.
