I was thinking of the best way of adding a class of 'featured' (in classic ASP), in this sequence of records from a DB: N,Y,Y,N,N,Y,Y The sequence is: 2 3 6 7 10 11 14 15 18 19... I already have a count (starting from 1 going for each record) Many thanks! ...
I've run into an odd problem with a legacy ASP application that uses Oracle 9i as its database. We recently had the DBA increase the size of a VARCHAR2 field from VARCHAR2(2000) to VARCHAR2(4000). The problem is that a NULL byte (ASCII: 0) is inserted into the 2001 character position in the string even if the string inserted is larger ...
OK, so I have a couple of modules in my application. One is called ProductCatalogue and another is called Contracts. We now have a need for a contract to be associated with a number of products (eg the products which a party to a contract is allowed to order). Within the ProductCatalogue module we have a ProductDAL class which has the fo...
I have a code snippet similar to the one below that I would like to refactor into two different functions each with their own connection (for better maintenance): Dim Conn, Sql, RS Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open ConnString Sql = SELECT * FROM CLIENTS Set RS = Conn.Execute(sql) //'Do something with Cl...
I'm looking for some open source alternative to create reports from classic asp they don't have to be something awfully elaborated, we rather find some simple product that allows us to generate pdf files from a data set. we were thinking about developing some kind of service that took an xml as input and returned a pdf, probably with j...
I'd like to implement something like stackoverflow's login system in classic asp... is it possible? thanks in advance... ...
Hello everyone, Some of my legacy program is using ASP (not ASP.Net), and even if I set long session expire time for example to 20 minutes, sometimes in short time (e.g. in several minutes) I will still notice session expire error box -- "too much idle time, please login again". Any ideas to analalyze further? Not sure whether it is my...
Hello everyone, I need some tutorials or samples which cover the following topics, does anyone have any recommendations? For ASP.Net, how to manage session and especially manage correctly when there is large number of concurrent user requests, access session and various ways to manage session expire; For old ASP, how to manage session...
Hello everyone, My question is about classic ASP, not ASP.Net. I ask expert here since search engine always tell me ASP.Net answers. My confusions are, How to set session expiration time in classic ASP code or through configuration? How to extend session expire time? Is there a session expire event? How to know when session will expir...
We're moving a legacy .ASP application to a new hosting provider that doesn't support Microsoft Index Server, on which one portion of the site depended. The application has a directory tree containing around 10,000 documents (text, MS Word and PDF) whose contents need to be indexed and to be searchable. The application is staying class...
I need to send emails via a background job on a classic-asp app so the user doesn't have to wait for a slow webserver to complete sending the email. I know I can use Ajax to generate two separate requests, but I'd rather not require Javascript. Plus, I suspect there's a better way to pull this off. Ideas? ...
Is there a way to mark classic ASP ASPSESSIONID* cookies as secure? It appears that the ASP ISAPI handler adds that session id cookie after my page is done rendering so putting code at the end of my page to loop through the Response.Cookie collection and mark them as secure doesn't seem to touch the ASPSESSIONID* cookie. Any other way ...
I am new to code and starting with ASP. How do I create a simple message box so I can alert the users on the web page? Thanks Henry ...
I've been stuck with visual studio 2003 for ages because of my need to debug asp classic code... A few years ago I tried to debug classic asp with vs 2005 with no luck, I think there was some dirty hack that was supposed to achieve that "magic", but I couldn't make it work... I wonder if anybody has been luckier than me... Haven't tri...
I was told that using javascript to submit in either asp or asp.net causes a faster submit. Is this true or is there no significant difference? ...
Is anyone familiar with the erorr message "The server has reached the maximum recovery limit for the application during the processing of your request." I'm getting this when running a legacy ASP site on my local machine using IIS 6. The site was working fine for a couple days, but it's been about a week since I last worked on this s...
Is there a SQL library handling simple sql related tasks for ASP classic? What I have in mind is sql to array, multiple insert, input sanitizing etc. Thanks ...
I've used to put a "stop" statement in my VBScript/ASP-Classic code to break into debugger (Microsoft Script Editor, that comes with Microsoft Office). But now it isn't breaking anymore. The "stop" is ignored and nothing happpens. The server-side debugging flag is already enabled in IIS How to solve this? Sample Code, hello.asp st...
I have a problem with classc ASP / VBScript trying to read an UTF-8 encoded XML file with MSXML. The file is encoded correctly, I can see that with all other tools. Constructed XML example: <?xml version="1.0" encoding="UTF-8"?> <itshop> <Product Name="Backup gewünscht" /> </itshop> If I try to do this in ASP... Set fso = Server...
I have a website written in ASP with a mySQL database. ASP uses the ODBC 5.1 driver to connect to the database. Inside the database there is a varchar(8000) column (the length started small, but the application has evolved A LOT since its conception). Anyway, it recently became evident that the varchar column should be changed into a MED...