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

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.

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!

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

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

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

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)?

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

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

 ADODB.Connection error '800a0e79'...

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!

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

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

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

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"