<% set rsAuctioneers = CreateObject("ADODB.Recordset")
rsAuctioneers.Open "SELECT * FROM auctioneers WHERE active='y' ORDER BY auctioneer" _
, "DATABASE=" & session("database") & ";UID=" & session("dsn username") & _
";PWD=" & session("dsn password") & ";DSN=" & session("dsn")
lcount = 1
response.write("
| ")
while not rsAuctioneers.EOF %>
">
|
<% rsAuctioneers.movenext
if lcount mod 2 = 0 then response.write("
| ")
lcount = lcount + 1
wend
response.write(" ")
if lcount mod 2 = 0 then response.write("
| ")
%>
|
|