印 像 新 闻 系 统
ASP中获取记录总数
conn.execute("Select count(id) from [user]")(0)
简单的搜索:
keys=" (title like %"&keyword&"%) or (body like %"&keyword&"%) or (name like %"&keyword&"%)"
sql="select * from [info] where ("&keys&")"
rs.Open sql,conn,1,1
记录的排序:(按时间降序)
sql="select * from [info] order by [date] desc"
rs.Open sql,conn,1,1
记录的排序:(按时间升序)
