Forum Replies Created

Viewing 15 posts - 166 through 180 (of 217 total)

  • RE: Multiple inserts

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

    Thanks,

    M

  • RE: Multiple inserts

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

     

    Thanks,

    M

     

     

  • RE: Multiple inserts

    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...

  • RE: Multiple inserts

    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...

  • RE: Multiple inserts

    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...

  • RE: Multiple inserts

     

    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...

  • RE: Multiple inserts

    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 =...

  • RE: Multiple inserts

    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...

  • RE: Multiple inserts

    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...

  • RE: Multiple inserts

    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

     

     

  • RE: Multiple inserts

    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...

  • RE: Multiple inserts

    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...

  • RE: Multiple inserts

    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...

  • RE: Multiple inserts

    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...

  • RE: SELECT from multiple tables

    Govinn,

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

     

    Thanks,

    M

     

Viewing 15 posts - 166 through 180 (of 217 total)