I'm having trouble paging through a recordset with asp... here is my sql statement...

Code:
rstSetSql = "SELECT TOP 12 * FROM pics WHERE pics_setid = " & rstSet__MMColParam & " AND pics_id IN(SELECT TOP " & 12 * page &  " pics_id ORDER BY pics_id DESC) ORDER BY pics_id ASC"
where...

rstSet__MMColParam = whatever

and

page = 1,2,3,4,5....

but i'm not getting any different results when I change the value of page.

Any ideas on this one? I'm really stuck. Any help would be most appreciated.

Thanks!!