How could I modify the following code to allow a breeder to update the pups available field of their record in the breeders table?
<%@ 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=CompDSN"
var adoRecordset;
// Create SQL to insert new Breeders into Breeders table
var mySQL = "INSERT INTO Breeders " +
"(BreederName,BrPhoneNo ,BrAddress, PupsAvailable,BreedName)";
mySQL = mySQL + " VALUES ('" + Request.Form("txtBreederName" + "','";
mySQL = mySQL + Request.Form("txtBrPhoneNo" + "','";
mySQL = mySQL + Request.Form("txtBrAddress" + "','";
mySQL = mySQL + Request.Form("txtPupsAvailable" + "','";
mySQL = mySQL + Request.Form("txtBreedName" + "','";
// Execute SQL to add new breeder
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 added 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=CompDSN"
var adoRecordset;
// Create SQL to insert new Breeders into Breeders table
var mySQL = "INSERT INTO Breeders " +
"(BreederName,BrPhoneNo ,BrAddress, PupsAvailable,BreedName)";
mySQL = mySQL + " VALUES ('" + Request.Form("txtBreederName" + "','";
mySQL = mySQL + Request.Form("txtBrPhoneNo" + "','";
mySQL = mySQL + Request.Form("txtBrAddress" + "','";
mySQL = mySQL + Request.Form("txtPupsAvailable" + "','";
mySQL = mySQL + Request.Form("txtBreedName" + "','";
// Execute SQL to add new breeder
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 added successfully" +
"</CENTER></H2>"
%>
</BODY>
</HTML>