I have tried to implement different caching-implementations in a classic ASP site in order to offload the database during heavy traffic. My approach was this: Create a global HashTable object in global.asa where I later on store jscript-objects within <object id="SIZE_LIST" progid="System.Collections.HashTable" runat="Server" scope="A...
Hey, been looking for a while but I can't seem to find any info on how to handle date in classic asp. For now, I need a way to calculate the number of days passed in the current year. I was thinking about a simple function that would take the current date, then make another date with (day = 1, month = 1, year(now)). And finally get the...
I have a client who is incapable of formatting spreadsheets properly. I've asked them 10 times over to follow a sensible guideline (As in FORMAT THE COLUMNS WITH THE CORRECT DATATYPE) but in their lack of intelligence or professionalism or both, they just can't /won't do it. I have an ODBC connection set up for the spreadsheets and pull...
So I have a situation where I need to pass some parameters on url. In order to not have id=1 on the url, I added a simple encryption method to obfuscate the values. This has worked fine within the .Net land. Now however, I need to direct from a classic asp page to this .net page that is expecting the parameters to be encrypted. I rea...
We are having issues with IIS6 slowdowns when using more than 1.2GB of RAM in a single worker and would like to use more workers. However looks like ASP sessions are made by worker and when the browser accesses some page through another worker it losts the ASP session. Do you have some tips on how to solve this problem? We are consider...
I have Googled ASP Classic implementations of the natural sort algorithm to no avail. Best I was able to find was from Dave Koelle, which was from a question on SO. Issue is that since I need to implement this algorithm in ASP Classic, I don't have access to certain functions such as Collections.sort(your list, new AlphanumComparator())...
Hello, I am using the JSON2 script in an asp page to parse JSON post data. After parsing the data, I have an object in VBScript that allows for notations such as: jsonData.key I wish to parse through all the keys, however, I have no knowledge of the key names. How would I go about doing this? Example JSON: { "dbtable":"TABLE1", "dbco...
I am having an issue related to executing a .Net dll from a classic asp application on a 64 Bit Windows Server 2008 server running IIS7. The situation is as follows: I have written a .Net C# assembly to perform some encryption tasks. This assembly has been made available to the classic ASP environment via inheriting from ServicedCompo...
Hi there, I have a MYSQL database which needs to be accessed by both PHP and MySQL scripts, this works fine in most cases, but some "special" characters e.g. double quotes, apostrophes don't display correctly in the ASP scripts. E.g the MySQL database is from a Drupal installation and contains a table with a field containing the text...
I'm trying to make a connection a sql 2000 db. Mixed mode is switched on and i can connect via query analyser to all users needed, however when i try and make a connection use ado it gives me this error: Login failed for user 'username'. Reason: Not associated with a trusted SQL Server connection. I have no idea why this is hap...
Hi, A classic page consists of 4 frameset. if all 4 frameset is inactive then timeout to login page.How to set timeout for classic asp page with frameset. ...
I've begun using ASPUnit to unit test my classic ASP code. This is all good and I'm happy. The only problem is with the error messages it displays when a test generates a runtime error. For example, if I've not defined a variable somewhere in my function I get the error: Microsoft VBScript runtime error (500): Variable is undefined W...
Hi all, Having an issue with type conversion in ASP classic. heres my code: Set trainingCost = Server.CreateObject("ADODB.Recordset") strSQL3 = "SELECT cost1 FROM tblMain WHERE (Booked = 'Booked') AND (Paid IS NULL) AND (PaidDate BETWEEN '01/04/" & startyear & "' AND '31/03/" & endyear & "')" trainingCost.Open strSQL3, Connecti...
Hello, I'm running Classic ASP on Windows 2008 Server x64 in 64bit mode. ADODB is running fine in 64bit with classic ASP. I have a problem with mine .NET COM DLL. I have created a .NET COM DLL with such code as an sample: using System.Runtime.InteropServices; namespace TestNamespace { [Guid("C446E97E-B415-4677-B99E-9644657FC98"), ...
In my stats page, I show number of active members with the following asp code. <% SQL = "SELECT COUNT(MEMBERID) AS TOTALMEMBERS" SQL = SQL & " FROM MEMBERS" SQL = SQL & " WHERE ACTIVE = 1" Set objCountMembers = objConn.Execute(SQL) %> We currently have <%=objCountMembers("TOTALMEMBERS")%> members. At this website, http:/...
I have simple registration form. Once all information entered, user click submit button and all information sent to default.cs.asp?Process=Add2Member. Everything works. Now, I am trying to implement it into ajax Jquery so that user will stay on same page. I looked at sample codes to do this. I am confused at one point. As I understand, w...
How do you calculate a date value in a stored procedure? This: CStr(DateAdd("m", -6, Date)) Is the line in the original code and I am wondering if rather than pass the value to the stored procedure if I can calculate that value in the stored procedure but not sure how to do it? ...
I am using Crystal Report 9.0 (Can't upgrade due to some constraints) My application is in classic ASP using ADO My application will retrieve XML data from a Web Service exposed by a service provider and i need to generate a Report using this XML data. Is there any way to do so? Thx in Advance ...
I'm not a strong ASP Classic developer, but I am tasked with supporting this application at work, well I've been trying to convert an RSS feed date to a short date format. And I cannot seem to find a solution. I have this format: Wed, 10 Jun 2009 12:46:13 +0000 and I need to get it into this format: 06/10/2009 So far I have been t...
Setup: I'm opening a new window via js that is a classic asp page with one form (yes, classic asp, I know). That form posts to a processing page where I Response.Write() some inline js to manipulate form elements on the parent page like so. .Write ("<script language=""javascript"">" & vbcrlf) .Write ("var stopButton = opener.docum...