How to show a number of items in an asp web page?

Simon,

First you would have to do a select statement to see if there were any new records.

After that you could use code like this:

<%If CheckForNewRecords.EOF <> True Then%>
<form name=newtree method=post action=newtree.asp?id=<%CheckForNewRecords("TreeID")%>
<input type=submit name=submit value="Next Tree">
</form>
<%End If%>

Then in newtree.asp you would do something like:

<% NewTree = Request("id")
If NewTree <> "" Then
Conn.Open 'open your db connection here
SQL = SELECT * From Trees WHERE TreeID = '" & NewTree & "'"
Set DisplayTree = Conn.Execute(SQL)
%>
<% If DisplayTree.EOF <> True Then %>
<p><img src=<%DisplayTree("image")%></p>
<% End If %>

I'm making up my own database field names so you would obviously insert your field names there, but something like this would do the trick.

Regards,
Peter J. Boettcher