asp-classic

Excel formatting question, default line color

Hi, What is the default line setting in an Excel spreadsheet? You know, the line that goes around the cell? Color? Line thickness? Transparency? I am creating a workbook using asp and html and want to format the lines so that it looks like the default settings. Many thanks, R ...

Pass mvc form post data to an asp page.

We are doing a old section reskin which is written in classical asp and it is being remade in Asp.net MVC. Content of some of the pages just needs to be pulled into a new layout. So I have written a helper method that basically reads asp file and renders contents in the current view. public static string readHtmlPage(string url) ...

Can asp.net HttpModule forward requests to the asp.dll?

Hi All, What I'm trying to acheive:- Intercept requests for .asp files using an asp.net application then re-write the url to something search engine friendly then pass the request onto the asp.dll to handle the request. How Im trying to acheive it:- I'm trying to get intelligencia url re-writing working for a classic asp application...

strange Encoding issue

i have a contact form sending itself to me by email using ASP classic, CDO.message. thing is, that it has hebrew characters and i encoded it UTF-8. but when sending to my email i get ??????? instead of hebrew. i copied the exact files handeling this form to another FTP i have, and BOOM! it works fine.. what is the cause? ...

Json "Parser Error" from server to client.

Hi, I use an asp (classic) utility file to create json objects from an SQL database, see: http://code.google.com/p/aspjson/ here is what I get from the server side: {"results":[{"Opt_Name":"BARR","Opt_FirstName":"TomTest","Comp_Name":"My_Company"}]} Which is valid json, at least valid for jsonlint. BUT this never triggers my callba...

Changing the page layout using Office Web Components

I am using Office Web components to fill an Excel template with values. The template is in Excel xml format, containing all relevant fields and layout options including the page layout, landscape in this case. I'm filling this template with some real fields using the code below. Set objSpreadsheet = Server.CreateObject("OWC11.Spreadshee...

Server Error : The server closed the connection while reading the response.

I have windows xp and iis installed , when I want to access localhost to view asp pages , I get the following error : Server Error The following error occurred: [code=SERVER_RESPONSE_CLOSE] The server closed the connection while reading the response. Contact your system administrator. Please contact the administrator thank you . ...

Classic ASP "ExecuteGlobal" statement acting differently on two servers

I have a strange problem that I don't really know how to handle. In addition to developing a new ASP.NET site, I have to support the old "Classic ASP" site. It's written in VBScript with a batch of Javascript functions as well. Many of the Javascript functions are in 'include files'. Debugging these hasn't been a problem once I learn...

Classic ASP Parameters passing nulls (or empty parms) and ordering

I'm using classic ASP and trying to create parameters for a stored procedure call for a procedure that has optional (=NULL) parameters. One of the parameters, @maxrows, is required. When I try to pass via the following call: With objCommand .ActiveConnection = oConn .CommandText = "usp_client_onsite_search" .CommandType = adCmdStoredPr...

Connection string error

Having a problem with IIS on Windows Server 2003 (using a classic ASP web application) The database server (SQL Server 2005) is on the same machine. I create a recordset, and set its activeconnection as follows: Dim RS Set RS = Server.CreateObject("ADODB.Recordset") RS.ActiveConnection = "Provider=SQLOLEDB;Network Library=DBMSSOCN;Data...

Dictionary/Client VS Application Variables

Hi i got a question about my server performance ... i got a classic asp cms hosting ~250 websites, for each website we build a Classic ASP dictionary using set dict = CreateObject("Scripting.Dictionary") dict.add "test1","Value Test1" dict.add "test2","Value Test2" dict.add "test3","Value Test3" that dictionary is then loaded on eve...

Help me for create a xml, based on Room Count of hotel

Help me for create a xml, based on Room Count of hotel For example: I have 5 Rooms: Room1, Room2, Room3, Room4 and Room5. In Room1: 2 Adults, 1 Child, Age 6 In Room2: 1 Adult, 0 Child In Room3: 2 Adults, 2 Child, Age 6, Age 7 In Room4: 1 Adult, 0 Child In Room5: 2 Adult, 1 Child, Age 6 If Child is 0 and Adult count comes same ( her...

Implications in using VB.NET method DateAndTime.DateDiff with C#

Hi all, I'm building a new ASP.NET web application based on a legacy one (Classic ASP). The people, who build this code 4, 5 years ago, used a lot of VBScript functions like DateDiff. I'm currently working on a simulator that does a lot of calculations with dates. And I'm getting a annoying difference between these dates because I don'...

In classic ASP, is there a way to handle errors at application level?

In classic ASP, is there a way to handle error at application level? Is there guidelines for handling error / exceptions in classic ASP 3 ? The Server.GetLastError() not a lot to work with... I am looking for something like the Application_Error() found in an ASP.Net Global.asax. Any equivalent in a global.asa ? Classes to intelligen...

ASP Form Variables

I am looking for a secure way to do accept a username and password in a form, and after they successfully log in, I want to use a piece of that information for a subsequent query. <form METHOD="POST" action="2.asp"> <blockquote> <table> <tr> <th ALIGN="right" nowrap><em><font size="2">User ID:</font></em></th> <td><...

Using javascript substring() to create a read more link

Hi there, I'm developing a Classic ASP page that pulls some content from a database and creates a Read more link after the first 100 characters as follows; <div class="contentdetail"><%=StripHTML(rspropertyresults.Fields.Item("ContentDetails").Value)%></div> <script type="text/javascript"> $(function() { var cutoff = 200; ...

What happens when NOT closing recordsets in classic asp?

In legacy applications at work, i see not closed recordsets scattered on lots of pages. What consequences does this have? Does the connection close automatically? Are resources released at the end of every request? Update: Another question related to this problem i think txn! ...

Best way to manage connection strings in a project containing both Classic ASP and ASP.Net 1.1 code?

I have a project that I have inherited that is primarily a Classic ASP application; however, intermixed in the the application are a handful of ASP.net pages. Some of the ASP.net pages are 1.1 and do not use a code behind model. The classic ASP pages have a number of /include directories where there's a file for database connections. ...

HTTP Request Object and processing local requests

I have a web application that uses the CDO Message object to email reports. For example: Dim objCDO Set objCDO = Server.CreateObject("CDO.Message") objCDO.CreateMHTMLBody "http://server/report.asp" The problem is that when it makes its request to IIS, it does not inherit the ASP session identity of the logged in user i.e. the session...

What's the relation between classic asp and a IIS application pool?

Does asp run in the IIS application pool for which the website is configured? Or is the application pool only for asp.NET applications. How do those two relate to each other, what do i need to know to understand who's doing what and where are they doing it... ...