Posted by Jan Thomä on 08/29/07 16:20

giloosh wrote:
> Would i just loop through the rows that were checked and add them to
> the WHERE STATEMENT using the OR condition?
>
> select * from rows where id = 3 or id = 2 or id = 6 or id = 10
>

You could try the IN variant like:

select * from rows where id in ( ?, ?, ?, ?);

This might be a bit faster than the ORs...

Best regards,
Jan

--
_________________________________________________________________________
insOMnia - We never sleep...
http://www.insOMnia-hq.de

• Next in forum: Re: salbatron cdata problem
• Prev in forum: return multiple rows from sql statement
• Thread view: Re: return multiple rows from sql statement

[Reply to this message]