SQL insert into database with apostrophe

Replace isn’t the way to go here, you are already using a ADODB.Command object so why not use a parameterised query. Try this; As you haven’t provided information on your field types I can only speculate so instead I’ve added [datatype] and [size] placeholders for you to replace with ADO data type constants. A good … Read more

I have already enabled classic asp support on IIS for windows 7, and configured IIS web for classic asp,Yet .asp page is not being displayed? [closed]

It possible that you haven’t got Classic ASP support installed in IIS. To do this in Windows 7 follow the steps below; How to enable Classic ASP support on IIS for Windows 7 Installing Classic ASP support Goto Control Panel -> Programs and Features Select from the left navigation bar From the Windows Features dialog … Read more

Compare values of two arrays – classic asp

This function: Function diffArray( aA, aB ) ‘ !! http://en.wikipedia.org/wiki/Union_%28set_theory%29 ‘ The union of two sets A and B is the collection of points which are in A or ‘ in B (or in both) Dim dicU : Set dicU = CreateObject( “Scripting.Dictionary” ) ‘ !! http://en.wikipedia.org/wiki/Intersection_%28set_theory%29 ‘ the intersection of two sets A and … Read more

Providing authentication info via msxml2.ServerXMLHTTP

Try http.Open “GET”, vurl, False, “yourusername”, “yourpassword” I don’t know if this works on justgiving, but it does with the Bing API Also, this question may be relevant XmlHttp Request Basic Authentication Issue Edit – using Response.ContentType and Msxml2.ServerXMLHTTP.6.0 vurl = “https://api.justgiving.com/API_KEY/v1/account” Set http = Server.CreateObject(“msxml2.ServerXMLHTTP.6.0”) http.Open “GET”, vurl, False, “username”, “pwd” http.setTimeouts 5000, 5000, … Read more

Classic ASP: Multiple ASPSESSIONID in cookies

I was able to remove those cookies with Javascript. Just add next script to the end of login page. This will remove all “ASPSESSIONIDXXXXXXX” cookies before user will login to website: <script type=”text/javascript”> //Clear any session cookies (function(){ var cookiesArr = document.cookie.split(“; “); for (var i = 0; i < cookiesArr.length; i++) { var cItem … Read more

ADODB.Parameters error ‘800a0e7c’ Parameter object is improperly defined. Inconsistent or incomplete information was provided

Common occurrence is likely you do not have adVarChar defined, so the CreateParameter() method is “improperly defined”. This is just an example of one of the many named constants found in the ADODB Library. A messy approach to dealing with this is to just define the value yourself something like; Const adVarChar = 200 The … Read more

Pure ASP upload with image detection

Here is a single Class which handles file upload plus image detection. Use case will come below. Save this as-is, preferably as a new file, with .asp extension e.g. ShadowUpload.asp Note: if you want to allow uploading images larger than 200kb, take a look in the answer to Request.BinaryRead(Request.TotalBytes) throws error for large files. (Failing … Read more

What are alternatives to generic collections for COM Interop?

After some more research and trial-and-error, I think I found a solution by using System.Collections.ArrayList. However, this does not work with getting a value by index. To do so, I created a new class ComArrayList that inherits from ArrayList and adds new methods GetByIndex and SetByIndex. COM Interop compatible collection: public class ComArrayList : System.Collections.ArrayList … Read more