求一个access数据库2007版本的实例

2024-12-19 18:50:46
推荐回答(1个)
回答1:

<%
Dim rs
Dim rs_numRows

Set rs = Server.CreateObject("ADODB.Recordset")
rs.ActiveConnection = MM_conn_STRING
rs.Source = "SELECT * FROM teachers WHERE subject like '%" + Replace(rs__MMColParam, "'", "''") + "%'