Page 1 code: sql = "SELECT * FROM tblStaff WHERE ChartID = " & ChartID Set objrec = Server.CreateObject("ADODB.Recordset") objrec.Open sql, objConn If not objrec.eof then LibFTE = objrec("LibFTE") [ALL FIELDS ARE IDENTIFIED.....] End If [Standard HTML code. Then display update form] <p><b>What is the approved FTE?</b> <input type="text" name="LibFTE" size="9" value="<%=objRec("LibFTE")%>"><br> Code in End.asp dim sql, objRec, ChartID ChartID = Request.form("ChartID") on error resume next sql = "SELECT * FROM tblStaff WHERE ChartID = " & ChartID Set objRec = Server.CreateObject("ADODB.Recordset") objRec.Open sql, objConn, adLockOptimistic, adCmdTable objRec("LibFTE") = Request.form("LibFTE") [all fields identified] objRec.Update if err.Number <> 0 then Response.Write "<font face='Arial'>Data is not updated." Response.Write "<p>Error updating record, please press the <b>Alt</b> + back arrow to correct." Response.Write "The most common error is text in the FTE fields." Response.End end if
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE