<business>

1)I have table with 50 columns.

2)Some require input.

3)I have input form with both required and

non-required questions.

4)On submit request.form.count loops through data

received.

5)Dynamic insert sql string built based on entires.

Insert commit, missing values left null.

</business>



<problem>

I want to put this into a stored proc.

1)I've created stored proc with ALL columns initiated.

 Columns that ARE NOT required to null.

ex.  @user nvarchar(30), @firstname nvarchar(30)=null

ex. @user is REQUIRED, @firstname NOT required

2)I do this so that fields not received by stored proc

will be set to null.

3)I've tried to dynamically create the 

other_parma = other_parma & " p.Append

cm.CreateParameter("& """@"&fieldname(i)&""",

adVarChar, adParamInput,80, """&fieldvalue(i)&""")"

like the sql statement.  

4)I kept getting errors, so I tried hard coding it

with only required values.  I keep getting 

[Microsoft][ODBC SQL Server Driver]Optional feature

not implemented

5)How do I go about doing what I'm trying to do?

</problem>

Thanks