1 2 3
Clip.find_by_sql(["select * from clips where not exists (select 'clip_id' from histories where histories.clip_id = clips.id and histories.user_id = ?) ORDER BY clips.created_at DESC LIMIT 20", user.id])
1 2 3 4
class Item < ActiveRecord::Base ALL_VOTES = "all_votes" SCORE = "score" ...
Ruby Complex query in Ruby on Ra...
I have a method called rank...
1 2 3 4
select rrr.account_number,
summa,
to_char(to_date('19570101', 'YYYYMMDD') + max(rrr.lst_pay_dn),
...
PHP Can I do it without accessi...
Actually it's not PHP. And ...
1 2 3 4
#players = select distinct(player) from actions; players = repository(:default).adapter.query('select distinct(player) from actions') ...
Ruby getting 20-100+ sums in one go
by feydr.myopenid.com,
February 10, 2009 19:13,
2 refactorings, tagged with iteratate, sum, sql, ruby
I have an actions table tha...
1 2 3
Declare @Index varchar(128) ...
C# Drop all Indexes in SQL Server
The below is some code I re...
1 2 3 4
<?php $flacpath = '/bin/flac'; ...
PHP FLAC -> Multiple File Ty...
by wegosublime,
October 31, 2007 17:33,
5 refactorings, tagged with cron, mp3, flac, ogg, music, record company, sql, shell, command line
This is part of a larger pr...
How can I turn this into so...