Hi,
I am trying to create a list of links which are dynamically generated from a repeat region.
My table fieldnames are as follows :-

PageId
Page_Title
Page_Text
Page_By
Page_Date

I want to create a list of Page Titles created using a Repeat Region which then link individually to a 'more details' page using PageId

Any suggestions?

What's your recordset's name?

Doc
Rangewalk Digital Studios

Nevermind, we'll assume that your recordset name is rs_mypages.

<%
while not rs_mypages.eof
response.write "<a href=""detail_page.asp?id=" & rs_mypages.fields.item("PageID".value & """>" & rs_mypages.fields.item("Page_Title".value & "</a><br>"
rs_mypages.movenext
wend
%>

This is pretty simple. If you're so inclined you can neaten things up by including <tr> and <td> tags in the appropriate places in the code.

Hope this helps. Let me know if you have questions.

Doc
Rangewalk Digital Studios

Edited by - on 19 Nov 2004 20:12:31

Thanks Dave,
That worked a treat.