Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - need some asp assistance on Access db
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

need some asp assistance on Access db

 Post Reply Post Reply
Author
cheops@collecto View Drop Down
Groupie
Groupie


Joined: 14 January 2004
Location: Denmark
Status: Offline
Points: 53
Post Options Post Options   Thanks (0) Thanks(0)   Quote cheops@collecto Quote  Post ReplyReply Direct Link To This Post Topic: need some asp assistance on Access db
    Posted: 24 January 2004 at 9:38am

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&amp;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
Sorry for my bad 3nglish..!!
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.