Now we know what the actual error is can formulate an answer. Not allowed to load local resource is a Security exception built into Chrome and other modern browsers. The wording may be different but in some way shape or form they all have security exceptions in place to deal with this scenario. In the … Read more
The maxAllowedContentLength controls how much data is allowed to be sent in a response. However you want to control how much can be accepted in a request. This is handled by the maxRequestEntityAllowed attribute of the limits element in the asp section of the config file. An example might look like:- <system.webServer> <asp> <cache diskTemplateCacheDirectory=”%SystemDrive%\inetpub\temp\ASP … Read more
We’ve been moving some Classic ASP code to 64 bit Windows 2008. Here are some things we did or discovered along the way: Start off by hosting the application in a ‘Classic’ pipeline mode application pool. Once things are running just fine you can switch to ‘Integrated Mode’ should you need to leverage the features … Read more
In my code, this is how I get a recordset from a command: Set rs = server.createobject(“ADODB.Recordset”) Set cmd = server.createobject(“ADODB.Command”) cmd.ActiveConnection = Conn //connection object already created cmd.CommandText = “SELECT * FROM lbr_catmaster where catname = ?” cmd.CommandType = adCmdText cmd.CommandTimeout = 900 set prm = cmd.CreateParameter(“@prm”, 200, 1, 200, “development”) cmd.Parameters.Append prm ‘ … Read more
Add a parameter to the SQL: delCmd.CommandText=”DELETE * FROM post WHERE (pos_ID = ?)” delCmd.Parameters.Append delCmd.CreateParameter(“posid”, adInteger, adParamInput) ‘ input parameter delCmd.Parameters(“posid”).Value = postit
Go to control panel click program features turn windows on and off go to internet services under world wide web services check the asp.net and others Click ok and your web sites will load properly.
It’s AddHeader, not AppendHeader. <%@ Language=VBScript %> <% Option Explicit Response.ContentType = “application/vnd.ms-excel” Response.AddHeader “Content-Disposition”, “attachment; filename=excelTest.xls” %> <table> <tr> <td>Test</td> </tr> </table> Update: I’ve written a blog post about how to generate Excel files in ASP Classic. It contains a rather useful piece of code to generate both xls and csv files.
long time since I’ve done that but we used an upload without third party components, just two vbscript classes (solution credit goes to Lewis Moten). It looks like you can still find this “Lewis Moten solution” in the wild If you include the clsUpload file, further upload process is as simple as: Dim objUpload Dim … Read more
Stored Procedures and/or prepared statements: https://stackoverflow.com/questions/1973/what-is-the-best-way-to-avoid-sql-injection-attacks Can I protect against SQL Injection by escaping single-quote and surrounding user input with single-quotes? Catching SQL Injection and other Malicious Web Requests With Access DB, you can still do it, but if you’re already worried about SQL Injection, I think you need to get off Access anyway. Here’s … Read more
You can do this using the WinHttpRequest object <% Dim http: Set http = Server.CreateObject(“WinHttp.WinHttpRequest.5.1”) Dim url: url = “https://www.instamojo.com/api/1.1/payment-requests/” Dim data: data = “allow_repeated_payments=False&amount=2500&buyer_name=John+Doe&purpose=FIFA+16&redirect_url=http%3A%2F%2Fwww.example.com%2Fredirect%2F&phone=9999999999&send_email=True&webhook=http%3A%2F%2Fwww.example.com%2Fwebhook%2F&send_sms=True&email=foo%40example.com” With http Call .Open(“POST”, url, False) Call .SetRequestHeader(“Content-Type”, “application/x-www-form-urlencoded”) Call .SetRequestHeader(“X-Api-Key”, “yourvalue”) Call .SetRequestHeader(“X-Auth-Token”, “yourvalue”) Call .Send(data) End With If Left(http.Status, 1) = 2 Then ‘Request succeeded with a HTTP … Read more