Paramater For Cnn.EXECUTE?
How does one pass a parameter to the EXEC query recordset:
set rs = cnn.execute("EXEC tblListings_qry2")
How does one pass a parameter to the EXEC query recordset:
set rs = cnn.execute("EXEC tblListings_qry2")
I have 3 asp pages. The first page (login.asp) takes the parameter values(userid, groupid, locationid and deptid) based on the login (validate using a table). On submit the page params.asp is executed. Here the user has to select the filtering.
Then the page results.asp is executed. When the result is in excel format only the parameter value p_attdate (p_attdate is the value on page params.asp) contains a value.
The value of p_gid(p_gid is a session variable) remain null. BUT when the output is in html format, the parameter value p_gid return the correct value. I want the output to be in excel format but the sql statement is returning the wrong result. Only p_attdate is returning the correct value. I think because p_attdate is a form variable.
Can anyone tell me why value of p_gid is always null when the output is in excel format???
WEll I see that this issue is not yet solved ...
So here's some more beef...
There is an update the first part of the query that takes ~50 seconds
and the connection gets cut off at 30 sec sharp. Logical as the default value us 30 sec.
question :Does anyone know how to increase that value? I can't do it in the udl , it reverts back to nothing.
Option:
[1]I would/could also optimize that update using a hint to fasten it
[2] Or try to execute the proc without using the dsn?
Using ASP 3 on an ISP account (I don't have access to the root of the
server). I have a page that does some intake processing and I'd like to have
it run every 5 minutes. Right now, the only way I can see to do this is to
have a client task that wakes up every 5 minutes and opens that page.Is
there a better way?
how can i setup a connection to run the sql statement? how can i embedded it in the script? Code:
View Replies View RelatedI recently moved an app over to IIS 6 from IIS 5. Everything works great! I use ASPExecute to run an .exe - but it doesn't fire. It just sits in the process window. Doesn't do anything. Is IWAM, or IUSR or both required to run it?
View Replies View RelatedI need to use a VB6 dll like an ActiveX in ASP page. This dll use other .exe that is configured en DCOMCNFG and this dll is configured too in the same environment (DCOMCNFG) like a DllSurrogate with an specific user administrator.
I don't know how to configure this dll & IIS to it works with Anonymous authentication. I need to do this because is a development that it works in an Internet environtment and I can't assign a administration user in IIS 5 to the anonymous user.
Can server.execute provide a return value? How? ie.
dim test
test = server.execute("page2.asp")
What code in page2.asp will produce something in test?
my global.asa file doesn't seem to be executing in IIS and i don't know how to make them run. Any ideas how to execute the global.asa file in IIS 5.1 ,
View Replies View Related<%Response.Write "Hello"%>
<html>
<head>
<javascript language="javascript">
alert("First");
</script>
</head>
<body bgcolor="#FFFFFF">
<h1>Testing</h1>
</body>
Which code execute first.
In Page1.asp I am calling Server.Execute("Page2.asp"). Before calling
Server.Execute(), I set an application variable to a value that it is
important for me to know that it doesn't get accessed by another ASP page
before I call Application.unlock in Page2.asp, that is why I use
Application.lock.
According to the documentation, Application.lock gets automatically unlocked
when the ASP page terminate, I want to confirm that calling Server.Execute()
doesn't automatically unlock the application, i.e that Page2.asp will start
executing when the application is still locked.
after publishing a web to iis, asp pages based on a
database fail to work. the browzer starts loading such page
and never does- at some point the status bar stops and the
page never loads without displaying any errors. the browzer
shows that it is busy all the time.
what If i wanted to have a dropdown that executed a query based off the selection. so i have a dropdown on page and when they make there selection it queries other data with out submit?
View Replies View RelatedINSERT INTO results(id, book, book_spoke, recordType, book_title, chap, chapter, chapter_spoke, vers, verse, verse_spoke, text_data) VALUES (, , , '', '', , , , , , , '')
Microsoft VBScript runtime error '800a01b6'
Object doesn't support this property or method: 'execute'
/kjvresp.asp, line 280
What is the proper format for my SQL str using command.execute? Even though
I know I have matching data in my table, I keep coming up with a
..RecordCount of -1. What am I doing wrong? Code:
I am extrememly new to C (only been playing with it for a few days), and will be am required to be using C and ASP.NET (also a language i have only been using for a couple of days) for work purposes in the next few months. I come from a mostly Java background where it was easy to write JAVA code, and provide web interfaces that made use of that code in JSP.
I would be greatful if anyone can tell me...
a) Is the same effect possible using ASP.net to access / execute etc C/C++ (not interested in c# code - all the explanations of this seem to cover c# only - or is there no difference? - Spot the newbie! lol) code (pretty sure that works - but be good to know incase there is another step in there).
b) Where can i learn more about it? Can you suggest any weblinks or books etc?
Incase it makes any difference - the sort of code i am interested in running would simply respond with results from databases, or extracted content of files etc (command line stuff) - and much of the code is already written in c / c++ so i am not keen on re-writting it specifically for asp.net (does that make sense? hope so!).
Can someone tell me what permissions i need to change.
error
Microsoft VBScript runtime error '800a0046'
Permission denied
/ftp.asp, line 3
Code: ...
I am getting "Failed to execute request because the App-Domain could not be created. Error: 0x8013150a"in the event log and "HTTP 500 error" in Visual Studio.when I create a new ASP.Net project. When I browse to an already existing application Internet Explorer shows Application Unavailable page
View Replies View Relatedwith dos command of " ipconfig/all>c:ip.txt " I can retrieve some info and save it in a text file of ip.txt, now I am wondering if there is a way to do the same thing within asp?
View Replies View RelatedHow do I execute two consecutive insert statements against an oracle database here is the insert that was result of a response.write ...
View Replies View RelatedThe web server is running on IIS with asp. I'd like to know how do you execute #include with asp in a file with extension .html. The codes work fine with .asp but I'd like to do this in .html.
View Replies View RelatedI want to execute .exe file like(Media Player) through ASP 3.0. I want to use in ASP folloeing langauge type
<%@ language="Javascript"%>
server.execute("file.asp")
That executes the file file.asp.But how do i execute file.asp?count=10
why my page immediately executes the Call(update_User()) function even though the client hasn't clicked on submit yet............can someone please help me with this.do not give me javascript.I'm trying to get my form to execute a function when someone clicks on the submit button.Code:
<input name="btnNew" type="button" onClick="<% Call(Update_User())%>" value="Submit" />
how do I execute asp scripts from db?
View Replies View Related<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open application("dtat_motor_connectionstring")
set rs = new adodb.recordset
'Set RS = Conn.Execute(' "exec spcn_update_transactions &
customer_number, customer_name, customer_address, customer_city,
customer_state, customer_zip, customer_phone, vin,
acct_number, tag, title_number, tag_type_number, branch_number,
institution_number, yr_make, state_from, type_number)
response.write rs
%>
I'm I connecting them correctly. Is there and easier way to execute a stored procedure. I'm trying to insert data into a SQL page. I have to have the customer number returned to me asap for the next page.
I've noticed a problem with calls to server.execute on a webserver running IIS 5.0. The call is used to conditionally include some asp code according to the language,but there seem to exist some memory leak due to the server.execute, because the "private bytes" for the processes, logged with performance monitor, go always up until I got "out of memory" accessing the homepage.
The memory comes back to normal with a click on the "unload" for the application but starts climbing again. Replacing the server.execute with a <!--include...--> solves the problem for me but I can't figure why this memory problem occurs.
can i gain the two result. in an asp page which using a stored procedure with execute method.
i want to execute the query and return the count value the query at the same time. is it possible and how?must i use ado? it is not possible to make it with execute method in asp.
Here is my code
<% Dim State, Names, i
State = Request("State_Query")
Response.Write(State) & "<BR>"
Set RS = objConn.Execute("Select Analyst From State_Analyst_Table Where St = " & State)
Names = RS.GetRows()
For i = 0 to UBound(Names,2)
Response.Write Names(0, i) & "<BR>"
Next
%>
I am trying to use a variable "State_Query" that I get from a previous page in a query on this page. I get an error that there is no value passed to the parameter on the execute line.
How can execute .exe file in ASP. E.g.(Media player, Jet Audio). Environemnt:
Windwos XP, ASP 3.0, Internet 6.0.
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
How can execute .exe file in ASP using javascript language.
I use this code all the time, but what does the ",,129" mean? Are there other parameters that one might use (I only do fairly simple SQL commands).
conn.execute strSQL,,129
I have loads of .sql files and i need a way to call these from my asp page so the user can run them from the browser. Meaning i have a page with a list of all scripts. each when clicked i am able to run the script. so HOW and what do i do to call and run the .sql.
View Replies View RelatedI have this code:
if VarType(eval("inTotal" & arr(4,i1)))=0 then
response.write "ok, dim"
execute("dim inTotal" & arr(4,i1) & ":inTotal" & arr(4,i1) & "=" &
arr_(i1,i2))
'it is working, I have variable
else
execute("inTotal" & arr(4,i1) & " = inTotal" & arr(4,i1) & " + " &
arr_(i1,i2))
'here is not working any more.
end if
Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/test.asp, line 308
What should be the problem?