Launch Sqlcmd In VBScript And Save Results To Variable
I want to use vbscript to run a script multiple times and save its results to a text file. I have practically wrote this script before but only using a sql command wrote in to the script. However, this is a lengthy sql file so can not be directly entered in to the vbs script,s o I would like to run it using sqlcmd.
"SQLCMD -S "&WScript.Arguments(0)&" -i "&WScript.Arguments(1)
I have tried Googling this problem but found very little information about it. Any discussions online that I have found show no code and assume you already know how to do it.
I have found this so far:
Set objShell = CreateObject("WScript.Shell")
Set objScriptExec = objShell.Exec("sqlcmd -S "&WScript.Arguments(0)&" -i "&WScript.Arguments(1))
But how do I get hold of the results in to some kind of variable?
View Replies
ADVERTISEMENT
I'm writing an intranet-only browser based application. I need to launch either a SETUP.EXE that is on a network drive or a shortcut on a local drive that points to the exe on the network drive
I already know how to launch a local exe, for example:
Set objApp = CreateObject("WScript.Shell")
objApp.Run "cmd /C CD C: & Program Files & SomeFolder & SETUP"
View Replies
View Related
This seem to be a simple question, but I'm having no luck with Google
keywords...
I have an some ASP in which I open a recordset via a connection to a MSSQL
database. I don't want to keep the database connection open while I'm
processing the data from the resulting recordset.
Is there a method that I can use to copy the recordset into an array
(collection, etc), the close my DB connnection and finally process the data
I copied from the recordset?
View Replies
View Related
I have a batch file that takes variables from the cmd and passes them by sqlcmd to an SQL script. When I pass the variable 'MikeTestList' the script runs as expected with no problems. When I passed 'BulkTransferTest' I got an error message, 'The string or binary data will be truncated'.
Some testing has shown that I get the error when the string is anything above 12 characters. Is there a limit to the length of a string you can pass using sqlcmd from a batch file? Is there any way around it?
Also, if I have a space in the string, it only passes the string up to the space. I have tried to fill it with a '%' which then gets passed as is, so the % stays in place through out the script. Code:
View Replies
View Related
I have an ASP project where I have users select or input values into a criteria page and then once they press "Submit" the ActiveX viewer displays the crystal report. All works fine and the criteria can be somewhat dynamic because the variables are used to build a SQL statement that is passed to the crystal report as the dataset.
What I would like to do is create a variable on the Crystal report that will display the SQL statement or at least an English translation. This variable will be used to display the criteria of the report so end-users can see what criteria was used to generate the output of the report.
View Replies
View Related
I'm dividing two variables and on some instances the results going to be a long decimal. I want the decimal to round up to only one pace tho. How could I do something like that? My coding looks like this.. Code:
readscore=rsgameinfo("readerscore")/rsgameinfo("readervotes")
View Replies
View Related
I want to pass a variable by way of a querystring (or any way that's possible) from flash (actionscript) to vbscript. From there I want to save the variable into a MySQL database. I understand the vbscript part but how would I transfer a querystring from a flash program to vbscript?
View Replies
View Related
This is my VBScript function:
<script language="JavaScript" type="text/JavaScript">
Dim UN
Set objNet = CreateObject("WScript.NetWork")
Set objUser = GetObject("WinNT://my domain/" & objNet.UserName )
UN = objNet.UserName & " (" & objUser.FullName & ")"
</script>
How can I reference the VBScript Variable UN in my ASP code? <%=UN%> won't work because VBScript is on the client side and ASP is on the server side. If I have to post it on one page and read it on another, how do I do that?
View Replies
View Related
I have the following code in an ASP page but it does not seem to allow a JScript to access VBScript variables. But if a VBScript accesses a variable in declared in a JScript TAG then it seems to work.
<SCRIPT LANGUAGE ="VBSCRIPT" RUNAT="SERVER"
Dim tes
test = 10
</SCRIPT><SCRIPT LANGUAGE ="JSCRIPT" RUNAT="SERVER"
Response.Write(test)
</SCRIPT>
View Replies
View Related
I tried the search function but I can't really identify what this kind of issue would be called (Searching store variable comes back with hundreds/thousands of hits).
I am doing an update form which opens 2 SQL connections (its easier for me to do this cause I mess up joins to a significant degree, that and performance is not a big worry, eitherway).
<notes> Both connections are open, one is called rs, the other is called articlers. I have 2 databases (named database1, and database2), and I have two different SQL strings (SQL and articleSQL, the problem comes in the 2nd string and in storing a variable. Code:
View Replies
View Related
<%@ Language=VBScript %>
<%
dim a
dim b
a=11
b="11"
if a=b then
Response.Write "a=b"
end if
%>
But can't shows "a=b".How can changes variable type?
View Replies
View Related
I have an input box when the user clicks on the button.
var number=prompt("enter journal number");
How is it possible to pass this variable forward but to vbscript? So i could use that variable in an sql procedure?
View Replies
View Related
I have a Function in VB Script that generates a signature. I assign the result to a variable and then need to do a hidden post to an ASP Page for further processing.
Basic functionality is I have a button upon pressing it -- It does the hidden post.
Code looks like this. Please assist with passing this stringToSign variable to the .asp page via hidden post. Code:
View Replies
View Related
Is there a way I can assign a value of true or false to a VBScript variable? I have a function where I want to initiate a value of false: Would this work? Code:
View Replies
View Related
I'm using Javascript for my site, using Dreamweaver to create the pages. On my SQL Server I have created a DTS package that first recreates a table and then imports an Excel file.
I have created a Stored Procedure to launch this package. This part works great if launched from Query Analyzer. I want a user to be able to push a button which will launch the Stored Procedure and then return the results of how many records were imported.
View Replies
View Related
From an asp page, i'm trying to auto-open a pop-up page if something exists. I can do this within access via vba using below code.
Anyone know how I could modify the below js to auto-lauch from asp?
sPage = "javascript:
resizeTo(478,500);moveTo(130,150);document.locatio n.href='http://myserver/myweb/mypopup.asp"
sApp = "c:Program FilesInternet Exploreriexplore.exe"
sCommand = sApp & " " & sPage & "'"
Call Shell(sCommand, 1)
View Replies
View Related
I work on an existing application in ASP, which requires an access to DBAccess. I work on Win2K Professional and launch ISS. I have created both an administrator and a user count. The fact is that I can't launch ASP file in a browser. It results in asking me whether I want to register the file or whether I want to open it with an application on the hard disk.
I use FrontPage to edit ASP files. Using this software allows me to see the result of html but not the results of query (using DBAccess). I have yet declared an ODBC source refering to my Access database. I have also nstalled IIS.
But I can launch it only when Administrator!?? I have declared a virtual path to my web pages. But impossible to attain them in Netscape or IE.
View Replies
View Related
I'd like to launch an executable file from a web page. Basically, the user
enters seven parameters and then clicks a button to generate a graph. The
input is written to a file and then read by the exe. The exe then generates
a graph based upon the input parameters.
I am reading about the Process class and wondering if that is the best
approach to this. Can you recommend a KB article?
View Replies
View Related
I would like to run an ASP page each day at the same time automatically. it reads from my product data and ftps the data to another server.
I am running on a windows system with IIS I have no idea where to begin. Is there anything else I can do? it is not my own server so I don't have access to server. I can just ftp.
View Replies
View Related
I want to add an 'edit' link next to certain images that appears in my ASP application. When this link is clicked I want it to open an editor such as PhotoShop or MS Office Picture Manager with the picture. The only thing i can get it to do is to display the picture in the browser or ask me to download or execute the program.
I did some searching but couldn't find anything to help. It looks like other users with similar questions just gave up.
View Replies
View Related
I'm turning my application into a "DLL". Everything worked fine untill I try to do a "While" in my asp code. Then I recieve an error like this:
"Object variable or With block variable not set"
My vb code look like this.....
View Replies
View Related
is there any way of passing a javascript variable over to a asp variable so
i can write it to my database.
View Replies
View Related
How do I convert an ASP variable to a Javascript variable?
View Replies
View Related
I would like to have an option for my end users to do a SAVE AS. Is there a way to do this? I have a excel spreadsheet which is being created by asp and at the end of the page I would like to have an option to do a save as. so they can name the file and put the file anywhere they want.
View Replies
View Related
Working with an asp page which pages through dates. If the
user saves one page as a mht file and pages to the next
day and saves the second page as a mht file, both files
turn out to be the same. It's as if I.E. 6 saves the
cached information, however if you open a new window and
save the page from that window it saves properly and the
cached information is available for the second window so I
think I'm on the wrong track.
View Replies
View Related
i need to force a download to open save as dialog box rather than opening the doc in a browser.
View Replies
View Related
Is it possible to have line feeds/breaks automatically entered when the text wraps to a new line? I am using a <textarea> input on a form and using the <pre> tag when displaying the text to a html page (embedded in a .asp page). The text is being saved to a sql database. Returns seem to be displayed. But the wrapped text just displays as one long line.
View Replies
View Related
beside save as htm and txt in IE , can i save as jpeg or other formats ?
View Replies
View Related
can any one giv me some link or any helping material , how i can can pic in acces or sql database regarding by user ....
View Replies
View Related
I need to save a lot of pages to a .doc MS Word file with one button click on my asp app.... can this be done ?.....I am thinking this .doc file will be saved on the server, so I can then download it to the users PC.
I can have the MS Word templates to fill out on the server , so do i create an asp page to fill out these templates and then save the file..then somehow download it automatically, hence it will end up on the users PC in a shared Dir...is this all possible?
View Replies
View Related
I would like to save a web page to a file. When I do that, sometimes
the saved web page does not look like the original web page.
For example, when I save www.msn.com, it looks very different the
original page.
How can I save the web page to look like the original (as if I do
"File" - "Save As" and under "Save as Type" select "Web Page, complete
(*.htm,*.html)" ?
This is how I save the web page:
Set fs = CreateObject("Scripting.FileSystemObject")
Set filePtr = fs.CreateTextFile("c:abc.htm", True)
filePtr.WriteLine (WebBrowser1.Document.body.innerHTML)
View Replies
View Related
whats happening is i do a form post from a form "A", to a form "B" where
it does some processing and then does a form.redirect to form "C"..where
there is a link to the form "A". I only want that when the user selects
form "A" from form "C" then at least i should be able to display his
name and email address what he had entered previously.
what the best way to save the variables and when i display back in the
form how do know whether hte form is coming back or not?
View Replies
View Related
is there a avaialble code in asp.net...
that have a similar function to Save as Dialog
View Replies
View Related
