asp参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
ADODB.Command(0x800A0BB9)参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。/by/studentxuanke.asp,第17行<%@L...
ADODB.Command (0x800A0BB9)
参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
/by/studentxuanke.asp, 第 17 行
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file=conn.asp -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam ="2007"
If (Request.QueryString("grade") <> "") Then
Recordset1__MMColParam = Request.QueryString("grade")
End If
Session("grade")=Recordset1__MMColParam
%>
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_conn_STRING
Recordset1_cmd.CommandText = "SELECT * FROM course WHERE grade = ?"
Recordset1_cmd.Prepared = true
Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 5, 1, -1, Recordset1__MMColParam) ' adDouble
Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<body>
<!--#include file="top1.asp"-->
<table width="760" height="300" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#76A022" style="border-left:1px solid #000000;border-right:1px solid #000000;border-bottom:1px solid #000000" >
<tr>
<td width="100%" height=35> <div align="center"><font color="#ffffff">学生选课</font></div>
</td>
</tr>
<tr>
<td width="100%" valign="top"><div align="center">
<form id="form1" name="form1" method="post" action="">
<label>
<select name="jumpMenu" id="jumpMenu" onChange="MM_jumpMenu('parent',this,0)">
<option>选择年份</option>
<option value="studentxuanke.asp?grade=2007">2007</option>
<option value="studentxuanke.asp?grade=2008">2008</option>
</select>
</label>
</form>
<script type="text/javascript">
<!--
Recordset1_cmd.ActiveConnection = MM_conn_STRING 哪里错了？
告诉我怎么改好不好？ 展开
参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。
/by/studentxuanke.asp, 第 17 行
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file=conn.asp -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam ="2007"
If (Request.QueryString("grade") <> "") Then
Recordset1__MMColParam = Request.QueryString("grade")
End If
Session("grade")=Recordset1__MMColParam
%>
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_conn_STRING
Recordset1_cmd.CommandText = "SELECT * FROM course WHERE grade = ?"
Recordset1_cmd.Prepared = true
Recordset1_cmd.Parameters.Append Recordset1_cmd.CreateParameter("param1", 5, 1, -1, Recordset1__MMColParam) ' adDouble
Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Dim Repeat1__index
Repeat1__numRows = -1
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
<body>
<!--#include file="top1.asp"-->
<table width="760" height="300" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#76A022" style="border-left:1px solid #000000;border-right:1px solid #000000;border-bottom:1px solid #000000" >
<tr>
<td width="100%" height=35> <div align="center"><font color="#ffffff">学生选课</font></div>
</td>
</tr>
<tr>
<td width="100%" valign="top"><div align="center">
<form id="form1" name="form1" method="post" action="">
<label>
<select name="jumpMenu" id="jumpMenu" onChange="MM_jumpMenu('parent',this,0)">
<option>选择年份</option>
<option value="studentxuanke.asp?grade=2007">2007</option>
<option value="studentxuanke.asp?grade=2008">2008</option>
</select>
</label>
</form>
<script type="text/javascript">
<!--
Recordset1_cmd.ActiveConnection = MM_conn_STRING 哪里错了？
告诉我怎么改好不好？ 展开
2个回答
展开全部
MM_conn_STRING
未定义
未定义
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
