Else's blog

'多表查
exec="select a.id,a.price,a.title,a.serv,a.gamename,b.id,b.title,c.id,c.name from products a,game b,serv c where a.gamename=b.id and a.serv=c.id  order by a.id desc"
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,3,1
response.Write rs(0)&"<br>"
response.Write rs(1)&"<br>"
response.Write rs(2)&"<br>"
response.Write rs(3)&"<br>"
response.Write rs(4)&"<br>"
response.Write rs(5)&"<br>"
response.Write rs(6)&"<br>"
response.Write rs(7)&"<br>"
response.Write rs(8)&"<br>"
response.Write("++++++++++++++++++++++++++++++以上的显示是对的+++++++++++++++++++++++++++++++<br>")
response.Write rs("a.id")&"<br>"
response.Write rs("a.price")&"<br>"'这个出错
response.Write rs("a.title")&"<br>"
response.Write rs("a.serv")&"<br>"'这个出错
response.Write rs("a.gamename")&"<br>"'这个出错
response.Write rs("b.id")&"<br>"
response.Write rs("b.title")&"<br>"
response.Write rs("c.id")&"<br>"
response.Write rs("c.name")&"<br>"'这个出错
rs.close
set rs=Nothing