On Sat, 2006-07-01 at 01:10 +0200, Dominik Bruhn wrote: > SELECT id,addfield FROM table WHERE id IN ([LUCENERESULT]); > > Where LUCENERESULT is like 2,3,19,3,5. > > This works fine but got one problem: The Search-Result of Lucene is order by > relevance and so the id-list is also sorted by relevance. But the result of > the SQL-Query is sorted by the id which destroys the relevance-sorting. > > Does anybody know a work-arround?
This is really a question you should ask in the forum of your RDBMS. You could always execute multiple SQL-queries within the same statement without too much loss. But I'm certain there is a way to enforce the order as you specified it in the WHERE-clause. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
