Sushila, I wasn't sure where the shortcuts applied.  What do I replace?

Thanks,

M

Remi...why did you cross out those two lines?   Just curious...

Thanks,

M

Remi,  I tested the SP and it worked beautifully.   You are a genius...I really do hope you make big $$$.

I'm still trying to figure out the ASP part.  I just...

Thanks!

If I put the code in the ASP page, do I still need to write out all this?

Dim MyCmd As ADODB.Command

SET MyCmd = SERVER.CREATEOBJECT ("ADODB.Command")

MyCmd.CommandText = "dbo.sp_biginsert"

MyCmd.CommandType = adCmdStoredProc

Dim MyParam...

So I just include this function in the asp page, then call it like this?

Big insert Page

---------------

....populate form(from hidden fields) to user so he/she can make any needed changes.....

....user hits submit...

Remi, could you please explain to me why I need this function? What does it actually do?

I thought after I created the stored procedure, I could just call the...

Remi,  why do I need to write out the following for every variable?  I'm not sure why I need this gigantic function.

MyCmd.Parameters.Append MyParam

Set MyParam = New ADODB.Parameter

MyParam.Name = "@SRhospitalCanvass"

MyParam.Value =...

Remi, you work for a school?  Which one?

Anyway, I read on some website that using adovbs.inc is outdated.  Instead they reccomended using a Type Library.  Would this Type Library work...

Holy Cow Remi!

I hope you make at least $250,000/yr!! 

But now I have a question...what the heck is all this??  What is MyCmd, MyParam?

What do I need to translate?

I'm totally lost...

Wow! That worked! No errors! 

What does the Select @Err=@@ERROR do and NOCOUNT do?

Is my stored procedure all done?  Now I just need to add this to my asp script?

THANKS!

M

Well, I put this all into SQL Query Analyzer, and I got a bunch of messages.  I don't understand why it's complaining about QuitWithRollBack, because I do have it declared...

Hi guys,

First off, a big THANK YOU.  You guys are awesome. I feel like I should pay you, but I'll pay back the board by trying to help others with...

Hey guys,

Ok, I've decided to stick with the stored procedure.  I have written out all the variables and all of the insert commands.

Now, I'm kind of lost. What do I...

Hey guys, it's me again...I've been doing some research on stored procedures, and thinking about all the advice I receieved.

I started to write out all the variables that the stored...

Govinn,

I just made up JoeBob Computer Shop.  It was just an example.   Actually CMclientName can be any number of different names. 

Thanks,

M