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
cursor = database.cursor("select distinct c2desc from versitex.product where brand = '" + request.Brand + "' and c1desc = '" + request.C1Desc + "' order by c2desc "); cursor.next(); if(cursor.c2desc == '*') { cursor1 = database.cursor("select sub from versitex.product where brand = '" + request.Brand + "' and c1desc = '" + request.C1Desc + "' "); cursor1.next(); var sub = 0; sub = cursor1.sub; cursor1.close(); cursor.close(); redirect("product.html?Id=" + sub + " "); } else { write("
"); cursor = database.cursor("select distinct c2desc from versitex.product where brand = '" + request.Brand + "' and c1desc = '" + request.C1Desc + "' order by c2desc "); while(cursor.next()) { write("Go to " + cursor.c2desc + " " + cursor.c2desc + "
") } cursor.close(); write("
"); cursor = database.cursor("select content from versitex.ad where page = 'brand2.html' and brand = '" + request.Brand + "' and c1 = '" + request.C1Desc + "' "); cursor.next(); write(" " + cursor.content + "
"); cursor.close(); }