Hi, I have a classic ASP page with some code to check if an email exists in the table as follows; <% '' //Check the submitted email against existing ones in the database set CmdCheckEmail = server.CreateObject("ADODB.Command") CmdCheckEmail.ActiveConnection = MM_dbconn_STRING CmdCheckEmail.CommandText = "SELECT COUNT(Re...
I'm looking to encrypt a string in VBScript, and decrypt it in PHP. I have full control over the VBScript/ASP Classic environment, but zero control over my PHP environment. Given this, what sort of encryption could I use that would be adequate enough to secure a string? Apologies for the vagueness of the question, but I do not know wh...
Although I develop all of my company’s web-sites in .net, all of my personal sites are still in "Classic ASP". I'm always being pressured to move away from it... but it works! Why change? ...
Created a stored procedure in SQL 9 (2005) and have since upgraded to SQL 10 (2008). Since then, the following stored procedure has stopped working and thrown up the above error: ALTER PROCEDURE [dbo].[GetModifiedPages] @vPortalUID nvarchar(32) = '' AS BEGIN -- Convert GUID to UI DECLARE @nPortalUID AS uniqueidentifier ...
I'm working on a list of reasons for my team to move from webforms to MVC and I thought a good place to start was showing the "why we should migrate" with a set of things both classic asp and webforms have in common. Such as: Spagetti Code (violation of SRP) Classic ASP - each .asp file felt like a big ball of mud Webforms - this big b...
Hi, I have a classic asp page which has, encapsulated within it in an iframe, is a .net ajax control. This all works fine. However, what I need to do is if a button is clicked in the .net control I need a session variable on my classic asp page to be updated. So I guess, simply put, how do I pass a variable from a .net page to a clas...
I have an asp page that saves a file to disk. Currently it works locally, but I need to save the file to a share and I get permission denied. I had assumed I could just set the app pool to the user that has access to the folder, but it doesn't seem to work. How do you make classic asp run as a specific user? ...
Here's my situation - I've had an ASP.NET application running in production for a long time now (Framework 2.0) and recently migrated from one root directory to another by switching the app's home path in IIS. Everything is running just fine, except any classic .asp scripts. When you hit them with a browser, they start to download like...
Hi there, I'm creating a simple form that takes a referal code and email address, stores the email address and then sends an email. The form has some script that checks if the email address already exists in the table and also looks up another table to check to see if the referral code that they are entering exists in the other table. ...
I'm using the following query to return all records where at least 2 conditions match (provided by Quassnoi). SELECT * FROM ( SELECT ContentID FROM ( SELECT ContentID FROM VWTenantPropertiesResults WHERE ContentStreet = 'Holderness Road' UNION ...
So far i have this being called on keypress. function chkenter() { e = event.keyCode; if (e == 13) { event.keyCode = 9; return false; } } but even though i set the keycode to 9 it doesn't tab over to the next control. How can i accomplish this? I'm working in Asp Classic. What I ultimately want is for the focus to m...
according to http://msdn.microsoft.com/en-us/library/ms524620.aspx you should use server.createObject If you are already familiar with VBScript or JScript, note that you do not use the scripting language's function for creating a new object instance (CreateObject in VBScript or New in JScript). You must use the ASP Server.CreateObj...
I need to get a Date from an SQL Server Database (SQL Server 2000), the date is stored as such: 2009-09-30 00:00:00.000 I want to pass this date into a Classic ASP function to use this date in the Database somewhere else, however when I get the date, it converts in my ASP code to a locale-dependant version, such as: 30/09/2009 I ju...
I have a client that is running a classic asp site on IIS7. In order to see any errors from the classic asp pages, I modified the IIS7 Error Pages to point 500 and 500.100 errors to a special classic asp page that finds the last error and then appropriately logs it for the future (pretty much what Elmah does for asp.net). What we are s...
I am working on a tool that accepts an html string, downloads any images found in the code and replaces the image sources with the new local urls. When an image source redirects to another url, I get an access denied error on the request for it: msxml3.dll error '80070005' Access is denied. (i.e. Original URL is: http://ads.cpafuel....
I'm looking at a product that was coded in a mix of .NET and ASP Classic. I'm wondering if it's possible to get this running in Linux? I've heard of Mono (which can supposedly run .NET on Linux) and Sun Java Web Server (which can supposedly run ASP Classic on Linux). Are there any other technologies that you would recommend? Also, are t...
Hi, I desperately need help with this one. I have a classic ASP website in IIS 5, where I need to stream pdf to users. I am using ADODB.Stream to generate chunks of binary data and using response.BinaryWrite to stream it to client. Now problem is that there is a known feature in IE which sets the Response CacheControl header to "no-cach...
Hi, This is a bit of code in one of the pages I am reviewing and trying to update. What I am trying to do is swap the inline query for stored procedures. This is the bit of code: numOfDelRec = 1 Do While (numOfDelRec > 0) cm.CommandText = "DELETE Folder WHERE FolderID IN (SELECT ch.FolderID FROM Folder ch LEFT JOIN Folder p...
PHP provides associative arrays but there is no such thing in classical asp. I am looking for a class or function that allows me to create and traverse a hierarchy similar to this: United States Washington Electric City Banks Lake Lake Chelan Wapato Point Gig Harbour Mexico Nayarit Aticama Asia India ...
I'm working with some legacy spaghetti code that processes some hairy EDI. Most of the code is indecipherable and has no indentation or comments or even good variable names but there's one line that gives me trouble when I remove the On Error Resume Next statement which causes the script to always timeout. If UBound(arylin) >= 1 Then ...