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 derfloh 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
Edit: Now if the login is correct is should return the url: http://access.mysite.com/downloadnow/program.exe Now if the login is incorrect is should return the url: http://mysite.com/noaccess.html -
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
I've even tried: Set objParam = objCommand.CreateParameter("test",3,2,5) objCommand.Parameters.Append objParam msgbox objParam intSprocValue = objCommand.Parameters("test").value msgbox intSprocValue Still no return value. Please someone help me out :) -
Stored Proc Return Values
Sorry I edited the wrong line. I removed the @ signs and it does the same as it did before. It executes the stored proc and runs but it does not return the number 0, 101 or 201. -
Stored Proc Return Values
I removed them and I got the following error on the same line of code I just edited: "Arguments are of the wrong type, are out of acceptable range, or in conflict with one another" Thanks :) -
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
Buya its works great! Thanks PHV :) Star for you! Any help with the windows authentication question? How would I go about changing the login from trusted sql to windows authentication? Thanks alot :) -
User input for Sql Server Details
Also is it possible to use windows authentication if the script is run locally on the server? Because I was having issues since the default under security is set to "Windows Authentication Mode" and not "SQL Server and Windows Authentication Mode". Thanks :D -
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?
Sorry typo: SQLQuery = "CREATE TABLE [dbo].[tb_Excluded](" & _ should be: SQLQuery = "CREATE TABLE [dbo].[tb_DomainUsers](" & _ So I end up with a db and name domainusers and a table named domain users! Thanks :) -
List in Memory or text files?
Ok its working great! I also just realized I'll be making 700 mssql queries weather I add them to a temps files and read them back of if I do the query in the "if...then" check. One last issues i'm having is checking if the database/table i will be writing to exists or not! At the moment I can... -
List in Memory or text files?
OK thanks since I am the n00b I will take your advice :) Will update you when I try this later today! Cheerz for being so helpful :D -
List in Memory or text files?
Thanks :) Thats also a good idea! I was thinking of doing something along the lines of: If NumCommas = 4 Then WScript.Echo "Good String" WScript.Echo "Line added to Good.txt" Else WScript.Echo "Bad String" WScript.Echo "Line added to Bad.txt" End If ----... -
List in Memory or text files?
Sorry I just tried to make it brief as possible! From the beginning: I have a text file with 650 lines of info. Each should contain all of the following fields: Username, Name, Surname, Password, Email Yet some lines only contain 3 fields: Username, Surname, Email. I need to add all 650... -
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...
