OK, I frankly have no idea where to begin with this.

We have an ASP page on an NT 4 with IIS4.
We have SQL Server 7 running on that machine also.
I am creating a VB component that the ASP script will call and that accesses the SQL Server 7 data.

On the ASP script we have this:
2 listboxes with Subjects and Type that the user can choose from. The Subjects listbox is a multi-select, so that the user can select more than 1 Subject. They can only choose 1 type.
In the Subject box we also have "All Subjects" and in the Types box we also have "All Types"

So, from the ASP page, we can get these possibilities:

All Subjects, All Types
All Subjects, 1 Type
1 Subject, All Types
1 Subject, 1 Type
2+ Subjects, All Types
2+ Subjects, 1 Type

OK. I pass this information to the VB component (not sure how the multi-select is going to pass the VB component yet but that's something else). Now...in my VB component what do I send to SQL Server...I've been creating stored procedures for the other types of selections a user can do and they work fine.

I noticed that in VB you can choose "adArray" as a datatype but I don't find any Array datatype in SQL Server.

Is it possible to use this adArray and set a command object to a stored procedure and have the stored procedure then put all the fields together?

I just really have no clue as to what to do to accomplish this, so if anyone has any comments, they would be greatly appreciated.

Thanks much in advance!
--Dan