[drupal-support] use of db_rewrite_sql to change the "order by"

[Dan Robinson]

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
>  
>