Exporting Results from Webpage to Excel

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
    - Detect Session Timeout Hi to all I have searched this subject and found some posts but none of them seem to answer my problem. I am developing a shop site and need to detect when a session times out through inactivity and tell the user that it has been reset and he has to start over. I set some session variables in a global.asa file so when the user restarts the session variables reset and I can't detect if they change. For example 'If Session("id") <> Some kind of check' will always return False because the check mechanism resets as well I've tried sending an ID to a database table in the global.asa but my server doesn't seem to handle that. The answers given on this subject all assume that the user will enter via a log in page. I can't arrange this on this particular site because it is only account customers who have to log in, general punters are served pages direct and they could enter the site anywhere. Hope I have explained the problem well enough for you to help. Clive Tag: Exporting Results from Webpage to Excel Tag: 318939
  - 2
    - IIS - Crashing I use plain old asp to code my pages with. Is there anything that would make the entire server freeze up? There's about 500 pages of which maybe 150 call a database for serving up the pages or updating an access database. There's approximately 150 people accessing the pages at the same time. Not all the database pages but using the intranet at the same time. I'm not real familiar with IIServer so any ideas are appreciated. Jess Tag: Exporting Results from Webpage to Excel Tag: 318938
  - 3
    - XML Caching in Classic ASP on IIS 6.0 We have a website that reads data from Oracle and creates an XML file. Then the site uses that file to access the info faster. On IIS5 we have no problems, but on IIS6 we seem to have some caching issuses. This deals with the Worker Processes. By default, there is only 1 Worker Process that gets recycled after 1700 minutes or so. The problem is, that we will select some data from the screen, which opens up another window to update the info. We walk through the update process and change some data and it updates the page fine. We can even check the XML file and it is changed, but if you choose to go back into that data, the dropdowns will reflect whatever was initially in the XML not the changes. If I increase the number of Worker Processes and shorten their recycle time, this doesn't seem to be a problem, but for every request I am generating a 25M file on the server that eventually gets recycled. I don't want to load up the memory with useless files, but I want our application to reflect the correct data. I really need to do this without affecting any other possible web apps that may be on the box. Any advice? Tag: Exporting Results from Webpage to Excel Tag: 318937
  - 4
    - ASP / SQL Problem I think this is a ASP problem. Here is my SQL procedures my the SQL server I can run these in SQL Query Analyzer and get the correct results. However, when I try to run them through my ASP page, the first two do not return any results. I can't figure out why. SQL Statement 1. Returns all records SQL Statement 2. Returns records after begDate SQL Statement 3. Returns records after begDate and before endDate SQL Statement 4. Returns records before endDate IF EXISTS (SELECT * FROM LITDB_tblCalendar WHERE @begDate is NULL and @endDate is NULL) BEGIN SELECT HrngID, AdjName, DispDueDate, ClaimNumber, Juris, HearingDate, HearingType, ClaimantName, Location, HearingTime, HearingPart, Counsel, DispDone, Canceled, WasRescheduled FROM LITDB_tblCalendar WHERE DispDone = 0 or DispDone IS NULL ORDER BY DispDueDate DESC END IF EXISTS (SELECT * FROM LITDB_tblCalendar WHERE @begDate is NOT NULL and @endDate is NULL) BEGIN SELECT HrngID, AdjName, DispDueDate, ClaimNumber, Juris, HearingDate, HearingType, ClaimantName, Location, HearingTime, Counsel, DispDone, Canceled, WasRescheduled FROM LITDB_tblCalendar WHERE DispDueDate >= @begDate and (DispDone = 0 or DispDone IS NULL) ORDER BY DispDueDate DESC END IF EXISTS (SELECT * FROM LITDB_tblCalendar WHERE @begDate is NOT NULL and @endDate is NOT NULL) BEGIN SELECT HrngID, AdjName, DispDueDate, ClaimNumber, Juris, HearingDate, HearingType, ClaimantName, Location, HearingTime, Counsel, DispDone, Canceled, WasRescheduled FROM LITDB_tblCalendar WHERE DispDueDate >= @begDate and DispDueDate <= @endDate and (DispDone = 0 or DispDone IS NULL) ORDER BY DispDueDate DESC END IF EXISTS (SELECT * FROM LITDB_tblCalendar WHERE @begDate is NULL and @endDate is NOT NULL) BEGIN SELECT HrngID, AdjName, DispDueDate, ClaimNumber, Juris, HearingDate, HearingType, ClaimantName, Location, HearingTime, Counsel, DispDone, Canceled, WasRescheduled FROM LITDB_tblCalendar WHERE DispDueDate <= @endDate and (DispDone = 0 or DispDone IS NULL) ORDER BY DispDueDate DESC END Here is the code in ASP that corresponds <%@ LANGUAGE="VBSCRIPT" %> <% FromDate = Request.Form("FromDate") ThruDate = Request.Form("ThruDate") Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "Provider=sqloledb;" & _ "Data Source=SQLF;" & _ "Initial Catalog=NYSA;" & _ "User Id=APP_NYSA;" & _ "Password=$NYS" strSQL = "EXEC dbo.litDispositionsDue" & _ " @FromDate = '" & FromDate & "', " & _ " @ThruDate = '" & ThruDate & "'" Set rs = Conn.Execute (strSQL) %> <form action="lstDispositionsDue.asp" method="post"> <table align=center width="85%"> <% if not rs.eof then rsArray = rs.GetRows() nr = UBound(rsArray, 2) + 1 With RS .MoveFirst do while not .eof %> <tr> <td align=center width=50> <% response.write "<A HREF='EditHearingNotice.asp?id=" & rs("HrngID") & "'>"%><% =rs("HrngID") %></a></td> <td align=center width=100><% = rs("DispDueDate") %></td> <td align=center width=100><% = rs("ClaimNumber") %></td> <td align=center width=200><% = rs("AdjName") %></td> <td align=center width=100><% = rs("HearingDate") %></td> <td align=center width=50><% = rs("Juris") %></td> <td align=center width=175><% = rs("Location") %></td> <td align=center width=300><% = ucase(rs("Counsel")) %></td> </tr> <% .movenext loop end with end if %> </table> Tag: Exporting Results from Webpage to Excel Tag: 318926
  - 5
    - Using Vbscript function on Multi-select field I am trying to use the vbscript "split" function on a multi-select field. I am trying to do a mass update of several records at a time. I am getting an error and I'm not sure what to do. Here is the code if someone could help... strID = split(request.form("proj"), ", ") projstat = split(request.form("rojstat"),",") impr = split(request.form("impr"),",") idate = split(request.form("rojinitdate"),",") pdate = split(request.form("plancompletedate"),",") adate = split(request.form("actualcompletedate"),",") mdg = request.form("mgr") myArray3 = Split(mdg,"- ") p = ubound(myArray3) if mdg = "Not Assigned" Then mdgg = "Not Assigned" else if p = 1 then mdgg = myArray3(0) else if p = 2 then mdgg = split((myArray3(0) & "*" & mid(myArray3(1),6)),"*") else if p = 3 then mdgg = split((myArray3(0) & "*" & mid(myArray3(1),6) & "*" & mid(myArray3(2),6)),",") else if p = 4 then mdgg = split((myArray3(0) & "*" & mid(myArray3(1),6) & "*" & mid(myArray3(2),6) & "*" & mid(myArray3(3),6)),",") else if p = 5 then mdgg = split((myArray3(0) & "*" & mid(myArray3(1),6) & "*" & mid(myArray3(2),6) & "*" & mid(myArray3(4),6)),",") end if end if end if end if end if end if FOR i = LBound(strID) TO UBound(strID) mySQL = "UPDATE Roj SET rojstatus= '" & trim(rojstat(i)) & "', importrank= '" & trim(impr(i)) & "', mgr= '" & trim(mdgg(i)) & "', rojinitdate= '" & trim(idate(i)) & "', plancompletedate= '" & trim(pdate(i)) & "', actualcompletedate= '" & trim(adate(i)) & "' where (refid ='" & strID(i) & "')" dbRroject.Execute(mySQL) NEXT This is the error I'm getting Response object error 'ASP 0106 : 80020005' Type Mismatch /project/DMMassUpdated.asp, line 0 An unhandled data type was encountered. Can anyone HELP? Tag: Exporting Results from Webpage to Excel Tag: 318925
  - 6
    - ASP Calling ISAPI DLL Hello ALL, I have ASP pages that calls some ISAPI dll that created using Delphi for generating reports. The report page opens fine for 1st time when invoked but next time i get error like "Name not unique in this context." My quesry string pass to dll like: ../ReportsDLL/NameOfDLL.dll?PatID=100578&ThpID=12&State=FL I think after the DLL is loaded it is not freeing the memory and not unloading the dll from memory. SO How can i free memory used by the DLL or unload the DLL from within the ASP page that load the url to window.location? How can I free the objects / DLL that I loaded from the ASP page using the above querystring? Note: I think the delphi code that is written for DLL is working fine as It works fine for 1st time. Please suggest and advice. Thanks Prabhat Tag: Exporting Results from Webpage to Excel Tag: 318924
  - 7
    - Unzipping component for .ASP On Windows Server 2003, IIS 6 I am looking for an unzipping component. I have a series of files that are available zipped at a considerable decrease in size. And before ASPINET fails on a script timeout, I'd rather download the zip file and unzip it when it arrives. Any ideas on a reliable product for this on my platform? Julian Tag: Exporting Results from Webpage to Excel Tag: 318923
  - 8
    - Updateing a record Whenever i try to update a record i always get the dreaded "No permissions" here is my updates statement. Please help. Function updateData() cid = Request.QueryString("wrkstaID") sql="UPDATE work_station SET " sql=sql & "workstation='" & Request.QueryString("workstation") & "'," sql=sql & "cpu='" & Request.QueryString("cpu") & "'," sql=sql & "memory='" & Request.QueryString("memory") & "'," sql=sql & "hard_Drive='" & Request.QueryString("harddrive") & "'," sql=sql & "servicepack='" & Request.QueryString("servicepack") & "'," sql=sql & " WHERE work_StationID='" & cid & "'" on error resume next conn.Execute sql if err<>0 then response.write("No update permissions!") else response.write("Record " & cid & " was updated!") updateData = True end if 'conn.close End Function Tag: Exporting Results from Webpage to Excel Tag: 318918
  - 9
    - ASP.NET 2005 Solution Problem I'm developing a web service that will eventually be sent to other like organizations to communicate for a particular application. After a few weeks, I decided it would be better to split of the web service and custome code from the required code. In doing so, I created a class project. This left me with a new solution of a web site and a class. I had previously created the class seperately and added it to sourcesafe. I then added the class to the web service project, which is where the solution was created. Two problems with this and sourcesafe. 1) If I add the solution and web service to sourcesafe, the next time I open the solution from sourcesafe, the web service no longer functions properly. It seems you can't add any references to it and some that were there can no longer be read. 2) If I add just the website, that works, but the next time you want to open the solution and change part of the class and redeploy, the class does not exist, needs to be readded, updated, etc... which is not correct. Can anyone decipher this problem? What is the correct method to build this type of solution and how to add it to sourcesafe? Are there any documents out there discussing best practices in storing, creating, etc... in sourcesafe? Tag: Exporting Results from Webpage to Excel Tag: 318910
  - 10
    - Thesaurus & internationalisation Hi I am writing a web application (visual basic language) that must be multi-national. I know that I can handle different languages using resource files. However, I need to extend this application to handle a Thesaurus. By this, I mean that a user may wish to over-ride any of the words that they see with words that they are more familiar with (or just prefer). As an example: Imagine an eCommerce site. If you are a regular customer you may wish to set up a set of shopping lists, one that you access every Friday and one that you access on the first Monday of each month. You would create these shopping lists and then save them, giving each a unique name. When accessing the shopping lists, there would (presumably) be a drop-down list showing all the shopping lists that you have saved. Besides this list would be a label which would say something like "Please select your shopping list". This value would be saved in a resource file and the relevant language would be chosen; so something like "Veuillez choisir votre liste d'achats" would appear if you were French (please excuse me if this is incorrect French - I just used http://babelfish.altavista.com/ to create it). Now, that's all well and good, except that some people may dislike the term "shopping list" and wish to see "order pad", or "requisition" or whatever they think is appropriate (and the French equivalent). I'm not sure of the best way to do this - it's got to be scalable both in terms of performance, load and general administration. My first thought would be to have the string (held in the resource file) contain a place holder, so something like "Please select your ^list^" or "Veuillez choisir votre ^list^". I would then replace ^list^ by their preferred term (or use a default term if not specified). This term would exist in a data base (and be held in some sort of session-cache for performance). I can't believe that I am the first person to need to do this sort of thing, so I'd like to know if there is a recognised "best practice" for this sort of thing. Many thanks in advance Griff Tag: Exporting Results from Webpage to Excel Tag: 318901
  - 11
    - CDONT Is it possible to extract from a CDONT a value that has been added to it? e.g. can I say: MyCDONTSMail.From="some email address" MyCDONTSMail.To="some other email address" MyCDONTSMail.Subject="some subject" MyCDONTSMail.Body="some body" And then get those values later in the program e.g.: MailFrom = MyCDONTSMail.From MailTo = MyCDONTSMail.To MailSubject = MyCDONTSMail.Subject MailBody = MyCDONTSMail.Body Thanks! Tag: Exporting Results from Webpage to Excel Tag: 318898
  - 12
    - Getting a CDONT parameter My website sends automatic emails from many (25) different places. I want to send a second email by reading the parameters of the first one. I don't want to have to repeat and maintain the assignment of the second email From,To,Subject fields so I am just using an include at each point in the code where I send an email: Set MyCDONTSMail = CreateObject("CDONTS.NewMail") MyCDONTSMail.BodyFormat= 0 MyCDONTSMail.MailFormat= 1 MyCDONTSMail.From= fromemailaddress@whatever.com MyCDONTSMail.To= toaddress@whatever.com MyCDONTSMail.Subject="some subject" MyCDONTSMail.Body= "some text": %>  <% MyCDONTSMail.Send set MyCDONTSMail=nothing ------------------------------------------------------------------------------- The SendFollowUpEmail.asp just wants to take the From,To,Subject parameters that are defined in the original email and add a different body: Set MyCDONTSMail2 = CreateObject("CDONTS.NewMail") MyCDONTSMail2.BodyFormat= 0 MyCDONTSMail2.MailFormat= 1 MyCDONTSMail2.From= MyCDONTSMail.From MyCDONTSMail2.To= MyCDONTSMail.To MyCDONTSMail2.Subject=MyCDONTSMail.Subject MyCDONTSMail2.Body= "some new text" MyCDONTSMail2.Send set MyCDONTSMail2=nothing It chokes on this: MyCDONTSMail2.From= MyCDONTSMail.From Object doesn't support this property or method: 'MyCDONTSMail.From' Seems to me MyCDONTSMail.From is only a string, why can't I retrieve its value? More to the point though - how can I retrieve its value? Thanks! Tag: Exporting Results from Webpage to Excel Tag: 318885
  - 13
    - XML/ASP Help Needed I am new to XML, but not ASP. I have the following XML that I load via Dim xml Set xml = Server.CreateObject("Microsoft.XMLDOM") xml.async = False xml.loadXML xmldom.xml <deals><escanoffers><escanoffer offerid="3743" itemnumber="502022" upc="4300094509" dealamt="0.20" begindate="03/01/2006" enddate="03/30/2006" returnby="02/28/2006" selectionlength="14" maxretail="0.00" /></escanoffers></deals> I need to parse it, getting all the attributes out, using ASP. AHIA Larry... Tag: Exporting Results from Webpage to Excel Tag: 318871
  - 14
    - Limitation of the number of recordsets ASP is able to proceed? Is there a limitation of the number of recordsets ASP is able to proceed? When my Access database exceeded 544 records, only first 544 records are shown Tag: Exporting Results from Webpage to Excel Tag: 318863
  - 15
    - Windows NT Index Server I have written a search logic for my website using microsoft indexing service. I designed it on Windows XP. It works great. Then i copied that to our Windows NT webserver and it is giving me the following error Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object /search.asp, line 25 Line 25 is Set QueryObj = Server.CreateObject("IXSSO.Query") Please help. Thanks. Tag: Exporting Results from Webpage to Excel Tag: 318862
  - 16
    - Connecting to SQLEXPRESS 2005 with an ASP web app Hello, I have an ASP web app with an SQL back end. It's currently connecting to an SQL Server 2000 database using an ODBC DSN. I am currently migrating to a new Windows 2003 Server machine and SQL Server 2005 Express. As usual, the app doesn't connect right away, but I've gone through all the new Windows 2003 Server security issues and I'm able to get a normal ASP page to display. I can also connect to the SQLEXPRESS when I use visual studio or MS Access on a remote machine, even using the same ODBC DSN, but for some reason, I get an error when trying to access it though ASP. The error is; Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I thought that sounded like the IUSR_MachineName user not being defined in teh db, but when I got to add that user, there is no IUSR_MachineName account available. Does anyone else have experience with this? Thanks! Tag: Exporting Results from Webpage to Excel Tag: 318854
  - 17
    - Dictionary Issue I'm using a dictionary to record some totals, however, my first attempt failed and I wasnt sure why... snippet from original code: oTotalFilters.Item(rsNetStock.fields("PartNo")) = oTotalFilters.Item(rsNetStock.fields("PartNo") ) + CInt(iNumFilters) After going back to the start, I eventually realised that the dictionary Item property didn't like 'rsNetStock.fields("PartNo")' as a parameter, so I had to use something like the following: sTest = rsNetStock.fields("PartNo") oTotalFilters.Item(sTest) = oTotalFilters.Item(sTest) + CInt(iNumFilters) Am I missing something here? Surely, my original code should have worked? Is this a known bug/feature? Thanks CJM -- cjmnews04@REMOVEMEyahoo.co.uk [remove the obvious bits] Tag: Exporting Results from Webpage to Excel Tag: 318849
  - 18
    - XMLHTTP character issue - converting byte array to string Hi! I'm using Msxml2.ServerXMLHTTP.3.0 to fetch a HTML page on a remote server. The fetched page is then parsed and the information of interest is extracted and send to the client browser. However, the remote server does not specify any character coding in its headers. If using ResponseText property in ServerXMLHTTP, some international characters are not decoded correctly. This is due to ResponseText assuming UTF-8 coding if no character set is specified. My solution is to use the ResponseBody property which returns the web page as an array of unsigned bytes. I then convert the data to a string using the ADODB.Stream method as described here: http://www.motobit.com/tips/detpg_binarytostring/ The string is then parsed and the required information is pulled out. This solution works just fine but I wonder if there is some more efficient (without the need for a byte to string converion) way to solve the problem. BR, Yllar Tag: Exporting Results from Webpage to Excel Tag: 318846
  - 19
    - Cookies problem on Win2003 Eng + IIS 6.0 I have a demo app where cookies does not work. The first page create a cookies. The second read the contet. If I browse the pages via IE6.0 the pages does not work. If I browse the pages via FireFox the pages work fine. ************ SetCookies.asp <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>ARXivar Test - Generazione Cookies</title> </head> <body> <form name="Test" action="./SetCookies.asp" > <strong>Pagina di generazione Cookies</strong><br><br> <input name="GeneraCookies" type="submit" value="Genera Cookies Â»"> </form> <% If Request("GeneraCookies") <> "" Then Response.Cookies("Nome").Path = "/" Response.Cookies("Nome") = "Claudio" Response.Cookies("Nome").Expires = DateAdd("h", 4, now) 'Date + 1 Response.Cookies("Cognome").Path = "/" Response.Cookies("Cognome") = "Maccari" Response.Cookies("Cognome").Expires = DateAdd("h", 4, now) 'Date + 1 Response.Write("Cookies generati") Response.Write("<br><br><a href='./GetCookies.asp'>Clicca qui per leggere il contenuto dei cookies</a>") End If %> </body> </html> ************ GetCookies.asp<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <title>ARXivar Test - Lettura Cookies</title> </head> <body> <strong>Contenuto dei cookies:</strong><br><br> Nome: <%=Request.Cookies("Nome")%> <br> Cognome: <%=Request.Cookies("Cognome")%> </body> </html> Tag: Exporting Results from Webpage to Excel Tag: 318845
  - 20
    - Closing Recordsets/Connections Is it sufficient to Set a Connection or Recordset to Nothing, or ought they specifically be closed first? E.g. Set rs = oConn.Execute(sSQL) 'Do stuff Set rs = Nothing Set oConn = Nothing -- cjmnews04@REMOVEMEyahoo.co.uk [remove the obvious bits] Tag: Exporting Results from Webpage to Excel Tag: 318843
  - 21
    - Scaling with ASP and Server Memory Issues Hi, I am hosting hundreds of websites on a webserver using a combination of sql and asp. SQL is on a different server. The web server is running win 2003 iis 6 with a single processor and 1 GB Ram. All websites are in 1 app pool. I find that i get out of memory errors or no new sessions are created when the virtual bytes for an App pool starts to breach over 1500mb. So i recycle the App pool at a limit of 1500mb. This leads to the app pool recycling 1-2 times a day. Typically the Private Bytes counter is saying 293mb and virtual bytes is 1438mb. I don't know whether this is a leak somewhere in ASP or normal with IIS but the virtual bytes only seems to increase over time and not stablise or go down as i would expect when users visit and leave a website. I have a script that i use to let uses download files from the server. It uses the response.binarywrite method. If i download a large files (i.e. over 100mb) then i see a big jump in the virtual bytes that IIS allocates in the w3wp.exe process. This does not appear to go down after the file has been downloaded although Private Bytes goes up and then down initially. I was thinking that this may be a cause of the problem?! ...or maybe it is typical for these types of large scale ASP applications? Would increasing the main memory RAM to 2GB help in this situation. The main Physical Memory still reports about 300mb free when i get the memory problems? Would it help to split the websites into a couple of different App Pools, then increase the page file size to something larger and hence each App pool gets to use a separate 2GB memory space? Would i benefit from moving to Windows 64bit edition and installing more Ram and having a large Page file to cope with the large Virtual Bytes? Can anyone offer some guidance who have had similar issues with hosting their sites? Help much appreciated. Tag: Exporting Results from Webpage to Excel Tag: 318842
  - 22
    - Displaying a "choose folder" dialog Hi, I'm asking for help because I read dozens of threads on this subject, but I still cannot make it work. I'm developing an ASP script (running on a SBS 2k. I'm a beginner with ASP) to use on our intranet which does searching on our file server using Indexing Services. To let the users specify the scope (from which file-server folder start to search) I need to display on client pc's (Win 2k or Win XP Pro) a "choose folder" dialog. I tried BrowseForFolder method, in lots of different ways, for example (this is a copy and paste from msdn site): ------------------------------------ ssfWINDOWS = 36 set objShell = CreateObject("Shell.Application") set objFolder = objShell.BrowseForFolder(0, "Example", 0, ssfWINDOWS) if (not objFolder is nothing) then Response.write(objfolder) end if set objFolder = nothing set objShell = nothing ------------------------------------ But the result is always the same: the client gets stuck (progress bar running and nothing happens) and after a while the server stops responding to all asp requests. How can I do that (let the user choose a folder on fileserver) using this or another tecnique? Any help is greatly appreciated Thanks in advance Guido Italy Tag: Exporting Results from Webpage to Excel Tag: 318840
  - 23
    - Get Rich Take advantage of a great deal Tag: Exporting Results from Webpage to Excel Tag: 318839
  - 24
    - sending ASP output to a excel file 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 Tag: Exporting Results from Webpage to Excel Tag: 318833
  - 25
    - 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: Exporting Results from Webpage to Excel Tag: 318831
- Next
  - 1
    - 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: Exporting Results from Webpage to Excel Tag: 318829
  - 2
    - 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: Exporting Results from Webpage to Excel Tag: 318828
  - 3
    - 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: Exporting Results from Webpage to Excel Tag: 318823
  - 4
    - 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: Exporting Results from Webpage to Excel Tag: 318822
  - 5
    - 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: Exporting Results from Webpage to Excel Tag: 318820
  - 6
    - 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: Exporting Results from Webpage to Excel Tag: 318815
  - 7
    - 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: Exporting Results from Webpage to Excel Tag: 318814
  - 8
    - 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: Exporting Results from Webpage to Excel Tag: 318812
  - 9
    - 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: Exporting Results from Webpage to Excel Tag: 318800
  - 10
    - 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: Exporting Results from Webpage to Excel Tag: 318790
  - 11
    - 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: Exporting Results from Webpage to Excel Tag: 318785
  - 12
    - 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: Exporting Results from Webpage to Excel Tag: 318781
  - 13
    - 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: Exporting Results from Webpage to Excel Tag: 318777
  - 14
    - 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: Exporting Results from Webpage to Excel Tag: 318775
  - 15
    - 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: Exporting Results from Webpage to Excel Tag: 318767
  - 16
    - 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: Exporting Results from Webpage to Excel Tag: 318766
  - 17
    - 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: Exporting Results from Webpage to Excel Tag: 318762
  - 18
    - 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: Exporting Results from Webpage to Excel Tag: 318757
  - 19
    - 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: Exporting Results from Webpage to Excel Tag: 318755
  - 20
    - 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: Exporting Results from Webpage to Excel Tag: 318754
  - 21
    - 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: Exporting Results from Webpage to Excel Tag: 318753
  - 22
    - 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: Exporting Results from Webpage to Excel Tag: 318750
  - 23
    - 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: Exporting Results from Webpage to Excel Tag: 318749
  - 24
    - 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: Exporting Results from Webpage to Excel Tag: 318744
  - 25
    - 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: Exporting Results from Webpage to Excel Tag: 318743

Hi! I wanted to know if there is any possibilites to export search
results of a particular webpage to excel?

I have a website where in search for a specific criteria. After
selecting the criteria, after i click on search I would be directed to
a page where the results are displayed. Now instead if i want to have
the results exported to excel instead me taken to a results page. Is
this possible?

Can any one help me on this? I dont have any idea on programming like
HTML or Visual Basic, C or C++ anything of this sort. How can i do it
in a simple way where i can unserdtand this?

Please somebody help me in this . I need this very urgently........

Please forward the solution to me at tomslater2003@gamil.com

I would eagerly waiting for your replies folks!!!

Thanks in Advance

Tom

Top