Hi there I have this piece of asp code, I need it to display randomly on the front page of my website - I have looked everywhere on how to modify this to work and I can find any - hope some one in here can help me
<% '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&catalogN AME=Hardware"><img src="images/go.gif" border="0" align="center" WIDTH="20" HEIGHT="20"></a></font>
|
Best regards
Cheops@Collector
Edited by cheops@collecto