ASP中可以这么做
< %
boardid=request("boardid") '取出由上个页面传递过来的看板ID号
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft AccessDriver (*.mdb)};dbq=" & Server.MapPath("bbssystem.mdb")
Set cmd = Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn
cmd.CommandText = "主题列表"
ReDim param(0) //注:声明参数数组
param(0) = CLng(boardid)//注:CLng 不可忽略
Set rs = cmd.Execute( ,param )
%>
< %
boardid=request("boardid") '取出由上个页面传递过来的看板ID号
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft AccessDriver (*.mdb)};dbq=" & Server.MapPath("bbssystem.mdb")
Set cmd = Server.CreateObject("ADODB.Command")
Set cmd.ActiveConnection = conn
cmd.CommandText = "主题列表"
ReDim param(0) //注:声明参数数组
param(0) = CLng(boardid)//注:CLng 不可忽略
Set rs = cmd.Execute( ,param )
%>
在access中怎么不能执行下面的语句的??
Update detaildata set billnum=(select billnum from detaildata where pkserial=21) where pkserial=20
-------------------------Update detaildata set billnum=(select MAX(billnum) from detaildata where pkserial=21) where pkserial=20