楼上的意思是在新建数据库时用int吧?我现在是库已经建成了。
我想这么写,笨是笨点,先解决了问题再说。但第1次查询完成后,怎么关闭表,以便第2次查询?
Set rs_id = Server.CreateObject("adodb.recordset")
rs_id.Source = "select max(id) as newid from Detail"
rs_id.Open rs_id.Source,conn,1,1
if rs_id("newid")<>"" then
id=rs_id("newid")+1
else
id=1
end if
rs_id.close
Set rs = Server.CreateObject("adodb.recordset")
rs.Source = "select * from Detail"
'rs.Source = "select max(id) as id,TopicId,Title,Author,Source,Keyword,Context,Docket,Photos,InfoLevel,IfShow,Ifshowdoc,Hits,PublicDate from Detail"
rs.Open rs.Source,conn,1,1