I've created email function which can be used to sent an email to student regarding their classes, programs and whatsoever.
In that case, i have a list of methods which im represented it in checkbox list. The methos are :
For method by campus, i have 2 values (campus branches). For examples,(1) branch in New York and (2)Branch in London.
For method byPrograms, i have a lot of list by programs.
Now, i do not have problems if we choose the checkboxlist bycampus and byprograms or byclasses.
But the problem is, if i choose bycampus only and i choose both campus branches (London and New York), the email interface did not appear. And when check the query through msgbox, the query filter (the value of the campus appear like this) :
select s.email from student s where s.campusid =1 and s.campusid =2.
I want the query to be like this :
select s.email from student s where s.campusid in(1,2).
I've tried so many ways to make the correct format of query but still didnt work.
FYI, all the queries is in the database.
Did anyone of u guys can help me? i really appreciated it :)
View Complete Post