sending ASP output to a excel file

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
    - Visual Studion Connect to Win 2003 IIS 6.0 Server is challenged Every time developers try to connect to a Windows 2003, IIS 6.0 server they are challenged by NT. The directory is shared and they have full rights and can connect using Windows Explorer and Notepad. However, they are challenged with Visual InterDev 6.0. Only the administrator's login and password will let them in. I have re-set their permissions several times. Hmmmmm. Rich Tag: sending ASP output to a excel file Tag: 318831
  - 2
    - ASP on Win 2003 Server My window server is going to be upgraded from Win NT 4.0 Server to Win 2003 Server. I don't know if I can put an ASP web application on this new server without any problem. I guess ASP.NET would be better but right now I just have a classic ASP. Can you help me about this? Or any article about this issue would be greatly appreciated. Thank you, tim Tag: sending ASP output to a excel file Tag: 318829
  - 3
    - Way to limit total number of sessions from one IP address In trying to improve the throughput of a classic ASP app I wrote last year, I added monitoring to the application and session start and end methods. For one, I'm counting the total number of sessions and the high water mark. My monitoring has revealed a few interesting things. 1. The ASP application is being shutdown and restarted almost daily. The hosting company swears that neither the machine (shared server) nor IIS nor the application is being restarted. Is there any other way the Application_OnStart and _OnEnd methods might be invoked? 2. I found in the app log that apparently one invocation of the app was being shutdown while a new one was being started; i.e. the Startup event for the new run was logged before the Shutdown Complete event was logged (in the same file) for the old run. How is this possible? 3. At one point, about 40 new sessions were started up from one given IP address, with 5-10 seconds between start events being logged. Does this happen if the user has his browser's cookies disabled? How else might this happen (except perhaps for deliberate DoS-style hacking)? 4. Because of (3) above, I think I want to limit the number of concurrent sessions originating from a given IP address (I already keep an application-level array that tracks the IP addresses of all active sessions). To be least annoying to the end user, I presume I'd want to kill older sessions rather than not allow newer sessions (in case of browser crashing, for example). Is there a way to kill another session by ID, or to instruct another session to kill itself? Thanks tbone Tag: sending ASP output to a excel file Tag: 318828
  - 4
    - how to open and then close a new window? Host Environment: IIS in window 2003 server, three web servers, one load balance, ASP (not ASP.net) code set. Background: There is part A codes in one asp page (page A) to open a new window (Window B). The new window like a clock non-stop running. There is part B codes in the page A need to close window B. Problem: There is no problem if the there is only one web server. It works. When there is a load balance and more than one web server, then the window B can not be closed. Any help is appraciated. Tag: sending ASP output to a excel file Tag: 318823
  - 5
    - META REFRESH Can someone explain to me why the META Refresh doesn't work in an ASP.NET page? It works just fine in my old asp one! Content value has to be in quotes if not otherwise I get a warning. Thanks DOTNET -------------------- <%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" EnableSessionState="True" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>TEST</title> <meta http-equiv="refresh" content="10" /> </head> <body> </body> </html> ASP ---------- <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <?xml version="1.0" encoding="iso-8859-1"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html> <head> <title>TEST</title> <META HTTP-EQUIV="REFRESH" CONTENT=10> </head> <body> <div> </div> </body> </html> Tag: sending ASP output to a excel file Tag: 318822
  - 6
    - How do I check for the existence of a file? Greetings, I'm experimenting with an ASP page that reads data from a file name that is passed to it as a parameter, as in this page, which works, because the "good" file exists. http://mazes.com/asp-maze/customized.asp?file=good&firstname=jwk (make "your name is an amazing asp.general programmer" mazes. But when I try this page, with the "bad" file which does not exist, I'm not succeeding: http://mazes.com/asp-maze/customized.asp?file=bad&firstname=jwk I've tried several solutions that I found by googling. When I tried: If (ns.FileExists(zfil)<>true) then ... but even when I give it a valid name, it returns "False" I've tried using On Error Resume Next set nq=ns.OpenTextFile(Server.MapPath(zfil),1,true) if Err.Number <> 0 Then ... On Error Goto 0 I have found a workaround. Here is what finally worked: On Error Resume Next set nq=ns.OpenTextFile(Server.MapPath(zfil),1,true) if nq.AtEndOfStream=True Then zfil=custompath&"customdatadefault.asp" set nq=ns.OpenTextFile(Server.MapPath(zfil),1,true) end if But meanwhile, I'd love to hear how to check for the existence of a file. John Tag: sending ASP output to a excel file Tag: 318820
  - 7
    - copying page Is there a way, to make a page that gets info from a DB using scripting. then take that page, and copy it to another folder, BUT, not having the script there. making it become all html? so the page would contain html, but would be the result of what was scripted. so i guess i am saying, that the page would become the source. i hope i am explaining myself clearly Jeff Tag: sending ASP output to a excel file Tag: 318815
  - 8
    - Newbie question on error checking Hello, I am fairly new to ASP code and need help with error checking within my script. Specifically, I need to check for 3 things: 1. Trap the error if the script cannot find or connect to Active Directory. 2. Trap the error if the script cannot find the requested FSM Group. 3. Trap the error if the required input file is missing or it cannot create or edit the output file. I have learned a little about using the Err Object (Err.number and Err.description) but that is about it. Can anyone offer me any general tips/tricks about how best to do this or point me to some good reference material? Thanks in advance, Rich Tag: sending ASP output to a excel file Tag: 318814
  - 9
    - Question about For-Next Hello, I have a simple 'For Next'-code (see at the bottom). In the middle of the loop I want an IF-statement, which (if it is true) jump over to next level. I thought I could solve it through simple just writing an IF-statement and put Next in the middle, but an error message appears. Do you know how I can solve it? <% For m = 0 To Ubound(minArray,2) If Isnull(minArray(0,m)) or minArray(0,m) = "" Then Next End If Response.Write "Hello world!" Next %> Thank you! Kristoffer Tag: sending ASP output to a excel file Tag: 318812
  - 10
    - Form post not passing data to ASP??? I have IIS server installed on XP-pro. I also have Norton Internet Security installed. I can run simple ASP programs without any problem. But when I use forms with post method and call an asp in action, it does not pass any data to ASP. Request.Form method on a form field does not return any value. This code works on web hosting provider server, just does not work on my workstation with my own IIS server. Any help would be appreciated... Here is the form code: <html> <head> <title>Guestbook Form</title> </head> <body> <form name="form" method="post" action="seltest.asp"> Name: <input type="text" name="name1" maxlength="20"> <input type="submit" name="Submit" value="Submit"> </form> </body> </html> ------------------------ Here is the ASP code: <html> <head> <title>Entry Select</title> </head> <body bgcolor="white" text="black"> <% Response.Write (Request.Form("name1")) %> </body> </html> Tag: sending ASP output to a excel file Tag: 318800
  - 11
    - Length of words in a string. Hello all - I'm really at wits end on this as I'm not having much success with locating a function or other options I have. I'm working on a message board for a website and I'm needing to check the length of the words that users put in. For example, when someone puts in "yesssssssssssss!", I put together a small function that omits all of the s's as this is wreaking havoc on the layout of tables within the site. But I don't have a solution if someone types in "ssss ssasdfjskldjfaskld;jfaskdf" as random ambiguous letters. I know I can check the length of the entire string but don't know to check the words within it. Any help at this point is appreciated. Thanks, MN Tag: sending ASP output to a excel file Tag: 318790
  - 12
    - RegExp Question Premise: Inserting data into a database form a <textarea> and displaying this data through an HTML page. When inserting data into a database via a text area and then displaying this data any carriage return that was entered into the database was lost. I Created a function to replace a carriage return with a <BR>. I call this function when I display this data. If I enter text inside <> into a database and then display this data, any text that was within the <> is lost because it is considered an HTML tag. How can I search the string for the brackets and actually diplay them? I do not want to use Server.HTMLEncode before I insert the data into the database. This is because we often query the database from outside a web browser. Here is my function I have for the carriage return. I need to figure out how to accomplish this for both < and >. I am sure this is simple but I do not know what the .pattern should be (for a carriage return it is "\r". SET regQuote = New RegExp regQuote.pattern = "\r" regQuote.global = True catchCR = regQuote.Replace(strText, "<br>") Thanks in Advance. I will post this to an ASP and a VBScript Group. Tag: sending ASP output to a excel file Tag: 318785
  - 13
    - URGENT| navbar I'm paginating a recordset result with ASP I need a navigation bar like search engines (google for example) which display "previous" 1 | 2 | .... | n "Next" Queries could have hundreds of pages so I don't want to display 100+ numbers but only a defined number, say 10 just like google does Do you have any suggestions. Do you have any example url? Thanks Tag: sending ASP output to a excel file Tag: 318781
  - 14
    - ASP - Delete File Across Network - In Win 2003 Hi, I need to delete files across the network using web client (IE 6.x) in Win 2003 - IIS 6.0 environment. Can someone please suggest an approach I can use to acheive this. Will using FSO do the job or I have to go COM way. Thanks in advance. Parag Tag: sending ASP output to a excel file Tag: 318777
  - 15
    - ASP or ActiveX Hi simple question what is faster, ASP Code or compiled ActiveX DLL with same functions(queryng data from ms sql server) Regards; Mex Tag: sending ASP output to a excel file Tag: 318775
  - 16
    - Help wrapping text around an image I 've built a site for a client using .asp and eveything is working fine except I cannot figure out how to wrap text around an image. Everything is pulled from the database using response.write. The code works correctly but I just can't seem to figure out how to do it? I've been searching for weeks about info on how to do this - to no avail. Can anybody offer any help? thanx cobyfrombrooklyn PS the site is at www.caterdata.com/ann and the "Featured Artists" and "About" pages are what I'm concerned with. Tag: sending ASP output to a excel file Tag: 318767
  - 17
    - Opening ASP page causes file download dialog instead I have an issue with a particular ASP page on two web servers. Let's call these servers Dev1 and Beta1. Both Servers are running IIS 5, Windows 2000 SP4 with "almost" all of the latest patches. On Beta1, I am able to execute a particular page with no problem, that page opens up in the comes up just fine. On Win2kdev1, when I go to execute the same page, it opens a file download dialog and asks me whether I want to open or save the "file". Other ASP pages in the same directory display correctly. As far as I can tell, there is nothing obviously different between these working pages and the ASP page which causes the download dialog to open. The filetypes are all .ASP. I have verified that the app mappings (in IIS Manager, Directory/Configuration/App Mappings) are correctly set to point to asp.dll. I have removed and reset the app mapping just in case, but still get the same error. The problem can arise on a different page by doing something as trivial as changing some text and saving the page. I have compared file permissions on the file on both servers and they are exactly the same. I thought something was wrong with the page on Win2kDev1, so I copied over the page from Beta1. Same problem. I have checked the IIS logs, and I do not see any errors in the ex060120.log (for the last date that I tested this). Does anyone have any ideas for anything I can look at to try to figure out this issue? TIA. -- Neil Rossi Tag: sending ASP output to a excel file Tag: 318766
  - 18
    - Editable Textarea Hello all, looking for some help here! I've got a page on a website I'm developing that contains a textarea. The textarea will allow users of the site to enter a description of an item. When they submit the form that contains the textarea, the textarea and other form elements data are stored in a database. So far so good. My problem concerns carriage returns, new lines, line feeds or whatever else you want to call them :-) I want them preserved, so when the user wants to edit the description of the item, the format of the description is displayed exaclty as it was entered. The problem is that HTML renders the carriage returns as white space, so when the database is read and the textarea populated with the description field, the carriage returns are lost. I have tried the ASP REPLACE function to replace carriage returns with <br>, but the code below actually displays all the <br>'s. <%=Replace(myRecordset.Fields.Item("myField").Value,Chr(13),"<br>")%> I played around with different combinations of chr(13) and vbcrlf and I managed to get the textarea to display the description as it was entered with carriage returns, but upon further testing and editing of the description, because of the REPLACE function, the number of carriage returns was doubling each time! I'm sure this is a simple problem to fix, but I just can't find it at the moment - I hope someone can help. Many thanks, Robine *** Sent via Developersdex http://www.developersdex.com *** Tag: sending ASP output to a excel file Tag: 318762
  - 19
    - XML rss reader Hello I'm just new for RSS Feed based on XML files so I'd like to know if somebody knows about a good ASP class or functions to read and display these files Thanks Tag: sending ASP output to a excel file Tag: 318757
  - 20
    - Help: Dynamic variables syntax Hi. What's the correct syntax here: (given the recordset myRS with x records do until myRS.EOF txtvar & myRS("serial_number") = myRS("serial_name") myRS.movenext loop .asp will not build the dynamic variables txtvar1 = "Some name" txtvar2 = "Any name" txtvar3 = "Your name" .... Based on the serial_number in the current recordset How can I builde the dynamic variables, and give them a value from my recordset? Hope some of you understand, and can help me out.... Regards Mr. Smith Tag: sending ASP output to a excel file Tag: 318755
  - 21
    - How to send http post request in ASP Let's say if I want to send a http "Post" request to a url, and check the http status code later. How should I write the code? I have found example to use WinHttp to send "Get" request and check the http status code: ====== Set objWinHttp = CreateObject("WinHttp.WinHttpRequest.5") objWinHttp.Open "GET", strURL objWinHttp.Send If objWinHttp.Status <> 200 Then ... End If ====== How should I write the code if I need to use "POST" to send data in a form, and to check the http status code later? Tag: sending ASP output to a excel file Tag: 318754
  - 22
    - is it possible to get a page and put it in a variable? Hi basically i want to send a web page off by email. so i was thinking of putting some asp scrip at the end of the page to do this... <html>.....</html> <% dim a a = page_content send_email(page_content) %> but how do i get page content? Is there some variable I can read that has it stored? is there some way I can all the stuff that has gone out to browser? Cheers for any help Kal Tag: sending ASP output to a excel file Tag: 318753
  - 23
    - FTP a file with ASP Ray Costanzo [MVP], in a reply on December 7th, 2005 suggested the article http://groups.google.com/group/microsoft.public.inetserver.asp.general/browse_thread/thread/61b119678886a1e1/4ca193f328946c4a?q=ray+ftp&rnum=3#4ca193f328946c4a as a means to upload, via FTP, a file to another server. OK, given the flipping of the puts to gets, I am sure that with this method, I can use this to retrive files from another server and place them in a directory on my server. There are six files (the same 6 files) that I would have to download on demand, and then import them into an SQL server via Data Transformation Services. Since I am looking into downloading files that are 8Mb each and getting larger, how do you check this code for success/failure (or timeout). Wouldn't IIS timeout a script on a long transfer? Also, is there a security catch (provided that the script is hardcoded and not in the webspace)? Will this be a better solution than ASPInet that also would suffer from the same timeout (although it does support success/failure)? Sorry about the longwinded email but this part is new to me. Julian Tag: sending ASP output to a excel file Tag: 318750
  - 24
    - setting printer option from ASP page Hi, I have several asp pages which contains maps and I would like to provide an easy way for users to print this maps and they do not have to go through printer setup before they hit print on browser. I need to pre set the printer to landscape and 11x17 from my asp page. Is it possible? How can I do this? Thanks, Tag: sending ASP output to a excel file Tag: 318749
  - 25
    - question about IIS and ASP I am using IIS 6.0 and plain old ASP. My IIS server is for development, and is currently running different websites under different virtual directories. Most of these websites use ASP.NET, but we have a client on an old technology, and we wanted to put work for them under the same website in a different virtual directory. I set the virtual directory up successfully, and can access my site via: http://localhost/mynewclient/default.html where default.html is just a "hello world" page. Comes up just fine. The problem is, if I were to rename this page which contains html to a .asp extension -- i get a 404 error. Is there something special I need to do in IIS to allow the asp extensions to be run successfully? Thanks for any insight, Danielle Tag: sending ASP output to a excel file Tag: 318744
- Next
  - 1
    - How does one update all records displayed in a asp page Hi, I got a test asp page which connects to Northwind.mdb database. This page pulls all the rows from the Customers table. One column i.e. GoodStatus has been added to the customers table. The following is the code to display all records of the customers table with some customization. CODE: <%@ Language=VBScript %>  <HTML> <BODY> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> <title>Testing Multiple Records Save</title> <SCRIPT LANGUAGE="VBScript"> sub btn_LogOut_OnClick() dim asnwer answer=msgbox("Are you sure you want to exit?.",vbYesNo,"Warning") if answer=vbyes then window.location.href = "http://localhost/beginaspdatabase1/" end if end sub sub btn_Save_OnClick() dim asnwer answer=msgbox("Are you sure you want to save your changes?",vbYesNo,"Warning") if answer=vbyes then window.location.href = "http://localhost/beginaspdatabase1/update_all_records.asp" end if end sub </SCRIPT> </HEAD> <% myDSN="Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Northwind97\Northwind.mdb" set CN=server.createobject("ADODB.Connection") CN.Open myDSN set sRS=server.createobject("ADODB.Recordset") sRS.ActiveConnection = CN SQL = "SELECT EmployeeID, LastName, FirstName, Title, GoodStatus from Employees" 'Response.Write SQL & "<br>" 'Response.End sRS.Open SQL %> <div ALIGN="CENTER"> <big><big><font COLOR="navy">Test Database Northwind</font></big></big> <H4> <font COLOR="red">Saving changes of all records at one time</font> </H4> </div> <div ALIGN="CENTER"> <% Response.Write "<table border='1' width='50%' height='1' cellspacing='1' >" Response.Write "<th>ID</th><th>Last Name</th><th>First Name</th><th>Title</th><th>Good Status</th>" %> <% do until sRS.eof ID = sRS("EmployeeID") LastName = sRS("LastName") FirstName = sRS("FirstName") Title = sRS("Title") l_GoodStatus = sRS("GoodStatus") %> <tr> <td align='center' width = '5%'> <font color="#000000"> <%Response.Write ID%></font> </td> <td align='center' width = '12%'> <font color="#000000"> <%Response.Write LastName%> <td align='center' width = '12%' > <font color="#000000"> <%Response.Write FirstName%> <td align='center' width = '10%'> <font color="#000000"> <input type="text" name="txt_Title" size="33" value ="<%Response.Write (Title)%>" style="font-family: Times New Roman; font-size: 10pt"></font> </td> <%'Response.Write Title%> </td> <td align='center' width = '8%'> <font color="#000000"> <input type="checkbox" name="chk_GoodStatus" value="ON" <%Response.write l_GoodStatus%><%if cbool(l_GoodStatus) then response.write " checked" else Response.write " unchecked"%>> </td> </tr> <% sRs.MoveNext loop sRS.Close Set sRS = Nothing %> </DIV> <input type="button" value="Log Out" name="btn_LogOut" > <input type="submit" value="Save" name="btn_Save"> </BODY> </HTML> Now I need to change some values in the title and goodstatus field and save all the changes in whatever records made. This update has to be in asp page update_all_records.asp as pointed in the code above. I have no idea how to handle all the rows as in the present case. Any help or suggestion is appreciated. Thanks. Tag: sending ASP output to a excel file Tag: 318743
  - 2
    - ASP/PerlScript and reading and writing files In ASP, using PerlScript, how do you read and write to files? Tag: sending ASP output to a excel file Tag: 318736
  - 3
    - RSS Reader Hello I'm just new for RSS Feed based on XML files so I'd like to know if somebody knows about a good ASP class to read and display these files Thanks Tag: sending ASP output to a excel file Tag: 318735
  - 4
    - Errors after upgrading SQL Server 2000 database compatibility level Hello, we are preparing for an upgrade to SQL 2005 and as a result of this I became aware that the compatibility level of one of our databases was set to level 65 (current SQL server is SQL 2000 SP4). Managing this server is something I have fallen into, so I am not sure of the exact reasons its compatibility level has stayed lower. When I upgrade the level however, some of our ASP pages throw the following error: ADODB.Recordset error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. The recordsets for these asp pages are being saved in sessions, which I know can be problematic. Does anyone have any idea though why this error would be returned after upgrading the compatibility level? Thanks a ton for any help. Tag: sending ASP output to a excel file Tag: 318728
  - 5
    - Locale-dependent Date&Time input via HTML forms - Hi, In our legacy asp/web-application, we have date/time-input form in USA style (i.e. mm/dd/yyyy and 12hour-scale time with AM/PM). There is also some validation code on client side, and then submitted data are used in MSSQL queries. Now I would like to know about how to generate locale-dependent HTML form layout, and what ready-made ASP code could I borrow for this task. Thank you in advance for your replies. Tag: sending ASP output to a excel file Tag: 318725
  - 6
    - problem with write cookie when i try to write cookie on ASP page with the line like this <% Response.Cookie ("username")="test1" %> i get the message: object doesn't support this property ormethod: 'cookie' i use windows 2000 server any suggestion? thank you Tag: sending ASP output to a excel file Tag: 318724
  - 7
    - Use Active Directory Group in a dropdown form control Hi, I am a newbe in ASP prog, and I am a little "bothered" about a script that I need. I would like to list IN our Active directory all group that begin named and start with "GRP-" to put in a dopsown list for a form. Somebody can help me ? Maybe for the begging, the code to only list group in AD to display in a webpage can be nice. Thanks Tag: sending ASP output to a excel file Tag: 318721
  - 8
    - Military Time Problem If I have a datetime sql field with afternoon datetime values like below in DATETIME VALUE, how can I display the time part in ASP as 1:00 PM, instead of 13:00 PM as seen in CURRENT RESULTS below? Currently, I'm getting my CURRENT RESULTS by using the HOUR() function. Is there a way to display just the time part in "non-Military" time format? DATETIME VALUE: 2006-01-24 13:30:00.000 CURRENT RESULTS:: 13:30 PM DESIRED RESULTS: 1:30 PM Tag: sending ASP output to a excel file Tag: 318715
  - 9
    - How to do use checkbox in a response.write that pulls all data Hi, I have a asp page. This page pulls all data from a query. Part of the code is as follows: <% Response.Write "<table border='1' width='80%' height='1' cellspacing='1' >" Response.Write "<th>Key</th><th>SubgrantID</th><th>Title</th><th>Unlock</th><th>Unverify" %> <% do until sRS.eof Key = sRS("SubgrantIntId") Subgrant = sRS("ComboID") Title = sRS("Title") Unlock = sRS("IsChecked") Unverify = sRS("IsVerified") %> <tr> <td align="center"> <div style="cursor:hand"><p align="left" OnClick="location.href='mainreportagain1.asp?GrantID=<%Response.Write Key%>'"> <u><font color="#0000FF"> <%Response.Write Key%></font></u></div></td> <% 'this writes out the key%> </td> <td align='center'> <font color="#000000"> <%Response.Write Subgrant%> <td align='left'> <font color="#000000"> <%Response.Write Title%> </td> <td align='left'> <font color="#000000"> <%Response.Write Unlock%> </td> <td align='left'> <font color="#000000"> <%Response.Write Unverify%> </td> </tr> In the above code, in the statements response.write Unlock and response.write unverify I would like to bring checkboxes. The back end data for these two fields in the database are actually checkboxes. I would appreciate any help to handle the situation where the rows should show checkbox values for the two fields mentioned above. Thanks. Tag: sending ASP output to a excel file Tag: 318710
  - 10
    - Sending binary file (PDF) over SSL using ASP script Hello, Here's a quick explanation & problem: i have an ASP (iis v5.0) application that generates a pdf file and this file is saved to the server. it is saved in a location not available to web users. i have an asp script (below) that sends the pdf file to the user as a binary stream. So that the user specifies which file to upload, the script performs some security checking and if it passes, it sends the pdf document. This works great in HTTP, but i want to do this using SSL. When i try the same thing over SSL, it gives me a 'File Download' dialog box with Open, Save, Cancel, More Info. The file name is the name of my script and file type is 'Adobe Acrobat Control for ActiveX'. When i click Save or Open i get an error message: Internet Explorer cannot download [scriptname] IE was not able to open this Internet site. The requested site is either unavailable or cannot be found. Please try again later. The key to all this is that the report can change and i need to make sure the data doesn't get cached along the way. Hence there are a bunch of header manipulation commands included in the send function. Any help would be much appreciated. Rgds, yt PDFSend.asp >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> <% Function getBinaryFile( strFilePath ) Dim oStream Set oStream = Server.CreateObject( "ADODB.Stream" ) ' Create the object oStream.Open ' Open our file oStream.Type = 1 ' 1 = Binary oStream.LoadFromFile strFilePath ' Retreive binary data from the file getBinaryFile = oStream.read ' Return the binary data to the caller Set oStream = Nothing ' Destroy the ADO object End Function if blnSecurityPass Then ' SUCCESSFUL PASS - SHOW REPORT Response.Clear Response.Buffer = True Response.AddHeader "Pragma", "no-cache" Response.AddHeader "Expires", "Mon, 1 Jan 2000 05:00:00 GMT" Response.AddHeader "Last-Modified", Now & " GMT" Response.Expires = -1 Response.ContentType = "application/pdf" Response.BinaryWrite getBinaryFile( strFilename ) Response.End End if %> >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Tag: sending ASP output to a excel file Tag: 318705
  - 11
    - Publishing aspx page Something was wrong with my IIS 'Service unavailable', I decided to uninstall IIS and then reinstall it, then the simple pages can be viewed but the aspx pages not. Then I uninstall SQL server 2005 and Visual Studio 2005 and reinstall it. Now I can view simple pages but not aspx pages, but when running from the debugger of Visual Studio, it Works good. When I access an aspx page 'The page cannot be found' error occurs Thanks. Tag: sending ASP output to a excel file Tag: 318696
  - 12
    - Reading filename and insert Can someone help me with a quick script. I need to browse filenames in a directory and insert them into my sql table. I want to run this in an ASP page. I know how to connect to the database, etc. I just need the script on how to get the filenames. directory: C:\websites\photos tablename: photos fieldname: photoname *** Sent via Developersdex http://www.developersdex.com *** Tag: sending ASP output to a excel file Tag: 318686
  - 13
    - For each item in Request.Form I need to iterate through a submitted form, inserting data on each pass. In the past, I have always used form elements that were named with numbers at the end, like this, name1 relationship1 name2 relationship2 name3 relationship3 With the above formatting, I could write a For... Next loop to insert all the data into my database, For i = 1 to 3 If Request.Form("name" & i) <> "" Then sql = INSERT INTO Table (Name, Relationship) sql = sql & " VALUES" sql = sql & "('" Request.Form("name" & i) "'," sql = sql & "('" Request.Form("relationship" & i) "')" 'Execute SQL End If Next Now I am working on a new loop, but do not want to go back and change the way the submitting page works. I saw on while researching that I can use a For each item in Request.Form, but tried this and it throws off my SQL statement. It adds all of the request.form values to the sql statement, which then fails. How can I make this loop? Thanks, Drew Tag: sending ASP output to a excel file Tag: 318678
  - 14
    - SQL timeout during asp script Could use a little help. I have an asp script that insert information into a SQL 2003 db table. The script works for about the first 3000 entries and then give me a .... DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. Obviously the server is there, since this is working for the first 3000 entries. I can then do a "where id> 3000" and run it again and it'll run about another 3000 then same error. What can I do to stop this error and have the entire process run? *** Sent via Developersdex http://www.developersdex.com *** Tag: sending ASP output to a excel file Tag: 318677
  - 15
    - Exporting to excel Hi There, I am trying to export a recordset to an excel file using the Content Type below in the header. Response.ContentType = "application/vnd.ms-excel" Which works fine however the problem is that when I have a number in a column with a leading zero the zero gets dropped. E.G. 01760942 will be displayed as 1760942 How can I rectify this? Thanks, Kevin. Tag: sending ASP output to a excel file Tag: 318671
  - 16
    - Question on ASP and worldpay callback HI all I wondered if anyone can give me some advice on wow to deal with the call-back process generated by Worldpay. My understanding is that after a transaction Worldpay will send the result's to a specified URL. All of the scripts I've looked at parse the query string and display the data onto a web-page, which obviously renders a page, as there is no one to read this and it does not go to the client I'm not sure what use these scripts are. I have a couple of general ASP questions if anyone has a solution How do you make a call to an asp page that updates a database but does not render a page? I'm probably being dumb but what does the url look like? I.E can I make a call direclty to a web-service to update my DB. I'm running dot.net framework 1.1, MCMS 2002 and using visual studion 202 Any thoughts are greatly appreciated Mikey Tag: sending ASP output to a excel file Tag: 318670
  - 17
    - ASP and JavaScript newbie question Hi all, I'm the IT Support guy for a school. They run a resource booking Access database that the manager would like to convert to a web page. I have nearly done so, using pure ASP to draw the web page, retrieve the bookings info from an SQL database. It looks quite nice, and thus far, works pretty well! I have come completely unstuck when using the "OnChange" event for all the textboxes that display the current bookings, or lack of a booking, for a day/session. I have inserted |onChange=txtOnChange(this.value,this.name," & chr(34) & Rsrce & chr(34) & "," & chr(34) & mnth & chr(34) & ")| (ignore the pipes - they're for readability only) which calls a client side JavaScript function (receiving four variables) to update the database. This script works fine except for the fact that IE or whatever browser warns "the web site may not be trusted. Continue?" when attempting (in the Javascript function) to connect to the SQL database and update the record. Since I cannot change the security settings for every person's browser, and I have to use a client side JavaScript function to update the database, is it possible to merely have the JavaScript function call a server side .ASP file and update the record that way? Something like:- <SCRIPT TYPE="text/javascript">  </SCRIPT> <SCRIPT LANGUAGE="JavaScript">  </SCRIPT> Tag: sending ASP output to a excel file Tag: 318664
  - 20
    - The HTTP headers are already written to the client browser Hi. I am getting the following error on one of my asp pages... The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content. I think I understand what the problem is, but what I am curious about is I only get this problem when the page resides on my web server (Windows 2K3). However when it resides on my development machine (Windows XP with IIS 5.1) I do not have this problem. The browser is the same in both instances. Is there a setting somewhere in IIS that is responsible for this different behavior? Thanks. Tag: sending ASP output to a excel file Tag: 318649
  - 21
    - Search for Multiple keywords in multiple fields Hi All This is a complicated one, not for the faint hearted :) :) :) Please help if you can how to achieve this search. We have a freetext search entry box to allow users to search the database. I am searching two tables. SELECT TapeRecords.Id, TapeRecords.ItemTitle, TapeRecords.SourceRef, TapeRecords.ItemYear, TapeRecords.TapeNumber FROM TapeRecords WHERE TapeRecords.Id In (select tapenumber from TapeLogDetails where TapeLogDetails.Description LIKE '%%asia%%' ) OR (TapeRecords.ItemTitle LIKE '%%asia%%' ) OR (TapeRecords.Location LIKE '%%asia%%') OR (TapeRecords.Country LIKE '%%asia%%') OR (TapeRecords.Keywords LIKE '%%asia%%') ORDER BY TapeRecords.Id DESC; The search logic also needs to allow users to search for multiple entries for example if I was to type Asia Burma it should find all records where asia and burma appears. Sound simple , well it is not. Because my researchers requires the search to work where the either of the two words (i.e. Asia and Burma) were present in any combination of the fields. i.e Asia might be in description and Burma might be in any of the other fields, i.e. to find the two keywords in any combination. can anyone help? Tag: sending ASP output to a excel file Tag: 318642
  - 22
    - QUERY: debugging ASP VBScript I am currently developing a website in ASP (VBScript) using MS Visual C#.NET IDE. I just create a new "ASP.NET Web Application" and point to my local webserver (IIS) of my website address. Then I just go through each file/folder and right-click, selecting "Include in project". The IDE is nice in that it checks, verifies id tags, etc. What am wondering is whether it's possible to debug my ASP website using the MS Visual Studio.NET's debugger. I did a google search for 'debugging ASP VBScript' and got: http://www.microsoft.com/windows2000/en/server/iis/htm/asp/iiwadbug.htm It seems possible, however I can't seem to get it working. Anyway knows how to debug ASP scripts efficiently? Tag: sending ASP output to a excel file Tag: 318638
  - 23
    - Upload files to different server Hello I want to upload files to a server with asp. But the problem is that the server where my asp website stands is a different server then where my upload files must go. Is there a way to accomplish that. Does anyone has an example perhaps greetz akasha Tag: sending ASP output to a excel file Tag: 318633
  - 24
    - Code not pulling enough records Hey gang. i have a code that i will list. when varM = 8 or 16, the script works fine, and pulls the top 8 or top 16, but if it =32 or 64, it is only pulling the top 17 records from the DB. db is access and this is MS server. here is the code <% if varm = 8 then set admin6 = conn.execute("select top 8 username, iCHECK from members2_tourney where tourney_id = " & varID & "") else if varm = 16 then set admin6 = conn.execute("select top 16 username, iCHECK from members2_tourney where tourney_id = " & varID & "") else if varm = 32 then set admin6 = conn.execute("select top 32 username, iCHECK from members2_tourney where tourney_id = " & varID & "") else if varm = 64 then set admin6 = conn.execute("select top 64 username, iCHECK from members2_tourney where tourney_id = " & varID & "") else end if end if end if end if IF NOT admin6.EOF AND NOT admin6.BOF THEN do while not admin6.eof varnm = admin6.fields.item("username").value varch = admin6.fields.item("iCHECK").value if varch = "Yes" then rowcolor = "#4477aa" fontcolor = "#ffffff" else rowcolor = "#FFFFFF" fontcolor= "#000000" end if %> what i need to know, is if there is another way to pull a certain amount of records from a DB. the reason it is in mulitples of 8, is because this is for a tournament site, so the brackets are set in multiples of 8 any ideas?? Tag: sending ASP output to a excel file Tag: 318631
  - 25
    - 430 Forbidden error on XP machine calling webservices. Hi I've got this strange situation. I'm calling multiple webservices that are all installed on my local machine from a web application that uses frames holding more web applications. The web applications all use integrated windows authentication. The web services have anonymous access enabled. When clicking around on the web sites I will get a security exception 403 when a method is invoked on the web service. But this happens on different spots every time. So sometimes a function works and the next time it gives me a 403 ? I don't get it. Can this have something to do with the maximum connections to XP-Pro ? On the one side I think this can be the case but I'd expect IIS to raise a completely different exception something like maximum connection limit reached.... Anyone have a Idea of what this could be ? Kind Regards -- Rainier van Slingerlandt (Freelance trainer/consultant/developer) www.slingerlandt.com Tag: sending ASP output to a excel file Tag: 318627

Hi all

I have a asp page which will get the data from multiple tables (with
functions and procedures)and display data in HTML tables <TABLE> on ASP
page.
Is there any way we can create a excel file from the output of this ASP
file.
I know how to export if this information on ASP page is coming from single
query from a database table.
Any suggestions???

Thanks
mvr

Top

Re: sending ASP output to a excel file by dNagel

dNagel
Mon Jan 30 20:39:24 CST 2006

http://groups.google.com/group/microsoft.public.inetserver.asp.general/msg/2feb9106735030dc?hl=en&

D.

mvr wrote:
> Hi all
>
> I have a asp page which will get the data from multiple tables (with
> functions and procedures)and display data in HTML tables <TABLE> on ASP
> page.
> Is there any way we can create a excel file from the output of this ASP
> file.
> I know how to export if this information on ASP page is coming from single
> query from a database table.
> Any suggestions???
>
> Thanks
> mvr
>
>

Top

Re: sending ASP output to a excel file by lyma

lyma
Tue Jan 31 02:53:42 CST 2006

You should use a third party tool if you want to have multiple worsheet
and a real Excel Biff format...

Let have a look at those 2 goods one :
- DypsXLS from Dypso BackOffice
- ExcelWritter from SoftArtisan

Top