if (client.userID != null) { // create an updatable cursor on the SEEKER table. if (!dbCheck()) { redirect("../error.htm?error=dbfail"); } cursor = database.cursor("select * from employer where empid='" + client.userID + "'", true); cursor.next(); cursor.busname = request.busname; cursor.email = request.email; cursor.url = request.url; cursor.busphone = request.busphone; cursor.busfax = request.busfax; cursor.addr1 = request.addr1; cursor.addr2 = request.addr2; cursor.city = request.city; cursor.state = request.state; cursor.postalcode = request.postalcode; cursor.country = request.country; cursor.contactname = request.contactname; cursor.contactphone = request.contactphone; cursor.contactfax = request.contactfax; cursor.contactemail = request.contactemail; cursor.desc = escString(request.desc); // store the processed string only (see lib/sqlstr.js) cursor.creditcardno = request.creditcardno; // Construct a date object to store in the database. expdateObj = new Date(request.expmo + "/01/" + request.expyear); cursor.expdate = expdateObj; cursor.cardtype = request.cardtype; cursor.ponum = request.ponum; cursor.paymethod = request.paymethod; cursor.active = "Y"; cursor.updateRow("EMPLOYER"); cursor.close(); } // END IF redirect("confirm.htm?type=employer");