Hi,
I have an access database with 161 records in it. It has 14 fields, one of those fields is called contentID which is how i am currently pulling the information from the DB to an ASP page. Most of the time i need to pull the information sequentially meaning records from the field contentID 10 to contentID 30. In some cases however, I am trying to retrieve records that are not in sequence, for example contentID 40 to contentID 60 and contentID 62, 63, 64, 161. I can do it sequencially with the following code but not when the recordsets are out of sequence:
ASP code at top of page
-----------------------

<%dim rs,i,ra
set rs=dbExec("SELECT contentID, contentNameEn FROM content ORDER BY contentID")
i=0
%>


Code in the body of page
-------------------------
<%for i=10 to 86
  if (i >= 10 and i <= 19) or i=85 then%>
        <li style="color: #FFFFFF" type="square"><a href="propertyedit.asp?contentID=<%=rs("contentID" )%>">
        Properties</a>&nbsp;
         <a href="contentedit.asp?contentID=<%=rs("contentID") %>">
        Content</a>
        <a HREF="contentEditNew2.asp?contentID=<%=rs("content ID")%>">
        Advanced Editor</a>
        <b><a HREF="contentedit.asp?contentID=<%=rs("contentID") %>">
        <%=rs("contentNameEn")%></a></b></li>
<%end if%>
 <%rs.moveNext
 next%>

Thanks
-Pablo

Are these contentIds that you wish to retrieve all CONSTANTs?

How do you know that which contentID or sequence you would require to retrieve? 10-30 or 40-60 or anything else. Why is that you are retrieving the contentId like this? Can you explain?

How do you know that you should fix the for loop from 10 to 86???

_________________________
- Vijay G
Strive for Perfection

Yes they are constant

the page that calls these contentID's is predetermined.

I don't know if the loop should be fixed like this, i am looking for code that would solve this.

What i am looking to accomplish is to pull out the recordsets that fall inbetween sets of numbers so for example records from 61 - 81 and then 92 - 105 on the same ASP page.

Thanks for your help
-pablo

Is that predetermined just before the page is called, which means everytime the page is called, these ranges are going to be different? Or those ranges are always same (61 - 81 and then 92 - 105)?

Whichever, I would suggest you check for the rs("contentID") to do things there. Hope that helps.
Cheers!
_________________________
- Vijay G
Strive for Perfection