%@ Language=VBScript %>
<% Option Explicit %>
<%
'Open a connection to the database
Dim objConn, strSQL1,objRSBreed,breedCount,rowsNumb, breedsArray, rowcount, i
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString=connect()
objConn.Open
strSQL1="SELECT breed_ID,b_name FROM breed ORDER BY b_name"
Set objRSBreed = Server.CreateObject("ADODB.Recordset")
objRSBreed.Open strSQL1, objConn,3,3
breedCount = objRSBreed.RecordCount
rowsNumb = Round(breedCount/2,0)
%>