<%@ Language=VBScript %>
List of Signatures
<% dim oConn, sConn, sSQL, rs sSQL = "SELECT lname & ' ' & fname & ', ' & affiliation as [Signature] FROM Signatures ORDER BY lname, fname" sConn = "DSN=IsraelPetition" set oConn = Server.CreateObject("ADODB.Connection") oConn.Open sConn set rs = oConn.Execute(sSQL) %> <% do until rs.eof Response.Write "" if not isnull(rs("Signature")) then Response.Write "" & chr(13) end if rs.movenext if not rs.eof then if not isnull(rs("Signature")) then Response.Write "" & chr(13) end if end if Response.Write "" & chr(13) if not rs.eof then rs.movenext loop rs.close set rs = nothing oConn.close set oConn = nothing %>

 

"& "" & rs("Signature") & "" & ""& rs("Signature") & "