asp-classic

export crystal report into PDF in classic ASP

I have third party website which is using object of WebReportBroker and used CRviewer to view crystal report.I want to save this report in physical location in PDF format.Help me to how to do it? ...

Creating Batch update in Classic ASP and ADO

I have an ASP form that brings in a number of records that I want to modify and then update. Currently, the updates take place as one-at-a-time update through DLL's that simply build a SQL statement and call the database for each record. Now, I need to place a check in the SQL to make sure that I'm not getting rid of the last type of l...

Classic ASP Auto Suggest Like Google

While working on a project i came across a functionality in which i need to implement auto suggest textbox using classic asp. I did it and it works fine. I'm using XMLHttp Request object to pick the database column values when user enter something in textbox. Everything works fine. But if the table have too many rows (37,000+) in it, t...

Classic asp persist custom classes in session

Is it possible to persist a class in session that I define in VBScript in classic asp: <script runat=server language=vbscript> Class clsCourse Private Sub Class_Initialize ' Statements go here. End Sub End Class dim oCourse set oCourse=new clsCourse </script> How would I persist oCourse in session and recover it from session? I ...

MSXML2.ServerXMLHTTP with SSL3?

Using VBScript, want to talk to a HTTPS website but it fails with: The client and server cannot communicate, because they do not possess a common algorithm Found out this is because it needs to use SSL3. How can I tell it to use SSL v3? Thanks ...

Add 'last' class to records from query

Hi there, I'm using a parametized query to get records that will display as a grid of products on a page. My design has 4 products listed in each row, but i'd like to apply a class to every 4th item, so that I can clear any margins/padding. Here is my current code; <% Set conn = Server.CreateObject("ADODB.connection") ...

classic asp sessions (time-out set in IIS) lasting longer than it should

Hi, I am finding that my classic asp sessions (time-out set in IIS) are lasting longer than they should. If you set the IIS session timeout to 1 minute, i'd expect them to last 1 minute between the last http request of a page and if a new http request comes in > 1 min after, as new session created. I have a page setup that has a JavaS...

Is there a way to debug HTTP 500 Error Over ASP Classic Page?

My website is working fine but few pages are giving this odd error. You can check out here http://thevnsf.org/admin/EditStaff.asp ...

How to tell the difference between ASP and ASP.NET code/website files

I'm jumping into updating an ASP(.NET) website coming from a PHP background and am trying to get my bearings. I think it's ASP (not .NET) since the code is not compiled and it seems to be using ADODB, but I'm really quite clueless. So, how can I tell if the code I'm working with is ASP or ASP.NET? Bonus points if you can tell me how to ...

From PHP (LAMP) to Classic ASP, how to setup a dev environment

I'm jumping into updating a Classic ASP web app coming from a PHP background and am trying to get my bearings. I'm used to just installing something like MAMP, messing the httpd.conf a bit and getting on my way. Ideally, I would like to be able to edit this app completely locally on my Macbook Pro running OS X Leopard so that I'm not me...

CLASSIC ASP QUERY

do until rs1.eof elseif year(tDate) = year(now) then elseif rs1("leavetype") = 1 and (rs1("statusLev1") = "z" and rs1("statusLev2") = "z") then childcare = childcare + rs1("totaldays") elseif rs1("leavetype") = 28 and (rs1("statusLev1") = "P" and rs1("statusLev2") = "P") then %> <script>alert("You are...

Any Classic ASP gotchas from Win2k3/IIS6 down to Win2k/IIS5?

I've got the undoubted joy of having to put a very simple 'classic ASP' internal website on to a Windows 2000 server (which I believe will be running IIS 5). I won't have access to this server until the weekend, and all of the original development & testing of this website was all done on IIS 6/Windows 2003. The website is incredibly ...

global.asa dosent work on iis 6

Hi, I copy a few web sites from iis 5 to iis 6, I declare an app pool for those sites , I copy also the global.asa file to the root folder but the iis ignore the global.asa functions . Any idea? ...

VBScript and numbers larger than Long

Is there a way to work with numbers that are larger than VBScript's Long? Long's range is -2,147,483,648 to 2,147,483,647 and we need to work in an asp page with larger numbers. We cannot work with strings and we need to sum it and do some other calculations. ...

How do I run a parameterized SQL query in classic ASP? And is it secure?

I'm about to have to deal with some SQL code in classic ASP VBScript. I have two questions. First, in .net, I'm used to using the System.Data.SqlClient namespace objects to perform queries. For example: Dim conn as New SqlConnection("Data Source=MyServer;uid=myUid;pwd=myPwd;Initial Catalog=myDataBase;" Dim cmd as New SqlCommand("Se...

IIS 5.1 on XP Classic ASP appears to be in single threaded mode

I do'nt have script debugging enabled on IIS 5.1 on XP, but the Classic ASP applications appear to be running in single threaded mode. One page must finish loading before another can load. Any ideas??? ...

ASP --> ASP.Net: Refactoring steps

I have a legacy ASP application which - at some point soon - needs to be migrated to ASP.Net 2.0 (to be compatible with other apps that are also in 2.0). Are there best practices for this sort of thing i.e. is it possible/advisable as a first step to transfer the current unholy mix of html, vbscript and javascript en masse to aspx page...

StoredProcedures ... "The Request Properties cannot be supported"

Hi all, I have a problem with SQL Server 2005 and classic asp and recordsets. Whenever I modify a Table, it seems to affect all the stored procedures dependent on that table and when I call the (select) sproc, the error is: "The Request Properties cannot be supported" But when I run the sproc in query analyzer window, there are no ...

validity of classic ASP include pattern

Hello, Here is a pattern I am thinking about in ASP : Imagine you have a file main.asp that contains <!--#include file="1.asp"--> code of 1.asp ...my code... Do you think it is valid to refactor this as main.asp Dim defined_1_asp = false <!--#include file="1.asp"--> 1.asp if (not defined_1_asp) then defined_1_asp = tr...

ADODB.Connection error '800a0e7a'

Anyone know what does that error mean? I have just copied my ASP classic website files to my Windows 7 x64 machine. And I have installed IIS 7.0. I am trying to access the website and it gives me that error. ...