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 + " ") } Privacy if(client.totalQuantity == null) { } else { if(client.totalQuantity > 0) { write(" |  View Cart: " + client.totalQuantity + " item(s) " + client.totalDollars + " sub-total ") } else { } }  |  My Account

if(request.Brand == 'All') { } else { }

write("");

client.C4Desc = request.C4Desc; if(client.Brand == 'All') { cursor = database.cursor("select distinct c5desc from versitex.product where brand like '%' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' and c3desc like '" + unescape(client.C3Desc) + "' and c4desc like '" + unescape(client.C4Desc) + "' order by c5desc "); cursor.next(); if(cursor.c5desc == '*') { cursor1 = database.cursor("select sub from versitex.product where brand like '%' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' and c3desc like '" + unescape(client.C3Desc) + "' and c4desc like '" + unescape(client.C4Desc) + "' "); cursor1.next(); var sub = 0; sub = cursor1.sub; cursor1.close(); cursor.close(); redirect("product.html?Id=" + sub + " "); } else { write(" Home > All Brands > " + client.C1Desc + " > " + unescape(client.C2Desc) + " > " + unescape(client.C3Desc) + " > " + unescape(client.C4Desc) + " "); cursor = database.cursor("select distinct c5desc from versitex.product where brand like '%' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' and c3desc like '" + unescape(client.C3Desc) + "' and c4desc like '" + unescape(client.C4Desc) + "' order by c5desc "); while(cursor.next()) { write(" " + cursor.c5desc + " ") } cursor.close(); write(" ") } } else { cursor = database.cursor("select distinct c5desc from versitex.product where brand like '" + unescape(client.Brand) + "' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' and c3desc like '" + unescape(client.C3Desc) + "' and c4desc like '" + unescape(client.C4Desc) + "' order by c5desc "); cursor.next(); if(cursor.c5desc == '*') { cursor1 = database.cursor("select sub from versitex.product where brand like '" + unescape(client.Brand) + "' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' and c3desc like '" + unescape(client.C3Desc) + "' and c4desc like '" + unescape(client.C4Desc) + "' "); cursor1.next(); var sub = 0; sub = cursor1.sub; cursor1.close(); cursor.close(); redirect("product.html?Id=" + sub + " "); } else { write(" Home > " + unescape(client.Brand) + " > " + unescape(client.C1Desc) + " > " + unescape(client.C2Desc) + " > " + unescape(client.C3Desc) + " > " + unescape(client.C4Desc) + " "); cursor = database.cursor("select distinct c5desc from versitex.product where brand like '" + unescape(client.Brand) + "' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' and c3desc like '" + unescape(client.C3Desc) + "' and c4desc like '" + unescape(client.C4Desc) + "' order by c5desc "); while(cursor.next()) { write(" " + cursor.c5desc + " ") } cursor.close(); write(" ") } }

Versitex of America · 3545 Schuylkill Rd., Rte 724 · Spring City, PA 19475-1527 · Phone: 610-948-4442  Fax: 610-948-7310 · About Versitex · ©  Versitex of America · Contact Us