Forum Replies Created

Viewing 15 posts - 136 through 150 (of 217 total)

  • RE: Multiple inserts

    wow...you know how to make a girl cry...

     

    Anyway, could you give me a hint as to why my design is all wrong?  Is it...

  • RE: Multiple inserts

    BTW, I'm sorry, my english is not the best.  Sometimes it's hard to type out an english sentence and make it sound comprehensive to a native english speaker.

     

     

  • RE: Multiple inserts

    But Remi, I'm sooooooo close!  With your invaluable guidance of course!

    I think I will take advantage of free tutition and take some VB/SQL courses in the fall!

     

  • RE: Multiple inserts

    Remi,

    You don't have to build it, maybe just explain it, but it would probably be faster to build it, then let me go get a good SQL book and explain...

  • RE: Multiple inserts

    Remi,  my fault...I had two tables switched around.  I am now getting UniqueIDs inserted into all the tables.

    Just a stupid-sounding question...now that this all "works"  How can one select columns from all...

  • RE: Multiple inserts

    Hey Remi! 

    It's working at 90%!  But for some reason, the UniqueIDs that are supposed to appear in every table, are turning up NULL....even in the first table!

    In the SP,...

  • RE: Server Errors

    You mean this line(red)?

    MyCmd.Execute exec_sp_biginsert

    MyCn.Close

    ReturnValue = CInt(MyCmd.Parameters("@Return").Value)

    Set MyParam = Nothing

    Set MyCmd = Nothing

    %>

     

    What do I do with it?  Just a response.write(ReturnValue)? or if ReturnValue=0 then response.redirect(success.asp) else response.redirect(failed.asp)?

     

     

     

  • RE: Server Errors

    Ha!

    I finally got it so that it displays no errors!  No errors!

    But now it's just a blank screen.  Is there a way to return a value or something so that I...

  • RE: Server Errors

    It was a problem with my include file...I fixed it, but now I get this error:

     ADODB.Connection error '800a0e79'...

  • RE: Server Errors

    I assume it's working...I have this line in there:

    <!--#include virtual="adovbs.inc"-->

    and I put that file in the same directory as the script.

     

    Thanks!

     

  • RE: Server Errors

    I figured how to get rid of that error message and get "real" error messages. 

    In IE, goto Tools -> Internet Options->Advanced and turn off Friendly Error Messages...

     

    BTW, the "real"...

  • RE: Multiple inserts

    Well, I'm not a dude...I'm a dudette.

     

    Anyway, I already got the SP to work that we talked about for like 5 pages of...

  • RE: Multiple inserts

    should I just take out the 'MyCmd.Execute' at the top of the script?  Or should I take out all the lines:

    Dim MyCn

    Set MyCn = Server.CreateObject("ADODB.Connection")

    Set MyCmd = Server.CreateObject("ADODB.Command")

    MyCn.Open = "DSN=OSUNet;UID=xxxx;PWD=xxxxxxxx"

    Set...

  • RE: Multiple inserts

    Remi, I noticed something in that big script...I have MyCmd.Execute at the beginng AND the end...

    Dim MyCn

    Set MyCn = Server.CreateObject("ADODB.Connection")

    Set MyCmd = Server.CreateObject("ADODB.Command")

    MyCn.Open = "DSN=OSUNet;UID=xxxx;PWD=xxxxxxxx"

    Set MyCMd.ActivateConnection = MyCn

    MyCmd.CommandType = adCmdStoredProc

    MyCmd.CommandText = "dbo.sp_biginsert"

  • RE: Multiple inserts

    doh!

     

Viewing 15 posts - 136 through 150 (of 217 total)