Viewing 15 posts - 136 through 150 (of 217 total)
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...
August 22, 2005 at 2:12 pm
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.
August 22, 2005 at 1:58 pm
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!
August 22, 2005 at 1:56 pm
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...
August 22, 2005 at 1:26 pm
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...
August 22, 2005 at 12:49 pm
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,...
August 22, 2005 at 10:39 am
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)?
August 19, 2005 at 2:13 pm
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...
August 19, 2005 at 1:59 pm
It was a problem with my include file...I fixed it, but now I get this error:
ADODB.Connection error '800a0e79'...
August 19, 2005 at 1:25 pm
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!
August 19, 2005 at 1:16 pm
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"...
August 19, 2005 at 1:08 pm
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...
August 19, 2005 at 12:04 pm
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...
August 19, 2005 at 11:49 am
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"
August 19, 2005 at 11:33 am
Viewing 15 posts - 136 through 150 (of 217 total)