ta WHERE RecordId = @Id_Req" & Chr(10)
  strsql8 ="SELECT AllData.city FROM AllData WHERE RecordId = @Id_Req" & Chr(10)
  
  'Puts together all of the local variables into one variable
  'That will be used by the recordset object
  strsql = strsql & strsql2 & strsql3 & strsql4 & strsql5 & strsql6 & strsql7 & strsql8
  
  'This is optional this writes out the strsql local variable
  'that will be passed to the database
  response.write "<b>" & "Sql Statement that is passed to the database" & "</b>" & "<br>"
  response.write strsql & "<br>" & "<br>"
  
  'sets a connection & recordset objects and executes the strsql local variable
  set conn = server.createobject("adodb.connection")
  conn.open strconn
  set rs = server.createobject("adodb.recordset")
  rs.open strsql, conn
  
  'Parses out the individual recordsets and places them
  'into individual table rows
  intcount = 1
  Do Until rs Is Nothing
  response.write "<table border='1' width='25%'>"
  
  response.write "<b> Contents of recordset #" & intCount & "</b><br>"
  'Parses out the individual recordsets and places them into table rows
  Do While Not rs.EOF
  response.write "&l

上一页  [1] [2] [3] 下一页

在google里搜索更多使用NextRecordset通过一个Connection输出多个select查询

	Web www.51ec.org

上一篇信息学院： 利用FSO取得BMP，JPG，PNG，GIF文件信息

下一篇信息学院： 远程获取内容，并将内容存在本地电脑上，包括任何文件