<% SQL_query = "SELECT * FROM ProductMaster where active1='true' and subcategory='New Package'" Set RS = conn.Execute(SQL_query) ss=0 WHILE NOT RS.EOF %> ">Package #<%=RS("PRODID")%> "> " alt="Product #<%=RS("PRODID")%>" src="images/04.jpg" width=230 height=100> <%=RS("PRODdesc")%> <%=RS("price1")%> "> <% RS.MoveNext ss=1 WEND RS.Close %> <% If ss=0 then %> Currently there is no new package posted <% end if %>
Currently there is no new package posted