以下是引用zhangbo787在2007-6-1 21:01:42的发言:<%
studentnum = trim(request.form("txtstudentnum"))
courseid = request.Form("lstcourseid")
if studentnum <> "" then
ssql = "select st.student_name, st.student_id, co.course_name, " & _
"co.course_id, sc.score from scores students "
ssql = ssql & "inner join courses co on co.course_id = sc.course_id"
ssql = ssql & "inner join students co on sc.student_id = sc.student_id"
ssql = ssql & "where st.student_num = '" & studentnum &"'"
ssql = ssql &"and co.course_id = " & Cint(course_id)
set rst = cnn.execute(ssql, ,adcmdtext) 第 58 行
if rst.eor then
%>
错误类型:
Microsoft JET Database Engine (0x80040E14)
语法错误 (操作符丢失) 在查询表达式 'co.course_id = sc.course_idinner join students co on sc.student_id = sc.student_idwhere st.student_num = '04010210'' 中。
/chengji/editscore.asp, 第 58 行
浏览器类型:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Maxthon)
网页:
POST 91 ??? /chengji/editscore.asp
POST Data:
txtstudentnum=04010210&lstcourseid=%B6%E0%C3%BD%CC%E5%C9%E8%BC%C6&%B2%E9%D1%AF=%CC%E1%BD%BB
自己检查我所标识的蓝色部分,是否写错了?特别是加粗部分!