Contents of s0972midans2.asp:
<html><body> <% set rs=server.createobject("ADODB.Recordset") ' '*** join the tables on proj_id ' sql="SELECT * FROM s09drawings JOIN s09project ON s09drawings.proj_id = s09project.proj_id" sql=sql+" order by drawing_set ASC, drawing_type ASC" rs.open sql,"DSN=gl001;UID=gl001;PWD=11111;" c=0 response.write "<table border='1'>" while not rs.eof response.write "<tr>" response.write "<td>"+cstr(rs("drawing_set"))+"</td>" response.write "<td>"+cstr(rs("proj_name"))+"</td>" select case rs("drawing_type") case "A" type_out="Architectural" case "N" type_out="Engineering" case "E" type_out="Electrical" case "M" type_out="Mechanical" case "L" type_out="Landscape" end select response.write "<td>"+type_out+"</td>" response.write "<td>"+cstr(rs("drawing_desc"))+"</td>" response.write "<td>"+cstr(rs("drawing_file"))+"</td>" response.write "<td>"+cstr(rs("drawing_date"))+"</td>" response.write "<td>"+cstr(rs("drawing_version"))+"</td>" response.write "</tr>" c=c+1 rs.movenext wend rs.close set rs=nothing response.write "</table><p>Row Count="+cstr(c) %> </body></html>
***** end of file *** printed: 44 lines on: 11/23/2009 5:54:13 AM
