% sqltext = "Select * From legal_assistants Order By LastName,FirstName" rs.Open sqltext, Conn %>
<% thecolor = 0 if NOT rs.BOF then while NOT rs.EOF ID = rs("Id") FirstName = trim(rs("FirstName")) LastName = trim(rs("LastName")) thecolor = thecolor + 1 if thecolor = 2 then bgcolor="White" thecolor=0 else bgcolor="CCCCCC" end if if LastName <> "" and FirstName <> "" then jsName = replace(FirstName,"'","") & " " & replace(LastName,"'","") response.write "
" rs.movenext wend end if %> " & LastName & ", " & FirstName & _ " Update Legal Assistant Upload Photo Delete Legal Assistant