Viewing 15 posts - 166 through 180 (of 217 total)
Sushila, I wasn't sure where the shortcuts applied. What do I replace?
Thanks,
M
August 12, 2005 at 12:05 pm
Remi...why did you cross out those two lines? Just curious...
Thanks,
M
August 12, 2005 at 12:05 pm
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...
August 12, 2005 at 11:54 am
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...
August 12, 2005 at 10:29 am
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...
August 12, 2005 at 10:14 am
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...
August 12, 2005 at 9:35 am
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 =...
August 12, 2005 at 9:20 am
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...
August 12, 2005 at 8:55 am
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...
August 12, 2005 at 8:43 am
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
August 12, 2005 at 8:34 am
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...
August 12, 2005 at 8:18 am
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...
August 12, 2005 at 6:00 am
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...
August 11, 2005 at 2:55 pm
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...
August 11, 2005 at 11:51 am
Govinn,
I just made up JoeBob Computer Shop. It was just an example. Actually CMclientName can be any number of different names.
Thanks,
M
August 10, 2005 at 9:22 am
Viewing 15 posts - 166 through 180 (of 217 total)