if(!database.connected()) database.connect("ORACLE", "2:ORCL", "CUB", "CREEK", "") if (!database.connected()) write("Error: Unable to connect to database.") else client.C5Desc = request.C5Desc; cursor = database.cursor("select distinct c6desc 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) + "' and c5desc like '" + unescape(client.C5Desc) + "' order by c6desc "); cursor.next(); 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) + "' and c5desc like '" + unescape(client.C5Desc) + "' "); cursor1.next(); var sub = 0; sub = cursor1.sub; cursor1.close(); cursor.close(); redirect("product.html?Id=" + sub + " ");