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
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
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
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
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
@KekuSemau is correct but let me a suggest a more efficient and manageable approach then using the adovbs constants file. METADATA allows you to define a reference to the DLLs constants even if your using Late Binding as is the case in a Classic ASP environment. It’s probably worth mentioning that you can add METADATA … Read more
Try adding oHttp.setOption 2, 13056
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
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
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