在Delphi或js中怎么用access的参数查询?
CXZ9 2002-12-30 04:13:18
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 )
%>