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)
%>
<!--#include file="../../../scripts/objects/send_sms.asp" -->
<%Next%>
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:
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:
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: ....
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:
I'm having an "ocassional" problem with a script. I have been unable to duplicate the error on my mac or pc but it's happening to about 5% of our customers.
The page is called add.asp It takes the info from a form, sets a cookie to track the customer, adds the purchase info to the database and redirects to the shopping cart (cart.asp) Code:
Is it possible to make an ASP script that continues to run after the browser window is closed? I have a script that is going to run continuously for multiple days, and don't want to leave the browser window open. Maybe this can be achieved by executing a command for the system to run it?
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.
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?
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")
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?
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 ?
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).
I've got a computer with XP Pro and IIS 5.1 and can't get the vbscripts to run in my ASP pages. I set up a new virtual directory and turned all permissions on, on the virtual directory and the web site.
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.
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.
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.
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?
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.
My project is to go to this site: http://www.sanav.com/eric/gprs_read.aspx... write the text "351277000546068" in the textform and press submit. After I get the results of the page, I need the source of the page, either in a file locally or If it works I need to search for some strings on the results site.
So is there a way to do this programatically or is there a way to execute a POST command and call the same funciton as the website does?
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.