求教asp语句怎么写

ASP已经用<!--#include file="conn.asp"-->连接上了ACCESS数据库，数据库里有个表名叫product
表里的字段包括ID NAME PRICE
从前一个页面获得了ID=100
要查询表里ID=100的数据的PRICE，语句要怎么写

dim rs,sql
set rs=server.createobject("adodb.recordset")
sql="SELECT PRICE FROM product WHERE ID=100"
rs.open sql,conn,1,1

response.write rs("price")

rs.close

SELECT [PRICE] FROM [product] WHERE ID=100

set rs=conn.execute("select price from product where "&request("id")&")"

首先 我建议 NAME 这个字段你做好是换一个字符 因为NAME是关键字，容易出错。

sql="select * from product where id = "&request("id")&""
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
PRICE =rs("PRICE")
rs.close
set rs=nothing

select id,price from product where id=100

set rs=server.CreateObject("adodb.recordset")
sql="select id,price from product where id = "&request("id")&""
rs.open sql,conn,1,1
price =rs("price")
rs.close
set rs=nothing