After adding when you refresh it reinserts the same values, I want to avoid reinserting help please. Code below
<%@ LANGUAGE = JScript %>
<%
try {
var connstr = "DRIVER={SQL Server};SERVER=PROPHET;UID=sa;PWD=password;DATABASE=TimeSheet";
var conn = Server.CreateObject("ADODB.Connection");
if (conn == null) {
Response.Write("Error Detected:"+err);
}
conn.Open(connstr);
var doDelete = Request.QueryString("deleteEntry").Item;
if (doDelete == "yes"){
deleteEntry();
}
var doIaddEntry = Request.QueryString("addEntry").Item;
if (doIaddEntry == "yes"){
addEntry();
}
var doUpdate = Request.QueryString("updateEntry").Item
if (doUpdate == "yes"){
updateEntry();
}
var rs = Server.CreateObject("ADODB.Recordset");
if (rs == null) {
Response.Write("Error Detected:"+err);
}
var sql = "SELECT * FROM NMtimesheet ";
rs.Open(sql, conn);
function addEntry(){
var id = CheckField("idno");
var incdes =CheckField("incident");
var name1 = CheckField("person1");
var name2 = CheckField("person2");
var name3 = CheckField("person3");
var name4 = CheckField("person4");
var name5 = CheckField("person5");
var status = CheckField("sta");
var priority = CheckField("prio");
var notes = CheckField("note");
var who1 = CheckField("whonm");
var who2 = CheckField("whoum");
var dayreceived = Request.Form("dayreceived").Item;
var monthreceived = Request.Form("monthreceived").Item;
var yearreceived = Request.Form("yearreceived").Item;
var received = yearreceived * 10000 + monthreceived * 100 + dayreceived * 1;
var daychecked = Request.Form("daychecked").Item;
var monthchecked = Request.Form("monthchecked").Item;
var yearchecked= Request.Form("yearchecked").Item;
var checked = yearchecked * 10000 + monthchecked * 100 +daychecked * 1;
var dayfixed = Request.Form("dayfixed").Item;
var monthfixed = Request.Form("monthfixed").Item;
var yearfixed = Request.Form("yearfixed").Item;
var fixd = yearfixed * 10000 + monthfixed * 100 + dayfixed * 1;
var daylive = Request.Form("daylive").Item;
var monthlive = Request.Form("monthlive").Item;
var yearlive = Request.Form("yearlive").Item;
var live = yearlive * 10000 + monthlive * 100 + daylive * 1;
function CheckField(name) {
var thisfld = Request.Form(name).Item;
if (thisfld == null) {
Response.Write("Error Detected:"+err);
} else {
thisfld = thisfld.replace("'", "''");
return thisfld };
}
var strOpen = "'";
var strClose = "',";
var final = "insert into NMtimesheet (Number, Description, Person_AB, Person_GS, Person_LB, Person_SJ, Person_SS, Status, Priority, Notes, Who_NM, Who_UM, Received, Checked, Fixed, Live) Values(";
final = final.concat(strOpen , idno, strClose);
final = final.concat(strOpen, incdes, strClose);
final = final.concat(strOpen, name1, strClose);
final = final.concat(strOpen, name2, strClose);
final = final.concat(strOpen, name3, strClose);
final = final.concat(strOpen, name4, strClose);
final = final.concat(strOpen, name5, strClose);
final = final.concat(strOpen, status, strClose);
final = final.concat(strOpen, priority, strClose);
final = final.concat(strOpen, notes, strClose);
final = final.concat(strOpen, who1, strClose);
final = final.concat(strOpen, who2, strClose);
final = final.concat(strOpen, received, strClose);
final = final.concat(strOpen, checked, strClose);
final = final.concat(strOpen, fixd, strClose);
final = final.concat(strOpen, live, "')");
conn.Execute(final);
}
function deleteEntry(){
var id = Request.Form("id").Item;
var sql = "delete from NMTimesheet where id='"+ id.replace("'", "''") +"'";
conn.Execute(sql)
}
function updateEntry(){
var Number = UpdateField("idno");
var Description = UpdateField("incdes");
var Person_AB = UpdateField("ab");
var Person_GS = UpdateField("gs");
var Person_LB = UpdateField("lb");
var Person_SJ = UpdateField("sj");
var Person_SS = UpdateField("ss");
var Status = UpdateField("status");
var Priority = UpdateField("priority");
var Notes = UpdateField("notes");
var Who_NM = UpdateField("whonm");
var Who_UM = UpdateField("whoum");
var Received = UpdateField("received");
var Checked = UpdateField("checked");
var Fixed = UpdateField("fixd");
var Live = UpdateField("live");
var Id = UpdateField("id");
function UpdateField(name) {
var thisfld = Request.Form(name).Item;
if (thisfld == null) {
throw("Error field '" + name + "' does not exist");
} else {
thisfld = thisfld.replace("'", "''");
return thisfld;
}
}
var OpenStr = "'";
var CloseStr = "',"
var sql = " update NMTimesheet set Number = ";
sql = sql.concat(OpenStr, Number ,CloseStr);
sql = sql.concat("Description = ");
sql = sql.concat(OpenStr, Description ,CloseStr);
sql = sql.concat(" Person_AB = ")
sql = sql.concat(OpenStr, Person_AB ,CloseStr);
sql = sql.concat(" Person_GS = ")
sql = sql.concat(OpenStr, Person_GS ,CloseStr);
sql = sql.concat(" Person_lB = ")
sql = sql.concat(OpenStr, Person_LB ,CloseStr);
sql = sql.concat(" Person_SJ = ")
sql = sql.concat(OpenStr, Person_SJ ,CloseStr);
sql = sql.concat(" Person_SS = ")
sql = sql.concat(OpenStr, Person_SS ,CloseStr);
sql = sql.concat(" Status = ")
sql = sql.concat(OpenStr, Status ,CloseStr);
sql = sql.concat(" Priority = ")
sql = sql.concat(OpenStr, Priority ,CloseStr);
sql = sql.concat(" Notes = ")
sql = sql.concat(OpenStr, Notes ,CloseStr);
sql = sql.concat(" Who_NM = ")
sql = sql.concat(OpenStr, Who_NM ,CloseStr);
sql = sql.concat(" Who_UM = ")
sql = sql.concat(OpenStr, Who_UM ,CloseStr);
sql = sql.concat(" Received = ")
sql = sql.concat(OpenStr, Received ,CloseStr);
sql = sql.concat(" Checked = ")
sql = sql.concat(OpenStr, Checked ,CloseStr);
sql = sql.concat(" Fixed = ")
sql = sql.concat(OpenStr, Fixed ,CloseStr);
sql = sql.concat(" Live = ")
sql = sql.concat(OpenStr, Live , "'");
sql = sql.concat(" where Id = ")
sql = sql.concat(OpenStr, Id, "'");
conn.Execute(sql)
}
} catch(err) {
if (typeof(err) == "string")
Response.Write("Error Detected:"+err);
else
Response.Write("Error Detected:"+err.description);
Response.End();
}
%>
<html>
<head>
<meta http-equiv=" pragma" content=" no-cache" >
</head>
<body >
<table border="2px">
<tr>
<th>No</th>
<th>Incident Description</th>
<th>AB</th>
<th >GS</th>
<th >LB</th>
<th >SJ</th>
<th >SS</th>
<th >Status</th>
<th >Priority</th>
<th >Notes</th>
<th>Who NM?</th>
<th>Who UM?</th>
<th>Received</th>
<th>Checked</th>
<th>Fixed</th>
<th>Live</th>
<th align="center">
<form method="link" action="add.html">
<input type="submit" value="Add">
</form>
</th>
</tr>
<%
try {
while(!rs.eof) {
%>
<tr>
<td ><%Response.Write(rs.Fields("Number").value);%></td>
<td ><%Response.Write(rs.Fields("Description"));%></td>
<td ><%Response.Write(rs.Fields("Person_ab"));%></td>
<td ><%Response.Write(rs.Fields("Person_gs"));%></td>
<td ><%Response.Write(rs.Fields("Person_lb"));%></td>
<td ><%Response.Write(rs.Fields("Person_sj"));%></td>
<td ><%Response.Write(rs.Fields("Person_ss"));%></td>
<td ><%Response.Write(rs.Fields("status"));%></td>
<td ><%Response.Write(rs.Fields("priority"));%></td>
<td ><%Response.Write(rs.Fields("notes"));%></td>
<td ><%Response.Write(rs.Fields("who_nm"));%></td>
<td ><%Response.Write(rs.Fields("who_um"));%></td>
<td ><%Response.Write(rs.Fields("received"));%></td>
<td ><%Response.Write(rs.Fields("checked"));%></td>
<td ><%Response.Write(rs.Fields("fixed"));%></td>
<td ><%Response.Write(rs.Fields("live"));%></td>
<td><a href="deleteconfirm.asp?id=<%Response.Write(rs.Fields("Id").value);%>">Delete</a></td>
<td><a href="updateconfirm.asp?id=<%Response.Write(rs.Fields("Id").value);%>">Update</td>
</tr>
<%
rs.MoveNext()
}
} catch (err){
Response.Write("Table empty"+err)
}
finally {
conn.Close();
conn = null;
}
%>
</table>
</body>
</html>