Versitex - Rods, Rod Blanks, Rod Buidling Components

if(!database.connected()) database.connect("ORACLE", "2:ORCL", "CUB", "CREEK", "") if (!database.connected()) write("Error: Unable to connect to database.") else

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

Home > All Brands > " + unescape(client.C1Desc) + " > " + unescape(client.C2Desc) + " > " + unescape(client.C3Desc) + "

"); cursor = database.cursor("select distinct c4desc from versitex.product where brand like '%' and c1desc like '" + unescape(client.C1Desc) + "' and c2desc like '" + unescape(client.C2Desc) + "' and c3desc like '" + unescape(client.C3Desc) + "' order by c4desc "); while(cursor.next()) { write(" Go to " + cursor.c4desc + "

" + cursor.c4desc + "
") } cursor.close(); write("

"); } } else { cursor = database.cursor("select distinct c4desc 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) + "' order by c4desc "); cursor.next(); if(cursor.c4desc == '*') { cursor1 = database.cursor("select sub from versitex.product where brand like '" + unescape(client.Brand) + "' and c2desc like '" + unescape(client.C2Desc) + "' and c3desc like '" + unescape(client.C3Desc) + "' "); 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) + "

"); cursor = database.cursor("select distinct c4desc 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) + "' order by c4desc "); while(cursor.next()) { write(" Go to " + cursor.c4desc + "

" + cursor.c4desc + "
") } cursor.close(); write("

"); } }