asp-classic

COM Interop (how to pass an array to the com) via classic ASP

I need to create a com object for my classic asp, since i can create a .net Assembly and have it 'Interop' with com, so i proceeded to create a .net Assembly like this:- using System; using System.Collections.Generic; using System.Runtime.InteropServices; using System.Linq; using System.Text; using System.Data.SqlClient; using System.Da...

SQL Server vs MySQL - SQL Injection Vulnerabilities in Classic ASP

Recently one of our client's websites fell prey to a SQL Injection attack due to a failure to sanitize query string parameters provided to the page. The vulnerable code has since been identified and is being corrected, but it got me wondering about some of the differences between how MySQL and SQL Server process multi-query strings. The...

Create graph in ASP based on the values from database

hi there.. does anyone know how to create a bar/pie graph based on the value from database in ASP? For example, i would to create a graph based on the number of people who went for vacation in certain state..I would like to retrieve the value directly from database..need help..thanks.. ...

Request.Form for a textarea returns bad data

This is a very weird error ocurring only with Firefox 3.5. I have tested it for IE, Safari and Chrome revealing no errors. I'm using my localhost IIS 5.1 and ye old asp. I've been able to reduce the scope to this... I have a textarea in a form, filled with 4000 characters, for example. < textarea name="obs" id="obs" cols="75" rows="1...

AspAllowOutOfProcComponents error: many solutions, one programmer and no fix

Hello, I have been trying to work on integrating a NewsLetter for a companies local intranet and I keep running into the same error that everyone seems to be getting. I am running this on IIS 5.1 and on error exists at Server.CreateObject(ADODB.Connection), also the purpose of the ASP code is to read an Excel file Error Type: Server ob...

How to trace all ActiveX/COM objects life cyle in an ASP application?

Hi all, I'm fighting to find a memory leak in an old ASP application. I'm not the designer of this application (please kill me if one day I produce such an horror) moreover I'm far from being an ASP/JavaScript guru. I'm supposing that some ActiveX/COM objects are not freed correctly but it's huge job to trace all allocations. Some of t...

Delete a chosen line from a text file using ASP?

I have a loop that finds duplicate lines in a .ini file. I can happily find the duplicate lines, and write new lines to the file using FileSystemObject, however... I can't seem to find out how to delete the duplicate lines. What I want to do is delete the lines by line number as I have identified the relevant line number already. Is th...

Find redundant pages, files, stored procedures in legacy applications

I have several horrors of old ASP web applications. Does anyone have any easy ways to find what scripts, pages, and stored procedures are no longer needed? (besides the stuff in "old___code", "delete_this", etc ;-) ...

Classic ASP: frequently getting just part of the page

I'm using windows 2003, running some classic ASP pages. frequently client get just a part of the page, looks like the page is not fully generated for some reason (refreshing does solve it). I checked for a clue in event viewer, but there is nothing there. Any idea what can cause this behavior? ...

"View in Browser" and "Browse with..." context menu entry on classic .asp files in VS?

hi, some bad legancy web application projects still have classic asp files. these project consist of 95% of classic .asp files and the rest only of asp.net (.aspx). if you right click on an .aspx file in the solution explorer of VS you can choose "view in browser" and "browse with...". however if i right click on an classic .asp file...

Classic ASP Webserver On Windows 7

I need to run some classic ASP locally before deployment to a legacy web application. To make things worse, my current workstation is a Windows 7 Ultimate x64 with VS2008 environment. What are my options for testing/debugging? One option I tried was Baby ASP Server, but I am actually running an ASP script I know should fail (on Create...

vbscript traverse through xml node- dynamic if else, node count detection

myXML= "<?xml version=1.0 encoding=iso-8859-1 ?>" & vbcrlf & _ "<shippingRates code=fedex >" & vbcrlf & _ "<errorMsg>" & vbcrlf & _ "Sorry, no rates returned." & vbcrlf & _ "</errorMsg>" & vbcrlf & _ "</shippingRates>" & vbcrlf & _ "<shippingRates code=CUSTOM >" & vbcrlf & _ "<shippingRat...

Tracking 'Useful Links'

Hi there, I'm building a Useful Links database for a Classic ASP site. The table has the usual ID, Title, URL, Description, DateAdded and DateModified. I also want to record in the table each time a link has been clicked or viewed. I wondered if anyone had built such a system or knows of a way that I could accomplish this? Thank you. ...

classic asp cint

I'm new to classic asp, all my experience is in c# .net and cold fusion and php. Anyway, this site I'm working on has this code all over the place If (CInt("0" & myVar) > 0) Then myNewCar = CInt("0" & myVar) End If What I don't understand is why the "0" is append to the var in the cint() input? Am I just missing something? Is it ...

Automatically convert VBScript properties to VB.NET

Hello Migrating an old ASP site to .NET, and there's a load of VBScript we're porting to VB.NET. Getting into trouble with the old property syntax, does anyone know of a tool (or other such magic) that could do this automatically? Googled, but no joy. Thanks Duncan EDIT: VB Script properties look like this: Public Property Get AgeC...

Count certain record in database

hi there, How can I count the number of certain records in database using classic asp? For example, I want to count how many record are there for Car..I'm using ms access. need help. thank you. ...

can we program classic ASP in VSTS 2008

Hello everyone, If I have .Net 3.5 + VSTS 2008 + IIS 7.0 on my machine, could I develop and debug some classic ASP code (in VB Script). If I can, any reference guide to setup development environment for both IIS 7.0 and VSTS 2008? thanks in advance, George ...

generating Excel file error

Hello everyone, I am using the following code in classic ASP to generate Excel file, the code is simple and it works. I run the code under IIS 7.0 on Windows Vista x86. Two issues, there is a weird warning box, here is the screen snapshot http://i27.tinypic.com/2n81udw.jpg All cells' background is white, no border of each cell sho...

Response.Flush - OnFlush event in classic ASP?

Hi, I need to rewrite the domain names on web pages served by a DLL that I have no way to change. I thought if there were events like OnFlush before Response.Flush occurs on the page I could do it all before the page is displayed. Is there a way to do this in ASP? Thanks for your help. P.S.: Something like Script_OnFlush in this APACH...

How to create target directory structure for copy files in classic ASP?

Hi, I want to copy a file to target directory. It is simple with copyFile command of File system object. But I need some enhancement like, If target directory is not exist then it'll create target directory and then copy a file. Can you help me achieve it? Let me know if there are other ways to do same. Thanks. Solution: 'Create f...