On Wed, Mar 27, 2002 at 10:53:30AM +0000, geoff webb wrote: > Either: > > SELECT * FROM atable WHERE id IN ( 12, 23, 34 ... ) > > OR > > SELECT * FROM atable WHERE id = 12 OR id = 23 OR id = 34 OR >
Of course it has to be OR'ed. Must have been an "Freudian typo" :) > Flow of retrieving an entry would be: > > search index > -> present results (from index) > -> select desired result (from database) > This should be the right way to go. I just don't want to let my index grow that much, but as you mention going directly into the database for displaying results would cause prohibitive bottlenecks in the backend ... Thx Peter -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>