Could somebody have a look at this and tell me what if anything is missing from it:
<%@ LANGUAGE = JavaScript%>
<HTML>
<HEAD>
<meta name="Microsoft Theme" content="indust 110, default">
</HEAD>
<BODY>
<%
// Connect to database
var adoConnection = Server.CreateObject("ADODB.Connection"
adoConnection.Open("DSN=DogDSN"
var adoRecordset;
// Create SQL to update pups info in Breeders table
var mySQL = "UPDATE Breeders SET PupsAvailable ='" & Request.Form("txtPupsAvailable"&"'"
& "WHERE BreederNo ="Val(Request.Form("txtBreederNo");
// Execute SQL to update breeder pups info
adoConnection.Execute(mySQL);
// Recordset not needed after this so close it and allow release of memory
adoRecordset.Close();
adoRecordset = null;
Response.Write("<H2><CENTER>Your Details have been updated successfully" +
"</CENTER></H2>"
%>
</BODY>
</HTML>
<%@ LANGUAGE = JavaScript%>
<HTML>
<HEAD>
<meta name="Microsoft Theme" content="indust 110, default">
</HEAD>
<BODY>
<%
// Connect to database
var adoConnection = Server.CreateObject("ADODB.Connection"
adoConnection.Open("DSN=DogDSN"
var adoRecordset;
// Create SQL to update pups info in Breeders table
var mySQL = "UPDATE Breeders SET PupsAvailable ='" & Request.Form("txtPupsAvailable"&"'"
& "WHERE BreederNo ="Val(Request.Form("txtBreederNo");
// Execute SQL to update breeder pups info
adoConnection.Execute(mySQL);
// Recordset not needed after this so close it and allow release of memory
adoRecordset.Close();
adoRecordset = null;
Response.Write("<H2><CENTER>Your Details have been updated successfully" +
"</CENTER></H2>"
%>
</BODY>
</HTML>