I'm learning ASP as I go, so newbie-oriented feedback is most appreciated!

I have a stored procedure on my MS-SQL server. It uses four variables to perform bulk record creation and pre-fill the values of certain fields in new rows.

To execute this query on the db server, the command would be:

<pre id=code><font face=courier size=2 id=code>EXECUTE AddNRecordsSP @noofrec=w, @pCode='x', @cCode='y', @sCode='z'</font id=code></pre id=code>

w,x,y and z are values that would be specified at run-time.

How can I create a form on an ASP page that will collect the values for w, x, y and z, then execute the stored procedure using these values when the user submits the form?

you should be able to use a command from the server behaviors palette. You can browse to the stored proc using the little database explorer at the bottom.
Once you choose it, it will autopopulate the fields for you set runtime values for your parameters.

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/