i have to start a batch process from a dll to transfer
files created by this dll to remote ftp server. I created
a batch file:
ftp -n -v -i -s:D:atchftpcmds.txt ftp-server
and a file containing the ftp commands:
user username password
lcd D:atchmedia
mput *.*
quit
It works pefectly when i start it from the dosbox. But
when i call it from the vb dll implemented in IIS (shell
("D:atch ransfer.bat")), it does not complete the
transfer and hangs after 400-500 (small) files.
We have LOADS of documents scanned to PDF format, stored in SQL tables.Allowing a client to browse our ASP driven site to select and view individual PDFs has been no problem. ("index" table is queried to show list of available PDFs, user clicks a link in the list, PDF reader shows the document in a new window.) Now, they would like a feature that would PRINT (at their location) batches of documents via the website, preferablely with a single click.
Security issues, warning messages, etc., aside, what MIME-type combination do I need for and ASP to write a BAT file to the response stream? e.g. Response.Clear Response.ContentType = "application/octet-stream" Response.AddHeader "Content-Disposition", "attachment;filename=message.bat" Response.Write("net send COMPUTER2 success") Response.End() This code does not work! Which is surprising because in my current config, the following html works fine, and executes on the shell: <A href="message.bat">test</A>
First, a little background. I'm developing an order management system for my company and I want to be able to print a batch of packing slips in one go without pulling each one up on the screen and clicking 'Print'.
How can I do this in ASP? The only way I can come up with is to loop through the records and concatenate a string with the HTML code and then send that string to the printer. But, I'm not exactly sure that's the best way or if it is even possible.
I want to basically click a button that says "Print All Packing Slips" and never see an output screen.
I have a web page that sends emails to groups of recipients. It uses CDONTS to send each email. While it works fine for sending a small amount of emails out, it chokes the page when sending to large amount of email addresses. Basically, it loops through each email address and sets the CDONTS object each time. I need to do this because each email is personalized.
Does anyone have any thoughts around how to optimize this code. Is there anyway in ASP to send the code to a background process for example?
I need to send batch html emails out from a db mailing list (anything up to 1000 in one go).I am using CDOSYS and standard ASP. My problem is that it will error if I try to do any more that 5 every 30 seconds - this is fine when I send them out myself (I have a script to do this) but now I need a program which will allow users to send out batches and I want it to appear seamless.
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 have a form that users enter details of a car (e.g make model , idnumber#) and then press save to save to the database they may want to order 10 cars with the same details exept the idnumber so to save the users entering in all 5 details I want to make it easier.
Should I have a list box and let the user add idnumber items from a text box and then pass this to my update asp and loop through + to save to the database or should I save one record and then return back to the same form Note : I am having problems with this method as only part of the fields show when I hit the back button I just wondered what is the best method of doing this I am spoilt for choice and I also get problems.
I have a batch file that needs to execute every day and I need to run it in a silent/invisible mode. I looked up on the Internet and found this command: shell("batchfilename.bat").
Upon failure, learned that it is a Visual Basic command and not VBScript command. I wonder if anyone knows how to run a batch file using vbscript that runs in invisible mode?
if anyone has experience in building the ability to upload/insert multiple images from one directory on the client machine to an Access database via asp. The process would be to click on the browse button for the correct images and you would be able to click on multiple images using ctrl or shift button and then insert the selected files into the database. Can this be done?
I'm trying to call a batch file that I've built using the FileSystemObject and CreateObject("Wscript.Shell"), oShell.Run. in an asp script. Naturally, I can get the script to work from a command line but not from abrowser. The page does not throw an error but the oShell.Run. portion of the script doesn't run.
how to go about sending a batch of sql statements from asp to sql server, and having errors appropriately handled? for example,
i want to send the following stored procedure calls to sql server in a single batch from my asp code, rather than using a loop in asp to execute each procedure individiually. if one of these fails, they all should fail.
im trying to run a bat file on windows server 2003 and am running into nothing but problems.
i have IIS on my XP workstation that accesses the 2003 server. what im about to explain below works properly on the XP IIs.
i have two files: somefile.asp and somefile.bat. the asp file creates a wscript.shell and then tries to execute the run method for somefile.bat.
however, it isnt working. after an unexaggerated 7 hours of searching google/etc, i have found nothing but frustration and deep, seething anger regarding this problem. Code:
I have a batch file that takes variables from the cmd and passes them by sqlcmd to an SQL script. When I pass the variable 'MikeTestList' the script runs as expected with no problems. When I passed 'BulkTransferTest' I got an error message, 'The string or binary data will be truncated'.
Some testing has shown that I get the error when the string is anything above 12 characters. Is there a limit to the length of a string you can pass using sqlcmd from a batch file? Is there any way around it?
Also, if I have a space in the string, it only passes the string up to the space. I have tried to fill it with a '%' which then gets passed as is, so the % stays in place through out the script. Code:
I'm a complete newbie to IIs and ASP (come from the Apache/Cold Fusion world ). I've created a very simple ASP test page:
<%@ Language=VBScript %>
<% Response.Write "This is a test ASP page." %>
But when I access the page, it just displays the page as text, instead of processing the ASP. I've looked at a half-dozen Microsoft KB articles, but still no luck. I'm not getting an error, it's just not processing.
I m facing a problem in ASP. That is on the production machine when I deploy my product at that time it dosenot perform a particular process. But on my devlopment machine it runs perfectly fine.
The only difference which lies is that on my devlopment machine in security tab of wwwroot/(website) a security permission with the name of VS Devlopers(machineVS Devlopers) exist but on the production machine it dosenot. What could be the possible problem.
Making good old fashioned asp page and need to be able to display the IIS COM+ process id's (i.e. those that show up when attaching to a process in InterDev(in debug/processes dialog box).
Is there a way to get these process id's show up in an asp page? You can tell I'm not to saavy when it comes to working my way around the WindowsAPI.
Just like to know if I am correct and no problems in this scenario:
I have page where the user clicks a button to save some information >>
gets directed to page 2 where a value gets returned from a recordset and the form is inserted automatically upon loading with the value (sequential for the database table) >>
the user then gets redirected to page 3 upon insertion into the database, if I use 'Select Top 1 ......' as a query to retrieve some information on this page am I sure that this is the correct record just inserted even if 2 or more people are saving at the same time?
I need to select a csv file from my desktop through the "Browse.." button in my ASP page and upload the file and do further interrogation and extract the data to put into a database. What I'm struggling with is more the first parts with getting the file read properly in the second page so I can read and insert the data.The data below describes the file. Quite a simple format.
Customer ID - Additional values are player IDs 193948294, 293, 294, 296, 290, 292
if it is possible to run a process after page has loaded? reason being is i have an application that uploads a file, then zip's it up. These are 50 megs sometimes, so zipping the file can take some time. It is a two stage process though, a user will upload a file, then fill out some more info, then submit, so while the user is filling out more info, I'd like to start zipping the file. Does anyone know if that is possible? and if so how to do it?
when i call for a asp page i c some process still running in the status bar. but when i click on the same link again, i could not find the process. it happens alternatevely.why is this happening? how to prevent?
It's been a long time since I've needed any help with something, so I'm happy to come back and feel dumb again. I need to learn how to process XML data and generate pages driven from that data. I know the structure of the documents, I just need to grab the data from inside certain XML elements of the XML documents.
Can someone explain this or post a link to a good site? I've tried googling, but everything I find seems to explain how to print back the XML in HTML format.
Got a bit of code, which I want to loop through, unless the current value is "", in which case I need it to skip to the next one, but how do I do it?
Response.Write "<br />" & vbCrLf For Each strItem In Request.Form If strItem = "" THEN 'these next two lines, I only want to be processed if the above does have a value in it Response.Write "-" & strItem & "-" & vbCrLf Response.Write "-" & Request.Form(strItem) & "<br />" & vbCrLf End If Next Response.Write "<br />" & vbCrLf
Anybody have idea about Image processing tools available for ASP (like Imagemagick,I dont think ImageMagick will work with ASP).
I want to adjust the images uploaded to my site(ASP) to a particular resolution and do some image resolution changes, like creating thumbnails from originally uploaded images,etc..
I have created 2 tables on my db. one is for customers and one for corporate. this is to distinguish the records so that we wont mix up our clients. i have created a login page for both customer and corporate. however, i think there is something wrong with the login process code which process the login for users to our page. there is an error message:Error Type:
Provider (0x80020005) Type mismatch.
(see highlight in red) for attached code.i am not sure if its correct but here is the code as attached
<% Response.Buffer = True strUserName = Request.Form("User_Name") strPassword = Request.Form("User_Password") Dim rs Dim sqlStr Dim record_found record_found = 0 Dim vPath, pPath, ConString vPath = "xxxxx.mdb" 'use this one if database is in root of cart folder pPath = Server.MapPath( vPath ) ConString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & pPath & ";" & "JET OLEDB:" Dim Conn, rsCatalog Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open ConString sqlStr1 = "SELECT * from Customer WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'" sqlStr2 = "SELECT * from Corporate WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'" set rs = Server.CreateObject ("ADODB.Recordset") adOpenStatic = 3 rs.CursorType = adOpenStatic rs.Open sqlStr1, sqlStr2, conn If (rs.RecordCount <= 0) Then Response.Redirect("login.asp?from=no_record") Else record_found = 1 Response.Cookies("User_Name") = rs("User_Name") Response.Cookies("User_Password") = rs("User_Password") Response.Cookies("Login") = 1 Response.Cookies("View_Cart") = 0 End If rs.Close Set rs = Nothing if record_found = 1 then if Request.Form("hiddenVal") = "view_cart" then Response.Redirect("view_cart.asp") else Response.Redirect("default.asp") end if end if %>