Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to get a Return URL
Hi, I would like to send a http command: hxxp://username:password@mysite.com/downloadnow/program.exe Now if the login is correct is should return the url: http://mysite.com/downloadnow/program.exe Now if the login is incorrect is should return the url: http://mysite.com/noaccess.html Thats... -
Stored Proc Return Values
Hi Guys, I'm busy with a script and have decided to call a sproc and return the result to VB. Here is the sproc: CREATE PROCEDURE pr_Cleanup BEGIN TRAN TRUNCATE TABLE tb_Users IF @@ERROR <> 0 BEGIN ROLLBACK TRAN RETURN 101 END TRUNCATE TABLE tb_Excluded IF @@ERROR <> 0... -
User input for Sql Server Details
Hi, I have the following connection string: Set objConn = CreateObject("ADODB.Connection") objConn.Open "Driver={SQL Server};" & _ "Server=127.0.0.1;" & _ "Database=Master;" & _ "user id=test;" & _ "password=test;" Set... -
List in Memory or text files?
Hi guys, After sorting through a text file with my VBS scripts I end up with 2 collections of entries. 1 with collection will have 650 lines and the other 1 will have 50 lines. Question now is do I create 2 lists in memory perform my SQL queries on them? or Do I create 2 temp text files and...
