<% sqltext = "Select * From Attorneys Order By LastName,FirstName" rs.Open sqltext, Conn %> Morris Pickering & Sanner - Admin: Attorney List    Morris Pickering & Sanner - Attorney List
      Select a Attorney on the list to modify their information.

<% thecolor = 0 if NOT rs.BOF then while NOT rs.EOF ID = rs("AttorneyId") 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 Attorney   Upload Photo   Delete Attorney