asp-classic

Classic ASP e-mail verify that e-mail exists...

Here's something I couldn't find an answer to. Say you have a form and on that form you have a field for someone to enter their e-mail address. Now after the e-mail address is entered, is there a way after using RegEx to verify that it follows the syntax of an e-mail address, to then verify that it is a valid e-mail that can receive mess...

On error Resume next in ASP

HI, I want to catch SQL error in my Page.If I use "On error Resume next" ,If page having some other error it wont thrown .Can u plese give solution for handling error ...

How to format a datetime with minimal separators and timezone in VBScript?

I have the following code in C#: DateTime dt = GetDateTime(); string formatted = dt.ToString("yyyyMMddTHHmmsszz"); which returns a date in the following format: 20100806T112917+01 I would like to be able to get the same results in VBScript (for a legacy ASP application). It is especially important that I get the UTC offset informat...

ASP Classic - Recordset Object vs. Command Object

Hi I am using ASP Classic and SQL Server 2000 to create dynamic websites. I am a bit confused about when to use a recordset object and when to use a command object when querying the database. I was told that if the stored procedure would be returning records from a SELCT statement then I should use a recordset, however if I am up upda...

Can't connect to database, error 80040e21. Impossible to debug.

I have a simple file that tries to connect to a database- <% Set RSDiscounts = Server.CreateObject("ADODB.Recordset") RSDiscounts.ActiveConnection = "Data Source=serverName;Initial Catalog=dbName.dbo;Integrated Security=True" %> When I run it, I get- error '80040e21' /filename.asp, line 3 Searching for the error code doesn't help...

Regex pattern match small issue with brackets in pattern match

Hi There Someone helped me earlier with this regex: checkxls = checkxls.match(/'[^']*'(?:, '[^']*'){13};/g); The purpose is to capture a exact patter like this '', '', '', '', '', '', '', '', '', '', '', '', '', ''; Now I want to do the same thing but just with a pattern like this ('.*?', '.*?', '.*?', '.*?', '.*?', '.*?', '.*?',...

Is there a (free) way to unpack .zip files without the use of a .DLL in ASP Classic

I would like to be able to unpack a .zip file using ASP classic. I have had a bit of a poke around on google for something that will allow me to do this, and there seems to be a fair amount libraries out there. However all of these as far as I can tell require me to install a third party DLL. The server that this script will be deploy...

Simple encrypt/decrypt functions in Classic ASP

Are there any simple encrypt/decrypt functions in Classic ASP? The data that needs to be encrypted and decrypted is not super sensitive. So simple functions would do. ...

Debugging Classic ASP in Visual Studio 2010

I have read this question and this page linked to in the question, as well as dozens of other articles about debugging asp classic with VS but it's still not clicking for me. I am using VS 2010. The files I want to debug live on a remote server. I have installed the Remote Debugger on the server. I opened the website and attached to the...

Key Management - Classic ASP - encrypt/decrypt

Here is my scenario: I have file called gen.asp, when ever someone requests this file It needs to generate a encrypted-random-key and pass it back. (Gen.asp can not store the key it generated, anywhere no session, no database) I have a different file called GenValid.asp, in this file I need to verify weather the encrypted-random-key is...

SQL Server 2000 Output Parameters

I have created a stored procedure in SQL Server 2000 and within the stored procedure I have created a number of variables that I want to return to the asp classic script. I have tried declaring the variable like this: DECLARE @output int OUTPUT But SQL Server then says that I cannot declare an output variable that way. So instead, I...

Is it better to log to file or database?

We're still using old Classic ASP and are wanting to log whenever a user does something in our application. We'll write a generic subroutine to take in the details we want to log. Should we log this to say a txt file using FileSystemObject or log it to a MSSQL database? If the database, should we add a new table to the one existing dat...

Moving from Classic ASP to ASP.net

Hi all! I've come from a Classic ASP background, done it for years and years and moving to .net has been way overdue, so I've started to learn .net. It's very different to say the least! It's structured a lot differently, and seems to work a lot differently, it's a huge leap upwards. However, it is appearing to me to be more and more...

Get root directory in ASP Classic application

I have several relative paths in my ASP Classic application. I'd like to get a reference to the root directory of my particular application (since the root of the server is something different) for the purpose of setting paths. Is there a way to do this? ...

how to insert values tosqlserver 2000 via asp by connection string

..................... ...

Consume a .NET Assembly from a classic ASP page.

Hi, I have an old .net 2005 web site that has some asp pages and having object reference problem accessing .net dll. The maintenance task was handed down to me and the original developer is nowhere to be found :( I started at .Net already so I don't really master handling this dll hell kind of problem. On the arrow below is where I'm...

Sorting an Array of times in Classic ASP

Hi, had to return to a old app I had build in Classic ASP and do a few changes, however one bit is stumping me. I have a string such as: theTimings = "12:00-14:30,18:00-22:30,07:30-10:30" I am turning this into an Array using timingsArray=Split(theTimings,",") However I need to sort this Array so the earliest times appear fir...

Server.Execute not executing code in classic ASP

I'm trying to make use of constants declared in one ASP file in another file. Here's a basic code overview of what I am trying to accomplish.. FileA.asp const tr__first_name = "First Name" const tr__last_name = "Last Name" const tr__english = "English" FileB.asp Server.Execute("FileA.asp") Response.Write(eval("tr__first_name") ...

Classic ASP: querystring handler

I've done this a long time ago, now I can't find the function. It shouldn't be too complicated, but I wonder if there's any news on this before I go and do it again... Take this: www.example.com?query=whatever&page=1 Now imagine I press button to page 2, it will become: www.example.com?query=whatever&page=2 Always keeping the rest...

Creating PDF from RPT file in Classic ASP

I have a windows 2008 application server that hosts a web application built in classic asp. i have a crystal report server which is a windows 2008 server. both are on the same network. I want to create pdf file from rpt file in the application server. Is there a way to do this without installing crystal reports on the application server...