Here's a beginner's question for you...I have a checkbox list so that the user can select multiple filter options.Here's my SQL Statement configured to my SQLDataSource object:SELECT AVG(SessionFlow) AS SessionFlow, AVG(Materials) AS Materials, AVG(CBT) AS CBT, AVG(Activities) AS Activities, AVG(ClarityOfInfo) AS ClarityOfInfo, AVG(ClassLength) AS ClassLength, AVG(AnswerQs) AS AnswerQs, AVG(Patience) AS Patience, AVG(Presentation) AS Presentation, AVG(Knowledge) AS Knowledge, AVG(Timeliness) AS Timeliness, AVG(Preparedness) AS Preparedness, AVG(Motivation) AS Motivation, AVG(Participation) AS Participation FROM View_3 WHERE (Course = @Course) AND (Instructor = @Instructor) AND (CourseDate >= @CourseDate) AND (CourseDate <= @CourseDate2)
What I'd like to do is make it so that the Course object (Checkbox List) can be checked multiple times (Check multiple courses in the list).As it stands now, this statement will return results on the top-most item in the Course list.Any ideas as to how to gain full functionality here?Thanks!
SQL statement in SQLDataSource issue
Posted - 2008-11-19 : 12:28:12
