well what we are trying to do is introduce a weighted sort for taxonomy pages - this is useful for websites with a relatively small number of nodes where they want an explicitly ordered display. The weighting part is easy. It would be nice to intercept the sql and rewrite it. Otherwise it seems like the only way to do this is to duplicate the taxonomy display code yada yada. Is this a reasonable approach? Could db_rewrite_sql be jiggered relatively easily?
Dan
On Fri, 24 Jun 2005, Dan Robinson wrote:
Is there any way to use db_rewrite_sql to change the "order by" clause of an sql statement?
Does not seem to be implemented. If you have a use case for this and think you can convince us it is important, send a patch. :)
Cheers, Gerhard