在ASP中要如何查询视图的内容?

比如我有一个视图名称为 All_Data,我想查询出里面所有Classid=10的数据,请问用要怎么写?
谢谢
---------------------------------------------------------------

select * from all_date where class_id=10
就象查询一个表一样用

---------------------------------------------------------------

set cm=server.CreateObject("ADODB.Command")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath("temp.mdb")
'skey 为传入的数字
with cm
.ActiveConnection=conn
.CommandType=4
.CommandText="search"
.Parameters.Append .CreateParameter("Skey",3,&H0001,,skey)
end with

Published At
Categories with Web编程
Tagged with
comments powered by Disqus