ASPExec - Application And Parameters Info
I am trying to run a C compiled executable on the server (this is running on a dedicated box within our network designed for this procedure), that reads from an input file located in the same directory, from an ASP page using ASPExec. The problem is that while I am attempting to do this from the command line, I need to be in the directory where the executable and input file are, since the .exe will read the input file.
Some may say to put the .exe and input in the default, but the .exe and input are in a folder that changes based on the user, therefore you will see the adjustment of the path everytime a user enters the page based on the Session variable "Foldername".
I've tried to open cmd to the directory and run the file sitting in the correct directory, without any success. In short, need to run an .exe (connected to an input file) in a directory that changes based on a user using an ASP page w/ APSExec. Code:
View Replies
ADVERTISEMENT
I am doing a migration for our web program from IIS 5.0 to IIS 6.0
One thing I was baffled is aspexec component.
I didn't change the code, but it seems the following code doesn't work
anymore in
IIS 6.0 in windows 2003
set Executor = Server.CreateObject("ASPExec.Execute")
Executor.Application = sDosCmd
sResult=Executor.ExecuteDosApp
the sResult actually give "ERROR: Could not create process"
View Replies
View Related
which is better to use?
dim wsh
set wsh = Server.CreateObject("WScript.Shell")
wsh.run "c:uild.exe", 1, True
set wsh = nothing
--or--
Dim Executor
Set Executor = Server.CreateObject("ASPExec.Execute")
Executor.Application = "c:uild.exe"
Executor.ShowWindow = True
Executor.ExecuteWinApp
Set Executor = nothing
View Replies
View Related
I am building a small Web app that will allow end users to visit a Web page, click a button which will in turn execute a batch file on the Web server which will migrate code from the development environment to QA. The Web app will also capture logins and execution requests, and the batch file currently emails the robocopy log to me.
In researching ways to get the ASP page to execute the batch file, I came across ASPExec from Server Objects - http://www.serverobjects.com/products.htm#free. It seemed straightforward enough, however I have not been able to get the permissions in sync for it to work.
View Replies
View Related
We have our web-site developed in classic ASP, and I need to add this additional feature on one of the pages to access a VB application. How can I do that? The VB application basically sends output to the COM3 port and opens a USB-Cash drawer that is attached to it. I am not sure how to go about with this.
View Replies
View Related
I have a simple website linking to an access database. The script works fine on my local machine. And it works fine on my regular host. However, I have uploaded the website to a Windows account with GoDaddy and here is my problem.
I am receiving the following error:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/home.asp, line 10
- the WEIRD thing is that if you hit refresh enough times, the page loads fine. Then, at random (it appears), the error resurfaces. No coding changes at all. Code:
View Replies
View Related
I've been coding since mainframes had 4MB of core memory (yes kiddies, that 4MB), I've never coded a classic ASP page, only ASP.NET.
I've noticed many problems in this forum seem to stem from building SQL commands by concatenating strings and could be avoided by using parameter substitution, a totally common concept in ASP.NET. So, is that just something that can't be done in classic ASP?
View Replies
View Related
My problem is: I've created an ASP/MS Access app with Dreamweaver. I have an admin page to edit/delete records. When I edit or delete a record, it works the first time and redirects me back to the main page.
When I click on another record it adds the URL parameter to the end of the previous URL parameter and I get an error. Is there a simple piece of code to check the URL for the same parameter so that it will not just add it to the end.
View Replies
View Related
I am calling an ASP page from JavaScript using window.open(<URL>?<few parameters>) parameters can be in Japanese so I am using encodeURI to encode it. In the ASP files I am using Response.Charset="UTF-8" and still when I check the URL with Request.QueryString it looks OK,however when I call Request("<parameter name>") I get the parameter value not in UTF8 format but in ISO-8859-1, does anyone familiar with
this? Is it a known bug with the Request object? Is there a way to force it to deal with the data as UTF-8?
Currently the only solution I have is to taker the value from QueryString and parse the whole URL by myself.
View Replies
View Related
I am using the following code in asp to select some data from an access db. recSel is defined and set further up my webpage, as is rsUpdate User. I cannot work out how to get past this error message
Too few parameters. Expected 1.
Can anyone see the problem?
strSQL = "SELECT tblUserDetails.UserRecId, tblUserDetails.UserName, " _
& "tblUserDetails.UserPw, tblUserDetails.UserEmailAddress, " _
& "tblUserDetails.UserFirstName, tblUserDetails.UserSurname, " _
& "tblUserDetails.UserPhoneNo, tblUserDetails.UserCompany " _
& "FROM tblUserDetails" _
& " WHERE tblUserDetails.UserName =" & recSel
rsUpdateUser.Open strSQL, adoCon, adOpenDynamic, adLockOptimistic
View Replies
View Related
I've had this error before but it was for a different type of command. Does anyone know what this means in relation to the highlighted code or what I might need to do to work on fixing it? Code:
View Replies
View Related
I am trying to send the results of a form to a couple of email addresses, but it is not working. I am required to use a XSL file for this.
I usually don't have problems with sending the results of a form to email addresses because I don't use a XSL file or a complicated function. The XSL file is fine. It is the ASP page that has the problem. Can someone please help me with this? Code:
View Replies
View Related
I have a simple form with a textbox, a combobox and a submit button. I want to also be able to pass the "values" of the textbox and the combobox in the URL. How do I do that? DO I need to set that up in the function? I know this must be simple becuase I can not find any information on how to do it.
View Replies
View Related
I am getting the error "No value given for one or more required parameters" with this basic script.
I have checked the fields are spelt correctly and have capitals in the right place. I have also checked with response.write to see the results it produces and it all looks correct. Code:
View Replies
View Related
I am recieving this error "No value given for one or more required parameters. "
I have a page that passes a link to URL then the details page is supposed to pull up the passed parameter's data. Code:
View Replies
View Related
I keep getting this error, specific to a file called validations.asp:
Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/ebusiness0405asp/greg/asp/project/validations.asp, line 14
I really don't understand what the required parameters are in this case and why they have no value. Code:
View Replies
View Related
I must send to the page below(MailBee.asp) the two parameters UserName and Password.
The page MailBee.asp is a different page, the code below is from the page where I have done the form(login.asp), so MailBee.asp is the page where I must do the authentication.That's why I must send to this page the two parameters, but I don't know how can I do this with the method action.Code:
<form action="MailBee.asp" method="post" id="form1" name="form1">
View Replies
View Related
I have created an update data base page with the help of tutorial. While submitting the data I am getting following error:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/update.asp, line 41
My code:
View Replies
View Related
I have a problem with input parameter which has Decimal DataType. Stored procedure (SQL 2000) works but it rounds all
values off, i.e 5.555 input becomes 6 and 1.3 input becomes 1.
In table QTY has data type decimal(5) - precision(8) scale(3).
Please, suggest what's wrong with this:
newqty = Request.Form("quantity")
..........
cmd.Parameters.Append(cmd.CreateParameter("qty", adDecimal, adParamInput, 5, newqty))
cmd.Parameters("qty").Precision = 8
cmd.Parameters("qty").NumericScale = 3
View Replies
View Related
I'm building my asp page using a table. Part of building that table includes:
......
Response.Write("<td>" & rsi.fields(3).value & "</td>")
Response.Write("<td><input type=button value=""Remove"" name=RemoveButton onclick=""RemoveAgent();""></td></tr>")
......
......
My problem is that my table has multiple records each line has a Remove button at the end. I need to pass rsi.fields(0).value to the RemoveAgent routine when the button is pressed.
I thought that my onclick event would become........onclick=""RemoveAgent(rsi.fields(0).value) ;.......
but I receive a syntax error. Thinking about it it's a bit more complex than that in any case because at the point of clicking the button, I am not sitting on the correct record within the recordset since I am sitting at the eof after creating the table
View Replies
View Related
my management has now decided that wants the crystal report that I have developed to be available with 5 different options. The only thing really changing is the where clause of my sql statement that Crystal Reports uses in the expert wizard to create the report. All of the fields remain the same. Is there way to set parameters for sql statement that would changed "where" clause in displaying crystal report in crystalreportviewer to (where xfield=parameter1, x2field=parameter2, etc.)
View Replies
View Related
i just realized that II5 is not with me i am running PWS on win98.so can i use response.redirect so that i can transfer parameters like a variable or a value?
View Replies
View Related
When I execute the code below, I get:
"Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters." error message in
the first line.
Rs.Open "SELECT * From Unvanlar WHERE Unvan = " & kayit8, Con, 3,3
If rs.EOF Then
Con.Execute ("INSERT INTO Unvanlar (Unvan) VALUES
('"&kayit8&"')"),,129
End If
Rs.Close
The variable is string and the field in access table is text. I'm sure
that field names in the code and table are correct as well.
What can I do to solve that?
View Replies
View Related
The '..' characters are not allowed in the Path parameter for the MapPath method.
/Connections/connportal.asp, line 30
This is line 30
MM_connDUportal_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("..\_privateportal.mdb")
%>
View Replies
View Related
I want to pass parameters via response.redirect.
After a search on google, I have seen various types and i am getting confused on the best way to do it.Can someone let me know if i can do it the same way a href?
View Replies
View Related
Getting this famous error when I try to do the following select statement:
"SELECT * FROM Deliveries WHERE Deliveries.ShippingNo = " & iShipment & ";"
iShipment is passed thru a querystring above the SQL statement as follows:
iShipment = Request.QueryString("shipno")
iShipment = Cstr("iShipment")
There is definitely a 'ShippingNo' field in my access database. Cannot seem to find why this is happening.
View Replies
View Related
is it possible to pass parameters in html like in asp.... products.asp?cat=3
.... what i want to do is when i click on a html link, it opens up news.html,
and then opens up a particular news article in an iframe on that page.
View Replies
View Related
Would anyone know of a good tutorial that would show how to have a search page in asp that allows for multiple search parameters
View Replies
View Related
I keep on getting this error. I had an sql statement before and it works. I changed it and i get this error so i know it's within the sql statement. Does anybody know what is wrong?Code:
<% dim mysql
set objconn = server.createobject("ADODB.connection")
objconn.connectionstring = "dsn=prospect"
objconn.open
set objrs = server.createobject("ADODB.recordset")
'mysql = "select * from Prospect where asm = '" & Username & "' order by Prospects_Name ASC "
mysql = "Select * from Prospect WHERE Status_Report.Prospect_Number = Prospect.Prospect_Number "
objrs.open mysql, objconn
%>
View Replies
View Related
Is there code that I can use to 'repeat' code.For example:I have a form that has about 30 fields on it. I then submit it to anotherform that has about 20 fields on it. I then submit the second form to a third and so on. During this process, I pass all of the fileds as Hidden Fields. My code has over 200 hidden fileds in it and sometimes they get mis-spelled or somthing. I thought that I saw something that you can tell the page to 'repeat' certain code for all parameters on the page by using a FOR EACH command.
View Replies
View Related
reading the article about protection against sql injections faced that author recommends to
"use bound parameters (the PREPARE statement)"
examples are given in perl and java. Tried to find something for ASP, but did not find anything neither in web, nor w3schools, nor here. Could someone explain what is this and how to use it to prevent SQL injection.
View Replies
View Related
I am getting error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2.
sqlContest="Insert into tblContestAns(UserID,ContestName,ContestAns1,Conte stAns2,ContestAns3)Values (" & usid & ","" Contest1 "",'" & cnt & "',"" "","" "")"
Conn.Execute sqlContest
View Replies
View Related
I have some troubles with the correct syntax, hope to get some help. This is the intention. This is the code I'd like to use.
strSql = "Select * from ta where ta_nr = %artnr%"
<!-- include file = "%artnr% & .asp"-->
View Replies
View Related
