if(!database.connected()) database.connect("ORACLE", "2:ORCL", "CUB", "CREEK", "") if (!database.connected()) write("Error: Unable to connect to database.") else
if(client.Name == null) { write("  Log In") } else { write("  Welcome, " + client.Name + " ") } 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
client.C1Desc = escape(request.C1Desc); write("
"); cursor = database.cursor("select distinct c2desc from versitex.product where c1desc = '" + unescape(client.C1Desc) + "' order by c2desc"); while(cursor.next()) { write("" + cursor.c2desc + " " + cursor.c2desc + "
") } cursor.close(); write("
"); cursor = database.cursor("select content from versitex.ad where page = 'type0.html' and brand = 'All' and c1 = '" + request.C1Desc + "' "); cursor.next(); write(" " + cursor.content + "
"); cursor.close();