<%
'This creates a recordset to display featured product(s);
'change VareNr number in SQL SELECT statement to display another product and 
'synchonize with the rsCategories recordset (see below)
Dim rsProducts
Set rsProducts = Conn.Execute("SELECT produktBillede, produktBeskriv FROM Produkter WHERE VareNr = 5")
While Not rsProducts.EOF
%>   
<font face="Verdana" size="1"><img align="left" src="<%
Response.Write rsProducts("produktBillede") %>"><%
Response.Write rsProducts("produktBeskriv") %></font><br><br>
<%
rsProducts.MoveNext
Wend
rsProducts.Close
Set rsProducts = Nothing
%> 
<%
'This creates another recordset to display category for GO button.
'You must synchronize the SQL select katalogID number with the featured product VareNr number.
'For example, the VareNr "5" referenced above is in the katalogID "2"
'You must also change the "a href" tag to point to the appropriate page by entering the
'appropriate katalogID number and NAME
Dim rsCategories
Set rsCategories = Conn.Execute("SELECT katalogNavn FROM kataloger WHERE katalogID = '2' ")
While Not rsCategories.EOF
%>
<font face="Arial" size="2"><b>In Our <% Response.Write rsCategories("katalogNavn") %> Catalog</b> <a href="productsByCategory.asp?intkatalogID=2&amp;catalogN AME=Hardware"><img src="images/go.gif" border="0" align="center" WIDTH="20" HEIGHT="20"></a></font>