<% Dim rs,sql Set rs = Server.Createobject("adodb.recordset") sql = "SELECt * FROM Yhc_Workplace where Yhc_ModelID='001' and Yhc_WorkplaceYesNo=true " rs.Open sql,conn,1,1 do while not rs.eof
i = i + 1 if (i mod 3 =1) then '每个tr显示4个记录,可根据需要自行修改 response.write "
" end if response.write "
"&i&"
" response.write "
"&rs("Yhc_Workplace")&"
" Response.Buffer=true Dim rszs,sqlzs Set rszs = Server.Createobject("adodb.recordset") sqlzs = "SELECt * FROM Yhc_Diagnosis WHERe Yhc_WorkplaceID ='"&rs("Yhc_WorkplaceID")&"' " rszs.Open sqlzs,conn,1,1 response.write "