如何改变DropDownLis使得Repeater里内容更新？

Question

有三个表
Mark
markid | recorderID | tatalScore
1 319 10
2 320 30
Recorder
testID | recorderID | userID
5 319 aa
6 320 bb
Test
testID | testName

5 数学

6 英语

我的Repeater中的查询本来是SELECT Place=(SELECT COUNT(DISTINCT totalScore) FROM Mark WHERE a.totalScore >= a.totalScore),b.userID, a.totalScore FROM Mark AS a INNER JOIN Recorder AS b ON a.recorderID = b.recorderID ORDER BY Place
DropDownLis中是数学，英语之类的集合
当我想更新Repeater时，将查询改为
SELECT Place=(SELECT COUNT(DISTINCT totalScore) FROM Mark WHERE a.totalScore >= a.totalScore),b.userID, a.totalScore FROM Mark AS a INNER JOIN Recorder AS b ON a.recorderID = b.recorderID
where b.testID=(select testID from T_Test where testName="+ DropDownList1.SelectedValue+")
ORDER BY Place
为什么无法查询出来？

Answer 1

http://www.0531s.com/content-52-2062047-1.html