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

Reply via email to