I'd like to send a variable generated in the script back to a batch file.
I can run the batch file by using objShell.Run(lock.bat filename). My
batch file lock.bat runs fine with the argument "filename", the
problem is that "filename" is actually a variable that is created in
the script and I want the value passed to the batch file, not the
label. Any ideas/sampe code
Im trying to use teh command line, for now i just want to do something realllly basic like opening a txt file. and then later i can do some more advanced stuff, but for now i just want to know if i can use the command line, right now i just have Code:
<%
Dim oShell,sCommand
sCommand = "test.txt C:"
Set oShell = Server.CreateObject("Wscript.Shell")
oShell.Run sCommand, , True
Set oShell = Nothing
%>
What is the proper syntax to run this command line in ASP?
wzzip.exe File.zip File.txt
Does anyone know how to execute command line in ASP?
View Replies View RelatedI want to know IExplore.exe command line options, basically I want the command line equivalent of the following line:
Window.open(strUrl, winID, "toolbar=no, scrollbars=yes, location=no,
statusbar=no, menubar=no, personalbar=no resizable=yes, left = 50, top =
25");
I have this command-line which I do execute it manually.I am curious if anyone can help to execute the command-line from an asp page using vb.
View Replies View RelatedI am running a dynamic site using MySQL and ASP and wish to back up my MySQL DB on a daily or weekly basis to a remote server/MySQL DB. I know how to do this from the command line using MySQL:
mysqldump -u username -p password --databases myDatabase | mysql -u username -p password -h remote.server.com
But i need to be able to issue this command from within an ASP page. PHP has various methods for executing command line queries such as exec() & shell_exec() but I don't know any using ASP.
Can someone give me some sample code on how one would go about executing a
command line "command" from within an ASP form?
We need to run an application called GnuPG which allows us to encrypt an
email.
Preferably some documentation directly on this would be good but any other
docuemtnation on executing a command line "command" would be great!
I need an ASP code that will pass some variables as options to a command line.
Let's say I need to execute a program with some options and I need the user
to select the otions from the web interface.
The command line will look something like this:
Program.exe /usename:username /password:password /options:option1,option2,option3
The the user will access a web page and it will be asked for the username , password and
it will be able to select the options by marking them on the page.
After the selection the command line will be executed with the selected oprions.
If somebody can point me to some example code or any hints to get me started I would
appreciated it.
It is possible to specify also the credentials the "program.exe" should run under?
I am using command line utility of wzzip.exe in asp and vb script. When I try to use wzzip in asp, it sometimes works fine and sometime hangs. It doesn't give any error.
The server that the process is running on, if I logoff from that server, wzzip.exe hangs, however when I just "disconnect" from the server, it runs fine. This happens when I try to use wzzip.exe from my user interface. The code to invoke the shell is in a dll which resides in MTS. I am using the following wzzip command in asp.
cmd.exe/c "c:Program fileswinzipwzzip.exe -a
servernamefolderfilename.zip servernamefolderfolder_to_be_zipped
When I run it manually command line, there are no problems.
I have a similar job which I have in vbscript, that job runs without any
issues.
I am using this code:
[code].....
to send email, however i get error '8004020f' on the objMessage "send" line
this code works usually, however for some reason i get this error on this site.....
I am getting the above error when trying to execute the following code:
View Replies View RelatedI had created a macro to read data from an excel sheet and write the values to a text file. I had used "ActiveSheet.Range("GB" & k).Value" command to read the values from the excel.some cells in the excel sheet is having two lines value and four lines data, the text file is generating that value in a single line. (Ex. the cell value in address column is in four lines and should display in four lines in the text file generated from the macro)
Can i do something in the excel sheet or in vb script to read the address value line by line and write line by line in text file?
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c' Command Text was not set for the command object. Code:
I have an online application. I get the following error when a user selects an option from one drop down list but doesn't select an option from another drop down list. Here is the error:
Microsoft OLE DB Provider for SQL Server error '80040e0c'
Command Text was not set for the command object.
Line 87
Line 87 = rs1 = conn.execute(finalSQL)
Here is the page causing the error. Code:
I keep getting this error. I searched the forums, and found one. It said to basically replace elseif with else. It worked for that person.
I tried it and it didn't work. So what i decided to do was, remove all of the if statements and keep one. Even with just one if statement i get the same problem. Does anybody know what is wrong? It worked fine, up until i added the if statement. I need them there though for a reason.
Personally i think, it;s not getting the value from the request form, and hense it isn't picking anything up. What do you lot reckon? Code:
I have an encrypted .txt file created by asp. Its formatted with lines etc. Title followed by description underneath. I need to read this into ASP now, and parse it line by line. On each line read, run the function to unencrpt and add line to a new file.
Its the line by line Im having trouble with. If i do the full textstream no formatting takes place coz im adding the fulltextstream all in one addline call. How can I loop through lines ?
i am trying harder to mix this 2 solutions... but without success... the below on seen to be grabing a template and replace the data with the values posted in a form Code:
View Replies View RelatedI am getting the above error in an asp page. Not sure why? The error details is given below. Code:
View Replies View RelatedI have a form that uses the POST method to call up test.asp and it
passes what is typed into the text box. Since is uses the Like command
the user can enter stuff like %Constant% to get something that is like
what the user typed in. When I call up the test.asp page it is grabbing
the text fine but isn't running the SQL command the correct way. The
SQL command ends up being:
SELECT * FROM [Everyone] WHERE (Name LIKE ':: & strName & ::')
Here is my code
strName = Request.Form("Search")
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.RecordSet")
Conn.Open "PhoneList"
sSQL = "SELECT * FROM [Everyone] WHERE (Name LIKE ':: & strName & ::')"
Set Rs = Conn.Execute(sSQL)
Given a class called Foo, I can do:
Set f = New Foo
But is there a way to instantiate a class and pass a parameter into it as well, such as:
Set f = New Foo("joe")
If so, then how does class Foo look like to accept such a parameter?
How can I run a CLI command from asp page?
Please guide me.I have hard coded the variables. I need drections and see if my method is right.
Dim shell
Set shell = CreateObject("WScript.Shell")
shell.Run((im editissue --field= "state = verified" --field = "user = abc" 15947)
Set shell = Nothing
does any body have a command that enables you to talk to another computer on a network
like A instant message.
How can I run a DOS command from my ASP ?(prefer to use html/vbscript solution rather than 3rd party add-ons)
View Replies View RelatedI am using DW to create this ASP page and I need to do a simple calculation that will result in a cell being 10% of the previous cell. I am using this statement:
<%=(rsReferingAgent.Fields.Item("ReferingAmount").Value * .1)%>
Now, all I need to know is how to get it to only display two decimal places instead of multiple decimal places.I need the result to look like this:
$1,234.45
and not:
1234.4573
I would like to use the sql command to query the database from ASP. But it keep showing me the error. Select location from the table tapeinfo. The location must start with "Data". Here is the command?
'sqlStrl="SELECT * FROM tapeinfo WHERE location like ' "&Data&"% ' "
Anyone can help me to verify whether it is correct?
I have a form that uses the POST method to call up test.asp and it passes what is typed into the text box. Since is uses the Like command the user can enter stuff like %Constant% to get something that is like what the user typed in. When I call up the test.asp page it is grabbing the text fine but isn't running the SQL command the correct way. The SQL command ends up being
SELECT * FROM [Everyone] WHERE (Name LIKE ':: & strName & ::')
Here is my code
strName = Request.Form("Search")
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.RecordSet")
Conn.Open "PhoneList"
sSQL = "SELECT * FROM [Everyone] WHERE (Name LIKE ':: & strName & ::')"
Set Rs = Conn.Execute(sSQL)
I have the following code in a function: Code:
dim weight, cubic, length
weight = request.form("25k")
cubic = request.form("4CF")
length = request.form("2m")
Some of these could be null but what i need to do is caputre the highest number and place that in a database. I assume i can use the max command but a bit unsure how to do it.
I am having trouble trying to figure out how to properly enter a checkbox in the SET statement so I can update the checkbox value based on user's input.
I know for number values you enter the variable like this:
Code:
Owner = own
and for text you enter like this:
Code:
Priority = 'pri'
and for dates you enter the variable like this:
Code:
tdate = #td#
but how do you create the variable in the SQL statement so it updates a checkbox value?
Below is my SQL statement, and the checkbox name is "Active" Code:
I am using the below command to restart a service on one of my web
boxes, this runs fine from the command prompt and also through a *.bat
file.
"Server1Applist$BOBJCentralMSpsservice.exe" Server2 -u
eutee-ww02pUsername -p password restart BOBJCentralMS
I found this asp code in this forum but can not get it to work with my
command
<%
Dim oShell, sCommand
sCommand = "MyCommand"
Set oShell = CreateObject("WScript.Shell")
oShell.Run sCommand, , True
Set oShell = Nothing
%>
I replace "MYCommand" with the command i wish to execute but the page
just hangs with the blue status bar halfway complete at the bottom,
when checking the services on the box it is not restarted.
<INPUT TYPE="SUBMIT" VALUE="New Message" Style="Width:100px">
How can I change the font type and font size of value="New Message"?
Except create a customized button in photoshop as an image file.
i build my sql string by using bunch of if-end if statements, after storing the whole SQL string into variable strSQL i put into the command object's CommandText property like so:
objCommand.CommandText = strSQL
Set rsRec = objCommand.Execute 'rsRec being a recordset
then i want to be able to display the data:
While Not rsRec.EOF
Response.Write(rsRec("FIRST_NAME") & " " & rsRec("LAST_NAME") & " - " & rsRec("FIRM_NAME") & _
" " & rsRec("EMAIL") & " " & rsRec("CITY") & "<BR>")
rsRec.MoveNext
Wend
but this gives me an error saying:
Object doesn't support this property or method: 'CommandText'
i take it from websites that the UNION command merges results into one or more tables.
SELECT Bookings.Room As Bookings, Classes.Room AS Classes
FROM Bookings, Classes
this JET query takes info from BOOKINGS.ROOM into the temp. table Bookings and everything from CLASSES.ROOM into the temp table Classes.
How, using the UNION command can i merge the two temp. tables together?