Typo supports this already. http://blog.leetsoft.com/articles/2005/ http://blog.leetsoft.com/articles/2005/03/ http://blog.leetsoft.com/articles/2005/03/28/
On Apr 12, 2005 4:21 PM, Stuart Smith <[EMAIL PROTECTED]> wrote: > I misunderstood the database dependency issues; I just assumed that > since an ISP/host would run typo against a specific persistent storage > mechanism then a specific version of archive.rb would be installed on > the target system. I just saw this as an extension of the multiple SQL > files to create the initial schema for a specific vendor db. > > It would be interesting to see what others make of the problem regarding > vendor specific SQL statements. There are companies that make a living > from 'middleware' to allow the coder to write non-specific SQL (e.g. > RogueWave had something called dbtools.h that I used a long time ago but > that was a real 'pain in the ass' to use). > > Thanks > > Stuart > > > > > app/models/archive.rb > > > > > > class Archive < ActiveRecord::Base > > > > > > has_many :articles > > > > > > def self.find_dates() > > > @archives=Article.find_by_sql(["SELECT distinct date_format > > > (created_at, '%%M %%Y') date from articles ORDER by created_at "]) > > > end > > > > > > end > > > > > _______________________________________________ > Typo-list mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/typo-list > -- Tobi http://www.snowdevil.ca - Snowboards that don't suck http://www.hieraki.org - Open source book authoring http://blog.leetsoft.com - Technical weblog From stuart.smith at smsconsulting.wanadoo.co.uk Tue Apr 12 17:30:25 2005 From: stuart.smith at smsconsulting.wanadoo.co.uk (Stuart Smith) Date: Tue Apr 12 17:24:06 2005 Subject: [typo] ticket #13 - add Archive articles by month (I hope this is what it means!) In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> Isn't the issue being discussed here the method by which a list of links reflecting the month/year of the article is generated? I see now that typo supports the year/month/day (optional) argument list but how do we get from article creation dates to a list of months&years using non- specific date formatting that works for all DB's. Stuart On Tue, 2005-04-12 at 17:04 -0400, Tobias Luetke wrote: > Typo supports this already. > > http://blog.leetsoft.com/articles/2005/ > http://blog.leetsoft.com/articles/2005/03/ > http://blog.leetsoft.com/articles/2005/03/28/ > > On Apr 12, 2005 4:21 PM, Stuart Smith > <[EMAIL PROTECTED]> wrote: > > I misunderstood the database dependency issues; I just assumed that > > since an ISP/host would run typo against a specific persistent storage > > mechanism then a specific version of archive.rb would be installed on > > the target system. I just saw this as an extension of the multiple SQL > > files to create the initial schema for a specific vendor db. > > > > It would be interesting to see what others make of the problem regarding > > vendor specific SQL statements. There are companies that make a living > > from 'middleware' to allow the coder to write non-specific SQL (e.g. > > RogueWave had something called dbtools.h that I used a long time ago but > > that was a real 'pain in the ass' to use). > > > > Thanks > > > > Stuart > > > > > > > > app/models/archive.rb > > > > > > > > class Archive < ActiveRecord::Base > > > > > > > > has_many :articles > > > > > > > > def self.find_dates() > > > > @archives=Article.find_by_sql(["SELECT distinct date_format > > > > (created_at, '%%M %%Y') date from articles ORDER by created_at "]) > > > > end > > > > > > > > end > > > > > > > > _______________________________________________ > > Typo-list mailing list > > [email protected] > > http://rubyforge.org/mailman/listinfo/typo-list > > > >
