Could somebody help me sort this out. I need to add radio buttons to this script so that a user would have a choice of Small,medium or large and have the list of dogs meeting their choices returned as an ASP. I would be really grateful for as much help as possible
<%@ LANGUAGE = JavaScript%>
<HTML>
<BODY>
<TABLE BORDER=1>
<THEAD>
<TR>
<TH>Breed Name</TH>
<TH></TH>
</TR>
</THEAD>
<%
// Open connection to database, then populate a recordset with list of stock
var adoConnection = Server.CreateObject("ADODB.Connection"
;
var adoRecordSet;
var mySQL;
adoConnection.Open("DSN=DogDSN"
var mySQL = "SELECT BreedName" +
" FROM Breeds";
adoRecordSet = adoConnection.Execute(mySQL);
// Loop through recordset and write Breed Names out to page
while ( adoRecordSet.Eof == false )
{
%>
<TR>
<TD><%=adoRecordSet("BreedName".Value%></TD>
</TR>
<%
adoRecordSet.MoveNext();
}
// Close Recordset and connections
// and release memory used by Recordset and Connection objects
adoRecordSet.Close();
adoRecordSet = null;
adoConnection.Close();
adoConnection = null;
%>
</TABLE>
</BODY>
</HTML>
<%@ LANGUAGE = JavaScript%>
<HTML>
<BODY>
<TABLE BORDER=1>
<THEAD>
<TR>
<TH>Breed Name</TH>
<TH></TH>
</TR>
</THEAD>
<%
// Open connection to database, then populate a recordset with list of stock
var adoConnection = Server.CreateObject("ADODB.Connection"
;var adoRecordSet;
var mySQL;
adoConnection.Open("DSN=DogDSN"
;var mySQL = "SELECT BreedName" +
" FROM Breeds";
adoRecordSet = adoConnection.Execute(mySQL);
// Loop through recordset and write Breed Names out to page
while ( adoRecordSet.Eof == false )
{
%>
<TR>
<TD><%=adoRecordSet("BreedName"
.Value%></TD></TR>
<%
adoRecordSet.MoveNext();
}
// Close Recordset and connections
// and release memory used by Recordset and Connection objects
adoRecordSet.Close();
adoRecordSet = null;
adoConnection.Close();
adoConnection = null;
%>
</TABLE>
</BODY>
</HTML>
