ASP :: Executing A Command Using Asp

Executing A Db Command
when i want to do an action to the database i am using the command

Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("photoalbum.mdb") & ""
Set RS1 = myConn.Execute(SQL1)

is there something else i can use if it is only an INSERT statement in the sql because i dont actually need to create a recordset ?

Executing A Command Line Applications...
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!

Executing Sql Command -- Insert, Update And Delete
how can i make the function return true only if the execution is successfull (see bold red below)? Currently the function is returning true wheather it is successfull or not. Code:

Error - 2147217908 Command Text Was Not Set For The Command Object
I am getting the above error when trying to execute the following code:

Command Text Was Not Set For The Command Object
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:

Command Text Was Not Set For The Command Object
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:

Executing .EXE
What is the preferred method of executing .bat or .exe via ASPs

Error In Asp Text: Command Text Not Set For The Command
I am getting the above error in an asp page. Not sure why? The error details is given below. Code:

Executing Query
If I execute the following:
Code:

qSQL3="insert into eli_encomenda_linha (eli_enc_codigo, eli_codigo, eli_pro_codigo, eli_pro_designacao, eli_quantidade, eli_preco_unitario, eli_desconto, eli_imposto, eli_emb_codigo, eli_men_codigo) values (" & codigoEncomenda & ", " & lCiclo & ", '" & Session("idProduto" & lCiclo) & "', '" & Session("Descr" & lCiclo) & "', " & Session("qtdProduto" & lCiclo) & ", " & Session("preco" & lCiclo) & ", " & Session("Desconto" & lCiclo) & ", " & imposto & ", " & embCodigo & ", " & menCodigo & ")"

oConn2.Execute(qSQL3)

Everything is OK but, if i put the same in an do while, loop then, the following error appears:

-2147217900 - [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

Executing VBS File From ASP
I've tried instantiating the Windows Script Host shell object in ASP,
and I'm trying to run this command: "cscript.exe myvbs.vbs parameter1
parameter2"; however, the server runs cscript.exe very briefly, and the
task ends. Note, it runs fine from a command prompt. Do I need to give
the anonymous user any special permissions in order to do this?

Getting The Results From Executing An Exe
Is there any sample about getting the results from executing an exe using
asp?

Executing ASP Page
I have a file called Audit.asp that I want to execute via command line from a batch file (bulk.bat)How can I do this?

Executing WSH Scripts
I have a WSH script that I usually run using the server scheduler but want to be able to execute it from an ASP page to generate reports spontaneously. The WSH Script performs correctly from the server system and the scheduler but when I try it from my ASP (please see below) nothing happens, no errors, no reports, no nothing.Code:

<%
Dim objWSH : Set objWSH = Server.CreateObject("WScript.Shell")

objWSH.Run("d:scriptsmailreport.vbs weekly")

Set objWSH = Nothing
%>

Executing An API Call
I have a VB DLL which I've created that I call from an ASP page I also created. The DLL makes a call to the API (FindWindow), but always returns 0 instead of an HWND. I'm guessing that IIS is designed to disallow its own processes from discerning any information about outside (non-IIS) processes (for security reasons).

i read into low, medium, and high "security" settings (ie. being created as an IIS process, pooled, or an outside process), but that didn't seem to help. Any suggestions as to how I can make this API call succeed (and/or any similar API calls?

Executing A VBS File
I used to be able to Execute '.VBS' files from ASP pages. I think the facility stopped in IIS6. Security feature I guess - any work arounds available ?

Executing C# Code
How do I execute an C# code from a website for my sql.

Executing A Dll In Asp Site
I have downloaded a Imager.dll for image resizing. This was working well in our local mechine but have problems in our server domain. Installation Instructions for Imager Resizer .Upload Imager.dll to any directory with "Scripts and Executables" permission on your webserver. but we can only set the below permission in our server domain
(Read, Web, Browse, Write, Reset).

Executing .exe Files On Client
How do I execute an executable (which will install some files) on the client machine which is stored on the web server. I've found this feature on many web sites.

Executing Stored Procedures
set rs = Server.CreateObject("ADODB.Recordset")
objConn.usp_RetrieveCategories rs

Method 2:

set rs = objConn.Execute("usp_RetriveCategories")

Which method is considered to efficient. Is it method 1 or method 2?.
The stored procedures returns no values.

Problem Executing Programs From ASP
I am trying to execute a ping command from ASP, and I am really not getting
anywhere. I wrote the following code based on what I found on the subject on
the Internet:

Dim sh, result
Set sh = CreateObject("WScript.Shell")
cmd = "ping 192.168.1.5 -n 1 -w 200"
result = sh.Run(cmd, 1, true)
Set sh = Nothing
Set result = Nothing

When I try loading the page containin this code, however, I get no response
from the web-server. And occasionally I get an error message saying that the
server could not handle the request due to too many users. Subsequent
requests to the server, also on other files, seems to end up in the HTTP
equivalent of a black hole, that is there is no response.

I am running WinXP (which is incidentally up-to-date with regard to Windows
Update) and IIS 5.1.

Executing A SQL Statement From An Asp Script
how to have multiple sql insert statements in one page. i have tried on my own and if i put more then one statement neither statement will work.

Executing SQL Views From An ASP Form
I am working on a very complex projet that has several SQL views and I want to execute the view so that the client can view the data from direferent angles. I need a sample code that I can use as a starting point.

Executing A Stored Proceedure
i have this script that loops through the variable in request.form("values") and based on this executes a Stored proceedure. Stored proceedure is in the include file. (Which basically does an insert) To make it neat
However, the loop is successful. But the SP only inserts into my db once.
What could be wrong here ?

Code:
<%aTest = Split(request.form("values"), ",")
For i = 0 to UBound(aTest)
%>

<%Next%>

Executing A Batch File From Asp?
We're trying to write an application that will allow a user to enter an id field from an ASP intranet page and when they hit the enter button, fire off a print job. The problem is, Adobe must be open as the items being printed are PDFs.

We tried firing off a print command using MS SQL cmdShell() (not sure if that is the exact name of the command) and it works, but it never completes. The process hangs in the database because, we think, it hasn't closed Adobe, therefore never coming back to the query. We wrote the query into an ASP page.

Adobe must be open or the documents won't print properly.

Does anyone have any suggestions to how we can automate this?

Executing Shell Commands In Asp
I'm trying to execute a Windows command in ASP. For example, this is a snippet of what I have right now:
....
Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.Run("notepad", 1, true)
Set WshShell = Nothing

The strange thing is that notepad.exe actually appears under the list of processes in Task Manager, but its window does not show up on the server's desktop; the client's browser just sort of hangs. I'm led to believe that this has something to do with IIS permissions, but I'm not certain.

Executing Stored Procedure In Asp Page
I have written a stored procedure and I am trying to execute it inside my ASP page. So here is my code. It wont work at all, like when I try and open the page It times outs.

<%
dim sqlrs, rs2
sqlrs = "exec SP_GET_KPI_TABLE_HEADERS"
set rs2 = server.createobject("ADODB.Recordset")
RS2.open SQLrs, CMS, 2, 2
%> Code:

Stored Procedure Call Not Executing
I have a Stored Procedure (SP) being called by my ASP page, but nothing is being executed. The SQL Profiler shows a RPC execute, but the actual SP is not executing as nothing is being inserted.

If I run an EXEC in Query Analyzer, with the same data being passed, it works fine and returns my OUTPUT. The SQL Profiler shows all the hits to the database then too. Code:

Executing ASP Contained In A Text Stream.
I am reading a file on the fly..which contains both ASP and html. Is their anyway i can cause any ASP in this Text Stream to execute?

Server.Execute Call Not Executing
Anyone know of any special issues with Server.Execute?

Specifically for me it simply is not executing ... the server does not
transfer to the page specified. The calling ASP just continues as if
it had gone to the page and returned ... with no error code.

This ASP had been working actually. I made a change to a <FORM>
element on the calling page, then the Execute call stopped working.
So I reverted back to original and still does not execute.

Anyone have any ideas?

Files Not Executing On 2000 Servers
I have a .asp application lying out on a Windows 2000 server. The problem is it no longer is working. It seems that no .asp files will execute anylonger on this box. I even have a very basic .asp testfile that prints a line off text to the browser, but even these don't run. I got four errors in the event log for each failure. However, the browser displays this (with friendly error messages et to "off"):

Server Application Error

The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance.

The event log errors are :

A COM+ device failed to start
Did not register with DCOM within the timeout.

Making Browser Wait Before Executing
i have an uploadpage where users can upload images. When the image is uploaded my logo is added with aspimage.

the file hasnt been saved before i try loading it with aspimage. How can i make the browser wait 2 secs before executing the next piece of code, to allow the file to be saved properly before trying to access it again ?

File Path Of Currently Executing Script/Page
Is there a way to determine the filepath of an ASP script being executed, like so? First file contains:

<%
For Each x In arrNuggets
Server.Execute "/nuggets/" & x & "/default.asp"
Next
%>

The executed file, default.asp, needs to be able to figure out what it's parent folder name is.

Request.ServerVariables("SCRIPT_NAME") only returns the name of the first initial page loaded, and nothing about the page currently being executed.

Executing SQL Stored Proc And Returning XML Through ADO In ASP Page ??
I need to return XML from a SQL Stored Procedure which I will execute through ASP ADO code. Stored Procedure as below:

CREATE PROCEDURE pr_GetJobInfo2
@JobType int,
@CntryID int,
@JobTitle varchar(8000) OUTPUT
AS
SELECT @JobTitle = ltrim(rtrim(JobTitle))
FROM dbo.JOBS
WHERE JobType = @JobType
AND CntryID = @CntryID
FOR XML AUTO
[code]

Now the output parameter (@JobTitle) cannot be assigned to FOR XML, so what must I do ??? My ASP code reads as: ....

Function To Stop The Remainder Of The Page From Executing
Is there a function in ASP that can stop the remainder of the page from executing?

Prolems Executing Stored Procedure From ASP Page
I am trying to execute the following stored procedure from my asp page The asp page is passing a value "@Year" to the stored procedure ut seems to fall over with a declaration problem. Here is the stored procedure Code:

Problem With Error Reporting When Executing Multiple Sql Staments In Asp
I have a problem with running multiple sql statements using asp.
Basically if there is an error with any of the statements inside the
query a rollback is done. the sql and rollback work fine, But on the
actual asp page no error is detected unless it occurs in the first
statement in the query. heres an example

<%
Sql= " BEGIN TRAN INSERT INTO Users VALUES ('BLAH', 'BLAH') INSERT INTO
TESTING VALUES ('SOMETHING','SOMETHING') IF @@error <> 0 ROLLBACK TRAN
ELSE COMMIT TRAN "
If Err <> 0 Then

Response.Write "error"

Else
Response.Write "<p>Data has been added!<p>"
End If

%>
in that example if theres an error inserting into Testing the page will
display 'Data has been added' even though it hasnt.

Insert Statement Executing Repeateadly On The Page Refresh
i have a form that action is set to itself, on the same page i m having the insert statement, executed when i submit that form, but when the user refresh that page the query is executed and submit the null values in the table.

<form name=form1 action=form1.asp method=post>
<input type........
<input type.......

<input type=submit value....>
<input type=hidden name='insert' value=1>
</form>

<%
if request.form("insert") = 1 then

Execute the insert query

End If

%>

Using The Like Command In SQL
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)

New Command
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?

CLI Command
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

Command
does any body have a command that enables you to talk to another computer on a network
like A instant message.

Run A DOS Command From ASP
How can I run a DOS command from my ASP ?(prefer to use html/vbscript solution rather than 3rd party add-ons)

Command
I 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

SQL Command
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?

Using The Like Command In SQL
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)

Update Command
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:

Command Button
<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.

Command Object
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'

JET UNION Command
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?