I am using layers to create an online catalogue which is ordered by categories. Clicking on a button, switches layers and the order the products are listed in. I achieve this affect by reording the same sql statement on each layer. Because of this, the page needs to run the same SQL statement 6 times to get the six differently ordered recordsets. This cayuses a delay of about 30 seconds in loading the page ( but it does work beautifully ! ). What i am curious about is any way of running the sql statement once and manipulating the results after they are held in a recordset. ??? Would having a stored query and passing a parameter be the best approach and would this save much time Any ideas or sites that implement something similar would be greatly appreciated !!<BR><BR>Sean