if(!database.connected()) database.connect("ORACLE", "2:ORCL", "CUB", "CREEK", "") if (!database.connected()) write("Error: Unable to connect to database.") else var cat = ''; cursor = database.cursor("select distinct c1desc from versitex.product where brand = '" + request.Brand + "' order by c1desc "); while(cursor.next()) { cat = (cat)+[" "]+(cursor.c1desc) } cat = (request.Brand)+[" "]+(cat); cursor.close(); write("" + cat + ""); write(""); write(""); write("");
<% IF len( (Request.Cookies ("versitex") ("name") ) & "") = 0 THEN response.write "  Log In" else response.write "  Welcome, " & (Request.Cookies ("versitex") ("name")) end if %> go to privacy policy Privacy if(client.totalQuantity == null) { } else { if(client.totalQuantity > 0) { write(" |  View Cart: " + client.totalQuantity + " item(s) " + client.totalDollars + " sub-total ") } else { } }  |  My Account  
go to home page
write("
"); cursor = database.cursor("select distinct c1desc from versitex.product where brand = '" + request.Brand + "' order by c1desc "); while(cursor.next()) { write("Go to " + cursor.c1desc + " " + cursor.c1desc + "
") } cursor.close(); write("
"); cursor = database.cursor("select content from versitex.ad where page = 'brand1.html' and brand = '" + request.Brand + "' "); cursor.next(); write(" " + cursor.content + "
"); cursor.close();