select bh,xm,km,cj,bj,xq,xn
from(
SELECT student.bh,student.xm,student.bj,score.km,score.kt,
score.zy,score.cy,score.sjys,score.sjys*0.3 as sjbl,
score.llys,score.llys*0.4 as llbl,score.xq,
score.kt+score.zy+score.cy+score.sjys*0.3 +score.llys*0.4 as cj,score.bz,score.xn
FROM student,score
WHERE student.xh=score.xh and xn='' and xq='' and bj='' and km='') as a
where cj <60
order BY bh,km
--没有传递过去?何意?
from(
SELECT student.bh,student.xm,student.bj,score.km,score.kt,
score.zy,score.cy,score.sjys,score.sjys*0.3 as sjbl,
score.llys,score.llys*0.4 as llbl,score.xq,
score.kt+score.zy+score.cy+score.sjys*0.3 +score.llys*0.4 as cj,score.bz,score.xn
FROM student,score
WHERE student.xh=score.xh and xn='' and xq='' and bj='' and km='') as a
where cj <60
order BY bh,km
--没有传递过去?何意?
xn=request.form("xn")
xq=request.form("xq")
bj=request.form("bj")
km=request.form("km")
在这个位置都是'' 楼主应该检查下,有没有值传入。