Upload List Of Employee Numbers into ASP page

[Colin Steadman]

I have an ASP site that allows the user to submit an
Employee Number to an Oracle procedure. The procedure
does some calculations and the results are displayed in
the browser.

Now, the user would like the ability to submit any number
of employee numbers all at once (though not display the
results).

I think this can be done, but I'm not entirely sure how to
go about it? I think the way to approach this would be to
get a comma separeated list if employee numbers and
convert it into and array using SPLIT, and then churn
through the array and pass each record to the Oracle
procedure.

So my question is, how do I get the comma separated list
into ASP? There could be as many as 6000+ entries in the
list.

TIA,

Colin

[Aaron [SQL Server MVP]]

You could pass a limited number of comma-separated values to a single stored
procedure, which should scale much better. Not sure if you could do 6000 at
once, but maybe they could take two swings at it. See
http://www.aspfaq.com/2248 for an example in SQL Server; should be trivial
to build something similar in Oracle. I can pretty much guarantee that this
will be more efficient than looping through and calling a single stored
procedure 6000+ times.

--
http://www.aspfaq.com/
(Reverse address to reply.)


"Colin Steadman" <an*******@discussions.microsoft.com> wrote in message
news:53****************************@phx.gbl...

I have an ASP site that allows the user to submit an
Employee Number to an Oracle procedure. The procedure
does some calculations and the results are displayed in
the browser.

Now, the user would like the ability to submit any number
of employee numbers all at once (though not display the
results).

I think this can be done, but I'm not entirely sure how to
go about it? I think the way to approach this would be to
get a comma separeated list if employee numbers and
convert it into and array using SPLIT, and then churn
through the array and pass each record to the Oracle
procedure.

So my question is, how do I get the comma separated list
into ASP? There could be as many as 6000+ entries in the
list.

TIA,

Colin