>I am having to compare a string with a multiple selected items from a list box.
>Ex:
>
>select all a.cname, b.csemester, b.cccourse, b.cstudent from sysMast a, enroll b where rtrim(b.semester) == thisform.listBox.value(this is a multiple selection list box and I am having to compare
>rtrim(b.semester) with all the item selected in the list box)
>
>How can you do this? can you do a some kind of loop in the select statement.
>
>Thank you for any help
After you have created a cursor with all the selected values from your listbox, the SQL would be something like:
select all a.cname, b.csemester, b.cccourse, b.cstudent from sysMast a, enroll b where rtrim(b.semester) in (select listboxvalue from crsTempCursor)
Mark McCasland
Midlothian, TX USA