Force a download

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ ASP Server
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Help with ASP on Win2K server Our web server crashed and I had to move all web sites to backup server. Installed Internet service and it appears to work OK on html files, but ASP files are not functioning - what is wrong? I have lost so many brain cells that I need a fresh mind to see the obvisous. Did I miss installing something? Thanks Tom Tag: Force a download Tag: 323688
  - 2
    - Forcing a reload? Hi all, I've got a little shopping cart app which when you use all of the links on the pages, and buttons etc, things are good, the "shopping basket" on the left navigation updates and shows a sum of items and cost. However, if you arrive at the home page for example, proceed to the products page, add an item and then click "back", you get a cached page. I appreciate there are some lines of code I can use, both ASP and html to prevent the cachine, but what I dont want to incur instead is that error IE (and other browsers too I guess - how very Microsoft of me :o) ) - shows when the page has expired, I think that would probably be worse than the cart not showing any items (or not showing the update) until a link was pressed... Anyone got any ideas? Regards Rob Tag: Force a download Tag: 323685
  - 3
    - Request.Form returns nothing Hi all, Iâ??m using IIS6 for our college Intranet and Iâ??m having trouble using Request.Form. Here is my code: <% If Request.QueryString("action") = "show" Then Response.Write "title: " & Request.Form("NewsTitle") & "<br />" End If %> <form action="/_admin/blogs/test.asp?action=show" method="post"> <input type="text" name="NewsTitle" /> <input type="submit" value="Add" /> </form> The page refreshes and generates the following HTML: title: <br /> <form action="/_admin/blogs/test.asp?action=show" method="post"> <input type="text" name="NewsTitle" /> <input type="submit" value="Add" /> </form> The Request.Form(â??NewsTitleâ??) is empty. Iâ??m sure my HTML and ASP/VBScript is ok, Iâ??ve been writing for ages, but Iâ??ve never seen it do this before. Request.QueryString works fine. After some Google searches some have hinted at Integrated Windows Authentication being involved. The page in question doesnâ??t have any authentication. Any ideas? Thanks in advance â?? and if this is the wrong newsgroup could you point me in the right direction. Steve Tag: Force a download Tag: 323669
  - 4
    - Mailing App Duplicate problem... Guys, I've written an email sending script to mass send to our database - some of our subscribers are subscribed to multiple list, and so when selecting the entire database, I want to ensure I don't have Duplicates. To avoid this, I am selecting the recordset of all users, ordering by Email address, sending the email, moving onto the next record and then starting a loop to keep looping until the email address is different, but it doesn't work... see example below... ----------------------------------- Do While NOT RS_RecipientsForCampaign.EOF SEND THE EMAIL HERE... RS_RecipientsForCampaign.MoveNext If NOT RS_RecipientsForCampaign.EOF Then ** Do While TheUsersEmailAddress = RS_RecipientsForCampaign("Email") AND NOT RS_RecipientsForCampaign.EOF RS_RecipientsForCampaign.MoveNext Loop End If Loop ----------------------------------- When running, the script works fine, BUT I get an Unspecified error (I HATE that message) at the end of the script, pointing me to the line number marked with ** above. How can I cure this? I've tried everything but need a solution to amend this section of code that works!! Cheers, Ash Tag: Force a download Tag: 323661
  - 5
    - AddHeader Content-Disposition Has no effect I have a IIS web site that works fine on one server but not another. I do not know if the problem is an IIS setting or something else so I will try to include as much detail as I have figured out so far. Several web pages allow the user to download PDF files to be viewed or saved locally on the user's machine, not in the browser. Those web pages all redirect to a single ASP page with QueryString parameters identifying the relative path to the desired file on a remote server. The redirect URL would be something like: download.asp?Src=Statements\2006\01\123456789 My download.asp code looks something like this: ================================================= Dim strSourceName Dim objDocServer ' Retrieve the path to the desired document strSourceName = Request.QueryString("Src") ' Call remote COM+ application and retrieve document as binary stream Set objDocServer = Server.CreateObject("DocumentServer.Application") Set objDocServer.Document = objDocServer.getDocument(strSourceName) With Response .Buffer = True .Clear .ContentType = "application/pdf" .AddHeader "content-disposition", "attachment; filename=test.pdf;" .BinaryWrite(objDocServer.Document) End With ================================================= When I try to download a file, the browser shows the File Download dialog asking me to Open or Save the file but it shows the File name as "123456789" rather than "test.pdf". It also shows a blank value for the File type. Whether I choose Open or Save the same error appears: Internet Explorer cannot download 123456789 from <server>. Internet Explorer was not able to open this site. The requested site is either unavailable or cannot be found. Please try again later. If I comment out the AddHeader line, the File type shows correctly as Adobe Acrobat Document. If I change the AddHeader to inline rather than attachment, I see the binary data in the browser. This exact code works fine on another server and I have no idea why it will not work on this new server. What I find interesting is that the download wants to name the file as 123456789 which comes from a part of a QueryString value and nowhere else. Could this have something to do with the "\" characters in the QueryString being confused as path delimiters by IIS/ASP? Any ideas or help are appreciated! Michael Tag: Force a download Tag: 323655
  - 6
    - Page cannot be displayed in release mode Hi, I am pretty new to asp.net, and have recently taken over a project. I have gotten to the point where I am about to release my changes, but for some reason when i build the project in release mode and launch in in IE I always get a "The Page cannot be displayed" page instead of my login form. Anyone have any ideas? The applciation works fine in debug mode, its just in release mode that this happens. Regards, Joel Tag: Force a download Tag: 323654
  - 7
    - Regular expression problem I want to search a string of HTML and insert a querystring into any url where the url is an asp page and is either a local link /folder/page.asp or of a specific domain http://www.somedomain.com/folder/page.asp. It needs to be able to handle plain links and those with querystrings already in there. I could do it with instr functions etc but I thought this might a good time to brush up on regular expressions. Can anyone point me in the right dirction? Regards. Tag: Force a download Tag: 323647
  - 8
    - ServerXMLHTTP, session and cookies I try to use ServerXMLHTTP object to get the session infomation from a remote webpage, but it always returns nothing. the follwoing is my code: *local.asp* url = "http://domain/remote.asp" set xmlhttp = Server.CreateObject("MSXML2.ServerXMLHTTP") xmlhttp.open "GET", url, false xmlhttp.send "" Response.write xmlhttp.responseText set xmlhttp = nothing *remote.asp* bLogin = Session("login") sUserName = Request.Cookies("username") Response.Write(nUserID & " " & sUserName) although the session and cookie are not blank, but I cannot received any info. please help me, thanks a lot. Tag: Force a download Tag: 323645
  - 9
    - Displaying Progress on An ASP Page Hi - I have an ASP page - that will be making about 7 calls to a database. What I want is to show progress to the users so that they can tell each database call is in progress. The asp calling page works fine, but it only displays when the entire process has been completed. What I want is to be able to show dynimically - step 1 done; step 2 done; etc. Any thoughts? Tag: Force a download Tag: 323641
  - 10
    - String Manipulation I have a text string which comes from a form containing the article text in a knowledgebase. Sometimes people enter http links in their text however when they show on the webpage they do not show as hyperlinks, because obviously they don't gave the link tags around them. What I'd like is to manipulate this text string so that wherever there is http in it it put's the link tags around it. So what I'm really asking is, how can I convert this string: And to get to the blah blah site please go to http://blah-blah.com and you will find lots of blah blah there. Into this: And to get to the blah blah site please go to <a href="http://blah-blah.com">http://blah-blah.com</a> and you will find lots of blah blah there. It needs to be versatile as they may enter more than one http link within the text. Any help appreciated! Sergio. Tag: Force a download Tag: 323640
  - 11
    - Get value on page refresh I have a simple page that has a dropdown and I need to populate a textbox with the onchange event. How can I do that? My page refreshes, but I don't know how to 'get' the value of the dropdown. Here is some of my code. <form name="ClassForm" method="Post" action="ClassEdit.asp?m=c"> <td><div class="textB">Location:</td> <td><select size="1" name="LocationID" onchange="document.ClassForm.submit();"> ' Generate choices for Location pull-down box. An inactive location will be flagged with *. query = "select ID as Result," _ & " case when City is not null and City <> '' then City + ': ' + LocationName else LocationName end as Choice," _ & " case when IsInactive=1 then '*' else '' end as Flag" _ & " from LocationTop order by City, ListOrder" GenerateOptions Conn, query, sLocationID </select></div></td> </tr> <tr> 'Max Registration will be prepopulated with Location dropdown onchange event <td><div class="textB">Maximum Registrations:</td> <td><input type="text" name="MaxRegistrations" size="3" value="????"></div></td> thanks in advance Tag: Force a download Tag: 323634
  - 12
    - status of ASP .NET I'm looking at C# and ASP .NET these days. Visual Sudio 2005 looks like a neat dev. env. But before committing, I would like to know more about the current status of these tools. I noticed, that my site hoster does not support ASP at all. And more providers do not... PHP however, IS supported a lot, but does not have anything like .NET facilities, does it ? What is the status of the language wars these days ? ASP is still the way to go ? What is the market doing ? fr gr Erik Tag: Force a download Tag: 323631
  - 13
    - reading XML Hi, I'm currently trying to display a XML file within a ASP page, although get the following error when trying to select one of the notes... the node is called: <content:encoded> This is the error Reference to undeclared namespace prefix: 'content'. This is my code <%@ Language="VBScript" %> <html lang="en"> <head> <title>Some feeds</title> <script runat="server" language="VBScript"> Sub OutputFeed (feedURL) Dim XmlDocument Set XmlDocument = Server.CreateObject("Msxml2.DOMDocument.4.0") XmlDocument.setProperty "ServerHTTPRequest", true XmlDocument.async = False Dim Loaded Loaded = XmlDocument.load(feedURL) If Loaded Then Dim Items, Item, Title, Link, Description, TitleText, DescriptionText, LinkURL, Content2, Contenttext Set Items = XmlDocument.selectNodes("//item") Response.Write "<p>Feed from " & feedURL & " has currently " & Items.Length & " items.</p>" & VbCrLf Response.Write "<ul>" & VbCrLf For Each Item in Items Set Title = Item.selectSingleNode("title/text()") If Title Is Nothing Then TitleText = "" Else TitleText = Title.data End If Set Link = Item.selectSingleNode("link/text()") If Link Is Nothing Then LinkURL = "" Else LinkURL = Trim(Link.data) End If Set Content2 = Item.selectSingleNode("content:encoded") If Content2 Is Nothing Then Contenttext = "" Else Contenttext= Trim(Content2.data) End If Set Description = Item.selectSingleNode("description/text()") If Description Is Nothing Then DescriptionText = "" Else DescriptionText = Description.data End If Response.Write "<li><a href=""" & LinkURL & """>" & TitleText & ": " & DescriptionText & "</a></li>" & VbCrLf response.Write contexttext Next Response.Write "</ul>" & VbCrLf End If End Sub </script> </head> <body> <h1>Some feeds</h1> <% OutputFeed("http://www.biblegateway.com/usage/votd/rss/votd.rdf?31") OutputFeed("http://rss.news.yahoo.com/rss/elections") OutputFeed("http://www.cbsnews.com/feeds/rss/main.rss") OutputFeed("http://rss.cnn.com/rss/si_topstories.rss") %> </body> </html> Thank you for your help Tag: Force a download Tag: 323625
  - 14
    - compare text document versions? Can anyone point me to a tutorial or example code of how to write VBScript (or VB6) code that could look at two versions of a document and mark all differences between the two? I am working on a project for a newspaper. the goal is to be able to store each version of an article from rough draft to final copy, and look at any two versions in the process and see what changes were made. Thanks. Paul Tag: Force a download Tag: 323624
  - 15
    - Urgent Please help.. Hi all. Can anyone help me here. 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 Thanks Tag: Force a download Tag: 323599
  - 16
    - Google Maps API Anybody have any experience with plotting map points with Google Maps API from an Access DB? I have a database with about 90 locations that I would like positioned in the Google Maps. I found a cool tool to get the long and latitudes to complete the database, now just need to figure out how to get all that data to appear on the maps. All guidance appreicated. Tag: Force a download Tag: 323597
  - 17
    - how to detect submit on input type=image if no image found Normally I would do something like if request.form("submitbutton.x") <> "" then ... end if But I found a problem when the browser uses the 'alt text' instead of the image (when the image is not found, or if the browser is not displaying graphics, etc. How do you detect that? or should I? Tag: Force a download Tag: 323594
  - 18
    - IE, embedded WMP 9.0: double GET request Hello, I have the following problem. The Windows MediaPlayer object is embedded in an ASP page: --- test.asp --------------------------- <%@ LANGUAGE=VBScript enablesessionstate=true LCID=1033 %> <% option explicit %> <html> <body> <h2>TEST</h2> <embed type="application/x-mplayer2" pluginspage="http://www.microsoft.com/Windows/MediaPlayer/" src="test2.asp?fn=test.wav" width=320 height=69 name="MediaPlayer" autostart="False" ShowStatusBar=1 ShowDisplay=0 ShowControls=1> </embed> </body> </html> ------------------------------- The src parameter of the MediaPlayer object references to another ASP script which returns WAV file as a binary stream: --- test2.asp ---------------------------- <%@ LANGUAGE=VBScript enablesessionstate=true LCID=1033 %> <% option explicit %> <% Dim fn fn = Request.QueryString("fn") if not isNull(fn) and fn <> "" then Dim vpath, path, strExt, strContentType vpath = "logs" path = Server.MapPath(vpath) strExt = LCase(GetFileExtension(fn)) if strExt = "mp3" then strContentType = "audio/mp3" else strContentType = "audio/wav" end if Dim strFilePath strFilePath = path & "\" & fn 'This is the path to the file on disk. Dim objStream Set objStream = Server.CreateObject("ADODB.Stream") objStream.Open objStream.Type = 1 objStream.LoadFromFile strFilePath Response.AddHeader "Content-Type", strContentType Response.AddHeader "Content-Disposition", "inline; filename=" & fn Response.AddHeader "Accept-Ranges", "bytes" Response.AddHeader "Content-Length", CStr(objStream.Size) Response.BinaryWrite objStream.Read objStream.Close Set objStream = Nothing end if Function GetFileExtension(fn) Dim strExt, intExtPos strExt = "" intExtPos = InstrRev(fn, ".") if (not IsNull(intExtPos)) and intExtPos > 0 then strExt = Mid(fn, intExtPos + 1) end if GetFileExtension = strExt End Function %> ------------------------------- For some strange reason the web site receives 2 get requests: one from the MediaPlayer object and the other from the browser itself: 2006-07-03 08:44:32 192.168.X.X - 192.168.X.X 80 GET /test.asp - 200 0 1018 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) 2006-07-03 08:44:32 192.168.X.X - 192.168.X.X 80 GET /test2.asp fn=test.wav 200 0 119682 Windows-Media-Player/9.00.00.3250 2006-07-03 08:44:32 192.168.X.X - 192.168.X.X 80 GET /test2.asp fn=test.wav 200 0 119682 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) However, if the src parameter references a direct link to a static WAV file on the server (src="test.wav"), then the browser sends one GET request (form the MediaPlayer): 2006-07-03 08:45:05 192.168.X.X - 192.168.X.X 80 GET /test.asp - 200 0 1005 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) 2006-07-03 08:45:05 192.168.X.X - 192.168.X.X 80 GET /test.wav - 200 0 119635 Windows-Media-Player/9.00.00.3250 How can I eliminate the extra request? Tag: Force a download Tag: 323584
  - 19
    - How to do email preview on ASP? Hello All In my ASP page, I use CDONT to send email to client. But, I need to allow user preview and edit the email content before sending it out. Any advices? I have two ASP pages - h_email.asp and h_email_action.asp Inside the h_email.asp, I create a form and allow user to input information for the email. In the h_email_action.asp, it contains asp code for extracting fields' value in h_email.asp and store them into database as well as send email. All fields' value will be created as a string for the email content. Could anyone give me some suggestions? Best Regards, Bon Tag: Force a download Tag: 323581
  - 20
    - Upload the data into acess database from excel file Hi, I want to download and upload the data from acess database into excel file or from excel to database. So how can i use "Excel.Application" to do this type of job. So please help me soon. Thanks Pk Tag: Force a download Tag: 323580
  - 21
    - newbie: client and server Hi If I save the client form and all its component in html format in my harddisk, and then open and fill out the form locally and submit, will the server process it and return the information as usual? Thanks Tag: Force a download Tag: 323574
  - 22
    - Protecting ASP Applications: Need Opinions Hello All, I've finally written an asp app that is worthy of resale and would like to hear from you who have done the same. What is the best way to protect my application? I would like to stay away from anything that has to be registered on the server as most of my target audience will not have physical access to their web servers. They will just upload the code to their server and set directory permissions for the database. I 've purchased asp scripts myself in the past and had to provide a domain name where it would be running. It would not run on any other domain but the one I provided. Is this a practical approach or is there a better way? How is it done? I've also seen posts about putting some of the vb code into an activeX dll. Is this a solid solution? Again, How is this done? I appreciate anyone sharing their experience... Thanks in advance, -Bill- Tag: Force a download Tag: 323573
  - 23
    - Execute .sql scripts from ASP Hi all. Can anyone help me here. 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 Thanks Tag: Force a download Tag: 323572
  - 24
    - Time in combobox Hi, I need to display the time in combo box like the one we have it in Windows 2000. we can change the time using the arrow.. it looks like this: 4:40:54 PM in a text box . i need to do it like this in my page. waiting for ur response. Ciao, jay Tag: Force a download Tag: 323569
  - 25
    - Save value in the database Hi Everyone, I have a main window which has a form in it. Inside the main window there is a button, which when clicked opens a pop window (showModaldialog window). Inside that pop window I have a checkboxes, which user can check. When he is done selecting them, He clicks on "Done", which is of type button. My problem is when user clicks on Done, I am not able to retreive the values of the check box group. I could have used request object to retrieve the values, but that is functional only when the event is submit. Kindly advice me in this situation. Tag: Force a download Tag: 323566
- Next
  - 1
    - OT: Memorial/remembrance site application Hi Sorry to be off topic. Can anyone recommend a memorial site application that can be downloaded or purchase? I need to allow people to leave their comments on the person concerned and pictures. Thanks Regards Tag: Force a download Tag: 323564
  - 2
    - 403 on ASP page I am having a great deal of trouble with this, hopefully someone can help me out! I have a JNI Java applet that accesses an ASP page. The page looks like this: Dim myObj Set myObj=Server.CreateObject("myDLL.myClass") myObj.Execute() Set mObj = Nothing This is accessed numerous times throughout the run of the applet. For the first x number of accesses, this works fine. However, after an indeterminate number of accesses, the page returns a 403 and I am no longer able to call myDLL. Does anyone know what could be the cause of this? Thanks, Erica Tag: Force a download Tag: 323558
  - 3
    - page wont work in firefox i was informed that one of out pages wasnt working. the user was on firefox and said our page wasnt functioning but whenever i use IE it works fine. is there any reason or something in the code that wouldnt allow a page to work with FF thanks gabriel Tag: Force a download Tag: 323554
  - 4
    - File download size limit I have a site that allows a person to log in and get a list of files to download for them. If the file size is under 65MB then everything is fine, they click the download button and the save box pops up. But if the file is larger than 65MB the page sits and processes until it times out. I can't figure it out becaus a 64MB file loads immediately for download while one slightly larger hangs up. Any assistance on this will be greatly appreciated. Tim Tag: Force a download Tag: 323553
  - 5
    - Possible to store javascript document.forms[0].value to ASP session? Hello all Would it be possible to store javascript document.forms[0].value to ASP session as global variable? If it is not possible, how can I pass the javascript document.forms[0].value to ASP/vbscript function? I need to pass the javascript value to ASP/vbscript function because I have to store the javascript value into database. I can't use Request.Form for getting field value. Because there is a submit button in the same form for calling email function in another ASP page. Thanks Bon Tag: Force a download Tag: 323552
  - 6
    - Select Case I'm getting a syntax error with a Select Case statement: Select Case CSng(rs.fields("Field1")) Case 0 Response.Write "Test1" Case Is < 0 <<< Syntax Error Response.Write "Test2" Case Is > 0 <<< Syntax Error Response.Write "Test3" End Select As far as I can tell the syntax *is* correct. What am I missing? Thanks Chris Tag: Force a download Tag: 323542
  - 7
    - Save dynamic page to text file Can anyone recommend how to do a screen scrape from a dynamic page and save it to a text file? Regards, Chris. Tag: Force a download Tag: 323530
  - 8
    - URL Rewriting I want to rewrite URL's from asp type ones with querystrings to more search engine friendly ones. I was looking at two options: isapirewrite or a bit of a hack which replaces the 404 page with a custom, which examines the url and then does a server transfer to the querystring page. The hack works quite well with one problem, only the 404 page is written to the IIS log. Does Isapi rewrite have the same problem. Can anyone recommend any pointers to combining URL rewriting and web statistics. Tag: Force a download Tag: 323529
  - 9
    - Somebody Please Help Me Convert this ASP to VBS Hi Gang I'm not sure what needs to be changed when converting an asp to vbs. I'm not sure if I can with my code below. Can someone PLEASE convert the text below to vbs? Thanks a million. Andy  <% ' Create a connection to the Notification database and open it. Set NotificationDatabaseConn = Server.CreateObject("ADODB.Connection") NotificationDatabaseConn.Open "Data Source=" & Server.Mappath("../cadim/data/notifications.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;" lcSQL = "SELECT CADIMUser, CADIMUserPassword, SMTPServer, eMailAdmin FROM SystemConfig" Set RSSystemDefaults = NotificationDatabaseConn.Execute(lcSQL) lcCADIMUser = RSSystemDefaults ("CADIMUser") lcCADIMUserPassword = RSSystemDefaults ("CADIMUserPassword") lcSMTPServer = RSSystemDefaults ("SMTPServer") lceMailAdmin = RSSystemDefaults ("eMailAdmin") ' Create a connection to the CADIM database and open it. Set CADIMDatabaseConn = Server.CreateObject("ADODB.Connection") CADIMDatabaseConn.Open "dsn=CADIMProductionDB;uid=" & lcCADIMUser & ";pwd=" & lcCADIMUserPassword & ";" ' Delete all the previous notifications lcSQL = "DELETE * FROM Notifications" Set RSDeleteNotifications = NotificationDatabaseConn.Execute(lcSQL) ' Create a simple SQL Select statement for testing. lcSQL = "SELECT C_ID, ELEM_ID, S010000_AEND_ART_ENG FROM PLMAD_PROD.T_EWO_DAT WHERE S010000_ORG_EINH='013060' AND (LEV_IND = '605' OR LEV_IND = '610') AND S010000_AEND_ART_ENG <> 'Normal change A doc'" Set RSECOList = CADIMDatabaseConn.Execute(lcSQL) Do While Not RSECOList.EOF lcECOType = RSECOList("S010000_AEND_ART_ENG") lcECOID = RSECOList("C_ID") lcECONum = RSECOList("ELEM_ID") lcSQL = "SELECT BEARB_PRS_ID, FUNKTION, BEREICH, MAIL_AUSG, OK_KZ FROM PLMAD_PROD.T_S010000EWOM WHERE C_ID_1 = '" & lcECOID & "' AND OK_KZ = '_'" Set RSECODetails = CADIMDatabaseConn.Execute(lcSQL) lcApplicantSentRequestForApproval = "False" Do While Not RSECODetails.EOF If Not IsNull(RSECODetails("MAIL_AUSG")) Or Len(RSECODetails("MAIL_AUSG")) <> 0 Then lcApplicantSentRequestForApproval = "True" End If RSECODetails.MoveNext Loop ' Loop through the details again now we know someone has been ' notified once to approve the change and build the notification table If lcApplicantSentRequestForApproval = "True" Then RSECODetails.MoveFirst Do While Not RSECODetails.EOF lcDeptFunction = RSECODetails("BEREICH") lcJobRole = RSECODetails("FUNKTION") If lcJobRole <> "Applicant" Then lcSQL = "SELECT COUNT(ecotype) AS ecocount FROM notificationconfig " & _ "WHERE ecotype = '" & lcECOType & "' AND jobrole = '" & lcJobRole & "' AND deptfunction = '" & lcDeptFunction & "'" Set RSECOCount = NotificationDatabaseConn.Execute(lcSQL) If RSECOCount("ecocount") > 0 Then lcSQL = "SELECT sequence, changestage, ecotype FROM notificationconfig " & _ "WHERE ecotype = '" & lcECOType & "' AND jobrole = '" & lcJobRole & "' AND deptfunction = '" & lcDeptFunction & "'" Set RSECOConfigDetails = NotificationDatabaseConn.Execute(lcSQL) lcSequence = RSECOConfigDetails("sequence") lcChangeStage = RSECOConfigDetails("changestage") lcECOType = RSECOConfigDetails("ecotype") lcECOPersonId = RSECODetails("BEARB_PRS_ID") lcSQL = "SELECT S_USER, S_FIRST_NAME, S_EMAIL FROM PLMAD_PROD.T_PRS_DAT WHERE EDB_ID = '" & lcECOPersonId & "'" Set RSPersonDetails = CADIMDatabaseConn.Execute(lcSQL) lcFirstName = RSPersonDetails("S_FIRST_NAME") lcLastName = RSPersonDetails("S_USER") lceMailAddress = RSPersonDetails("S_EMAIL") 'Insert the new notification into the notification table lcSQL = "INSERT INTO notifications " &_ "(econum, changestage, sequence, firstname, lastname, emailaddress, jobrole, deptfunction, ecotype) " &_ "VALUES ('" & lcECONum & "', '" & lcChangeStage & "', " & lcSequence & ", '" & lcFirstName & "', '" & lcLastName & "', '" & lceMailAddress & "', '" & lcJobRole & "', '" & lcDeptFunction & "', '" & lcECOType & "')" Set RSInsert = NotificationDatabaseConn.Execute(lcSQL) Else ' There was a dept function and/or job role that was not recognized by ' the notificationconfig table. lcBodyError = "<html><head><meta http-equiv='Content-Language' content='en-us'><meta http-equiv='Content-Type' content='text/html; charset=windows-1252'><title>CADIM EC Action Requirements</title></head><body><font face='Arial' style='FONT-SIZE: 9pt'>" lcBodyError = lcBodyError & "The following signature is not a default signature. The user will not be sent a notification and this needs to be corrected.<br><br>" lcBodyError = lcBodyError & "<b>ECO Number: </b>" & lcECONum & "<br>" lcBodyError = lcBodyError & "<b>Department Function: </b>" & lcDeptFunction & "<br>" lcBodyError = lcBodyError & "<b>Job Role: </b>" & lcJobRole & "<br>" lcBodyError = lcBodyError & "</font></body></html>" Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(cdoSendUsingMethod) = cdoSendUsingPort .Item(cdoSMTPServer) = lcSMTPServer .Update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = lceMailAdmin .To = "andy@mycompany.com" .Subject = "CADIM Comm List Member Can't Be Notified" .HTMLBody = lcBodyError .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing End If End If RSECODetails.MoveNext Loop End If RSECOList.MoveNext Loop ' Setup the send status for each notification. We only want to send ' an email to a user once with all the action. lcSQL = "SELECT * FROM notifications ORDER BY econum, sequence" Set RSNotifications = NotificationDatabaseConn.Execute(lcSQL) lcOldSequence = "" lcOldECONum = "" Do While Not RSNotifications.EOF lcBodyTableRecs = "" lcECONum = "" lcChangeStage = "" lcECOType = "" lcAction = "" If lcOldECONum <> RSNotifications("econum") Then lcOldSequence = RSNotifications("sequence") End If If lcOldSequence = RSNotifications("sequence") Then lcECONum = RSNotifications("econum") lcChangeStage = RSNotifications("changestage") lcECOType = RSNotifications("ecotype") lcJobRole = RSNotifications("jobrole") lcDeptFunction = RSNotifications("deptfunction") lcSequence = RSNotifications("sequence") lcFirstName = RSNotifications("firstname") lcLastName = RSNotifications("lastname") lceMailAddress = RSNotifications("emailaddress") lcSQL = "UPDATE notifications SET sendstatus = 'Y' " &_ "WHERE econum = '" & lcECONum & "' And " & _ "changestage = '" & lcChangeStage & "' And " & _ "sequence = " & lcSequence & " And " & _ "jobrole = '" & lcJobRole & "' And " & _ "deptfunction = '" & lcDeptFunction & "' And " & _ "firstname = '" & lcFirstName & "' And " & _ "lastname = '" & lcLastName & "' And " & _ "emailaddress = '" & lceMailAddress & "'" Set RSUpdate = NotificationDatabaseConn.Execute(lcSQL) End If lcOldECONum = RSNotifications("econum") ' lcOldSequence = RSNotifications("sequence") RSNotifications.MoveNext Loop 'Send out the notifications. lcSQL = "SELECT header, body, bodytable, footer FROM eMailConfig" Set RSeMailDefaults = NotificationDatabaseConn.Execute(lcSQL) lcHeader = RSeMailDefaults("header") lcBody = RSeMailDefaults("body") lcBodyTable = RSeMailDefaults("bodytable") lcFooter = RSeMailDefaults("footer") lcSQL = "SELECT * FROM notifications WHERE sendstatus = 'Y' ORDER BY emailaddress, sequence DESC" Set RSNotifications = NotificationDatabaseConn.Execute(lcSQL) lcOldeMail = "" lceMailBody = "" lcBodyTableRecs = "" lcFirst = "True" Do While Not RSNotifications.EOF If lcOldeMail <> RSNotifications("emailaddress") And lcFirst <> "True" Then Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(cdoSendUsingMethod) = cdoSendUsingPort .Item(cdoSMTPServer) = lcSMTPServer .Update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = lceMailAdmin .To = "andy@mycompany.com" .Cc = "andy@mycompany.com" .Subject = lceMailSubject .HTMLBody = lceMailBody .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing lceMailBody = "" lcBodyTableRecs = "" lceMailSubject = "" End If lcFirst = "False" lceMailSubject = "Required CADIM EC Actions For " & RSNotifications("firstname") & " " & RSNotifications("lastname") lcECONum = RSNotifications("econum") lcChangeStage = RSNotifications("changestage") lcECOType = RSNotifications("ecotype") lcAction = "Review as the " & RSNotifications("jobrole") & " - " & RSNotifications("deptfunction") & " representative." lcBodyTableRecs = lcBodyTableRecs & "<tr>" lcBodyTableRecs = lcBodyTableRecs & "<td><font face='Arial' style='FONT-SIZE: 9pt'>" & lcECONum & "</font></td>" lcBodyTableRecs = lcBodyTableRecs & "<td><font face='Arial' style='FONT-SIZE: 9pt'>" & lcAction & "</font></td>" lcBodyTableRecs = lcBodyTableRecs & "<td><font face='Arial' style='FONT-SIZE: 9pt'>" & lcECOType & "</font></td>" lcBodyTableRecs = lcBodyTableRecs & "<td><font face='Arial' style='FONT-SIZE: 9pt'>" & lcChangeStage & "</font></td>" lcBodyTableRecs = lcBodyTableRecs & "</tr>" lceMailBody = lcHeader lceMailBody = lceMailBody & RSNotifications("firstname") lceMailBody = lceMailBody & lcBody lceMailBody = lceMailBody & lcBodyTable lceMailBody = lceMailBody & lcBodyTableRecs lceMailBody = lceMailBody & lcFooter lcOldeMail = RSNotifications("emailaddress") RSNotifications.MoveNext Loop 'Get the last user to send the email to Set cdoConfig = CreateObject("CDO.Configuration") With cdoConfig.Fields .Item(cdoSendUsingMethod) = cdoSendUsingPort .Item(cdoSMTPServer) = lcSMTPServer .Update End With Set cdoMessage = CreateObject("CDO.Message") With cdoMessage Set .Configuration = cdoConfig .From = lceMailAdmin .To = "andy@mycompany.com" .Cc = "andy@mycompany.com" .Subject = lceMailSubject .HTMLBody = lceMailBody .Send End With Set cdoMessage = Nothing Set cdoConfig = Nothing ' Close the connection to the databases CADIMDatabaseConn.Close NotificationDatabaseConn.Close %> Tag: Force a download Tag: 323523
  - 10
    - Dynamic CSS Hi I need to create a bunch of sites with slightly dynamic CSS. Basically, all the image paths in the CSS need to be dynamic, depending on the values of certain ASP variables. I can think of 3 ways to do this: 1. Write a script to create a semi-dynamic CSS file, which will be run whenever we need to make changes to the ASP variables controlling the image paths. 2. Have an ASP script generate the CSS on the fly: <link href="dynamiccss.asp" rel="stylesheet" type="text/css"> 3. Put all static CSS in a normal CSS file, and have a special dynamic style sheet for only those rules that require variability. We could either use method 2 above to generate a second style sheet, or place dynamic rules directly in the actual asp pages. I'm not sure what to do. (1) has the disadvantage that the CSS is not truly dynamic. (2)... well, I'm not sure if (a) this is legal by W3C standards and whether there's a performance hit involved. (3) has the disadvantage that it places rules for the same elements in different locations, which could lead to confusion. Is there a generally accepted way to solve this problem? Tag: Force a download Tag: 323522
  - 11
    - IIS logs and server.transfer I am thinking of creating a custom 404 page which does a server.transfer to a variety of different pages. My question is what shows up in the log, which the web statistics are based on? 1. The non existent page, which is requested? 2. The custom 404 page? 3. The page it gets transfered to? Tag: Force a download Tag: 323519
  - 12
    - Sessions and Crystal Reports I'm asking this on the off chance that someone out there might have seenit before. In my current application, when the user logs in, the state variable called "role" is assigned to them, detailing what they can do and what they cannot do. This variable follows them through the entire application (It is assigned using Session("role") = "xxx"). Problem is, when I run a crystal reports RPT file, I lose the session variable - it reverts to being equal to "", rather than "ADMIN" or some such thing. I can track this throughout the app and i know for a fact that it happens as soon as a RPT file is run... Has anyone else seen something like this before? Tag: Force a download Tag: 323516
  - 13
    - request parameter names I 'd like to print out all posted parameter names and values. I'm able to print all the posted request values, but not the parameter names. any suggestions? thanks in advanced Davy Tag: Force a download Tag: 323508
  - 14
    - aspx dont work: App-Domain could not be created After restart some time is everithing ok. After some hours - some days, problem start. Only in pool, where dll VB6 is used, aspx pages (asp ok) does not work. Event: Failed to execute request because the App-Domain could not be created. Error: 0x8007000e Not enough storage is available to complete this operation. Source: ASP.NET 2.0.50727.0 Event ID: 1088 OS: Windows 2003 Server SP1 HW: dual Xeon, 4GB RAM, Server is not Domain server. dll VB6 is used in pool where aspx pages does not work, in other pools aspx pages work. Any ideas? thx Alex Tag: Force a download Tag: 323506
  - 15
    - How can I Run a file without a messagebox Dear all, I use this "HyperLink1.NavigateUrl = "\\aoui\myeoe\testing.bat" to run the batch file. The windows will show a messagebox "RUN" "SAVE" OR "CANCEL". I want to run the batch file directly and without any prompted action. pls help !! thx Tag: Force a download Tag: 323501
  - 16
    - help, Mail From Hello From asp, if I try to send an email From "Flowers, Gifts and Goodies <myemail@company.com>", it arrives as if were two senders: Flowers ; Gifts and Goodies. How should I set the From property of CDO? Thank you!!! Tag: Force a download Tag: 323495
  - 17
    - Display images actual size I am putting together a website for a photographer. There will be a section where his clients can select various sizes of picture to order. I would to be able to display the images the actual size depending on the clients screen size and resolution. Is this possible? I know that the server receives info on the resolution of the client computer, but that isn't quiet enough if you don't know the size of their monitor. OR the pixels per inch w * h of the client computer? It doesn't need to be 100% perfect - there are those monitor controls that let you stretch and compress the active area of the monitor but most people will be within some reasonable range. Any ideas? Thanks! Tag: Force a download Tag: 323491
  - 18
    - ASP Active Directory We want to be able to allow our users to update this AD profile and sepecifically be able to change the address, city and phone number fields thorough a web page. Can someone help with some example ASP code? It will be much appreciated. Tag: Force a download Tag: 323490
  - 19
    - Roster web application Hi all, I am about to create a web application using asp and vbs to build an online roster for a department of 25 people. The roster covers some 10 shifts a day, 7 days a week always starting on a Sunday. I will be using an access database file to hold the information. At this this stage I will hold all the data for each week based on the date that the week starts. I am looking for ideas on how to dynamically give the user the option to choose any given week in any given year, always starting on a sunday. Could this be created on the fly or would it be easier creating a database table holding the dates for Sunday for a year or 2 ? Once a week is chosen a check on the database will determine if that weeks roster has been created or not. If not a user with the correct permissions can then create it. The rosters are currently written out by hand. It is a labourious task which must have certain numbers of staff working each shift for a given day. By creating a web application automating the checking process and making the roster available online and by email will make life easier for all staff involved. Any help, much appreciated. Cheers, Bill. Tag: Force a download Tag: 323484
  - 20
    - Determine if more than one row returned I have an ASP/ADO application querying an SQL Server DB. I want know the most efficient way to determine if more than one row is returned from a query. If more than one row is returned, the user will be presented with a choice of which row to process. If only one row is returned, I want to skip this stage, and process that single row immediately. I can think of a number of ways of acheiving this (eg. .recordcount) but I'm looking for the slickest and most efficient method. Any thoughts or suggestions Thanks CJM Tag: Force a download Tag: 323483
  - 21
    - ASP error messages nested on with IIS 6.0 When an HTTP 500.100 occure in IIS 5.0, I was getting redirected to a HTTP 500.100 - 'page cannot be displayed' error page when there was an error, but now in IIS 6.0, I get 'Microsoft VBScript runtime error '800a01c2' ' nested within the page. I'm trying to create my own error messages so it will re-direct to my own error page and send me an email. I used to be able to do this in IIS 5.0 but I can't seem to get it going in IIS 6.0 as it doesn't re-direct to a default error message. Anyone know how to get IIS 6.0 to work like IIS 5.0, or is there another way of doing it, or is this not even an IIS problem! Any help would be great! Tag: Force a download Tag: 323482
  - 22
    - IIS 6.0 and randolny request timeout Hi! I have got IIS 6.0 on Windows 2003 Server. I have installed HTTP handler (as simple reverse-proxy) - code below. I created virtual category with this dll and Wilcard application mapping set to aspnet_isapi.dll Now everything works fine, but sometimes IIS stops working and return 'Error in /catalog Application. Request timeout...' And than i must restart IIS (at least application pools). Thanks for help, Filip Code of Handler.cs: /* Handler.cs; v 1.1; 2005/10/25; Filip Balicki Script capture all references to selected in Web.config virtual directory, and download resources from selected (also in Web.config) remote host. (so it is work as proxy) */ using System; using System.Web; using System.Net; using System.Text; using System.Text.RegularExpressions; using System.IO; using System.Collections; using System.Configuration; namespace Polygon { public class Handler : IHttpHandler { string host_address { get //Take local address (where this script is installed) from web.config //http://my_domain/virtual_catalog/ { return ParseUrl(ConfigurationSettings.AppSettings["local_address"]); } } string dest_adress { get //Take local address (where this script is installed) from web.config //http://my_domain/virtual_catalog/ { return ParseUrl(ConfigurationSettings.AppSettings["destination_host"]); } } public void ProcessRequest(HttpContext context) { string my_uri = context.Request.Url.ToString(); //construct real uri to remote host string real_uri = Regex.Replace (my_uri, host_address,dest_adress,RegexOptions.Multiline | RegexOptions.IgnoreCase); HttpWebRequest request = (HttpWebRequest) WebRequest.Create(real_uri); request.KeepAlive = false; request.AllowAutoRedirect = false; HttpWebResponse response; try { response = (HttpWebResponse) request.GetResponse(); } catch(System.Net.WebException we) { context.Response.StatusCode = 404; context.Response.StatusDescription = "Not Found ("+we.Message+")"; response = (HttpWebResponse) we.Response; writeBody(context, response); return; } if (response.StatusCode != HttpStatusCode.OK) //Found not OK header - probably redirect { context.Response.AddHeader("Location", response.Headers["Location"]); context.Response.AddHeader("Content-Type", response.ContentType); context.Response.StatusCode = (int) response.StatusCode; } else { context.Response.AddHeader("Content-Type", response.ContentType); writeBody (context, response); } response.Close(); context.Response.End(); } public bool IsReusable { get { return true; } } public string ParseUrl (string url) { if ((char)url[url.Length-1]!= '/') { url+='/'; } return url; } public void writeBody (HttpContext context, HttpWebResponse response) { Stream receiveStream = response.GetResponseStream(); if ((response.ContentType.ToLower().IndexOf("html")>=0) ||(response.ContentType.ToLower().IndexOf("javascript")>=0)) //if we get html or javascript use ASCI mode { string body; StreamReader readStream = new StreamReader (receiveStream, Encoding.Default); body = readStream.ReadToEnd(); context.Response.Write(body); } else { //the response is not HTML - use binary mode byte[] buff = new byte[1024]; int bytes = 0; while( ( bytes = receiveStream.Read( buff, 0, 1024 ) ) > 0 ) { //Write the stream directly to the client context.Response.OutputStream.Write (buff, 0, bytes ); } } response.Close(); } } Tag: Force a download Tag: 323475
  - 23
    - ASP (not .Net) and Socket Hi, Is network communication available on ASP (not .Net)? My code is on two ASP servers on which I cannot install any components. My need is quite basic: The Client (browser) POST/GET a HTTP request to Server1 Server1 POST/GET a HTTP request Server2 Server2 respond with a Comma Separated Values file Server1 compose page with data from Server2 Server1 sends back the result to Client1 I know there are other solutions like XML-RPC, but it needs to install something on the server. Please advise. Thanks a lot. -- JSC Tag: Force a download Tag: 323474
  - 24
    - Difference between two dates in Weeks and Days Hi, I have an order processing system in which I have an OrderDate and a Completion Date I want to print the difference in Weeks and Days between the two dates, i.e. if the completion date is 3 weeks and 2 days after the order date, I want to print : 3 Weeks and 2 Days, on the page. Is this possible ? Appreciate your help Thanks David Tag: Force a download Tag: 323472
  - 25
    - ASP 0113 again, but only on few machines Hello, I have big problems with this errors. In our company we're using an application on asp site, which is working with Sql Server 2k. Generally it works fine but there are some problems. On few computers there is: Active Server Pages error 'ASP 0113' Script timed out etc. I know what this error means, but it seems for me strange because on 95% computers this application works fine without any problems. But there is a few computers on which this error is occuring.all the time and these computers have Windows 2k or Windows XP installed, so this is not Windows problem. I was looking for similar error for a long time, but i haven't found explanation to situation like this. For sure this is not because many people try to connect, I think this is something with connection with sql server, but have no idea what. Please Help! Thanks in advance Maciej Chojnacki Tag: Force a download Tag: 323471

how would i for a browser to download a file (specifically mpgs)

i can get it to go for small 4mb files, but the larger ones if they do go,
take bout 15 mins to even begin the download.....

any help greatly apprecitated!

Top

Re: Force a download by James

James
Thu Jul 06 21:44:55 CDT 2006

well finally after hours of searching, and minutes after making this OP, i
found my answer!

http://www.aspin.com/func/content?tree=aspin/tutorial/file/updownlo&id=5625110

allows me to download! Thanks aspin! lol

"James Jones" <jamisonburrous08@insightbb.com> wrote in message
news:OG3TqwWoGHA.4152@TK2MSFTNGP04.phx.gbl...
> how would i for a browser to download a file (specifically mpgs)
>
> i can get it to go for small 4mb files, but the larger ones if they do go,
> take bout 15 mins to even begin the download.....
>
> any help greatly apprecitated!
>

Top