<% 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.
I have been using Dreamweaver to produce an ASP site uploading to an Access database and have hit a bit of a problem – one which has made me re-evaluate how I make sites.
I think it is time I stopped relying on Macromedia and started learning proper hand coding.
My problem is this:
I am uploading an image to a folder on the database, and from the same page trying to insert records.
The upload image works fine, the script is all ok.
It’s the insert statement I cant get to work. The SQL is sound, I’ve tested it in Access itself, but the problem is, that without the help from Dreamweaver, what is the syntax to execute the command?
In ASP page, if we want to retrive the number of rows in database: should we use recordset object? Since this is not update, insert, delete, or select statement
sqlStmt = "SELECT COUNT(*) from table1;" Set objRS = Server.CreateObject("ADODB.RecordSet") objRS.open sqlStmt, strConnect
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?
I 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?
I 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.
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 ,
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?
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!).
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
with 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?
The 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.
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:
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.
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.
