Hi, Opening an excel spreadsheet with the response object and I am curious to know if there is a way, once all the data has been written to resize/format the columns widths so that all the data fits? Thanks, Ron. ...
i want to make connection of ASP to a database and display the records, add update and delete them all in one coding. Waiting for your kind response. ...
I have a classic ASP page that gets POSTed to. The data gets POSTed as UTF-8 (I can see this in Fiddler). I then open an ADODB connection to a database and store the data in a VARCHAR field. If the data can be represented by 8859-1 (e.g. iñtërnâtiônàlizætiøn) it is stored correctly in the varchar field. If I try strings that can't be...
Hi, I've the following sql query: SQL = "SELECT * FROM Product WHERE ProductCategoryId = " & Request.QueryString("CategoryId") This query tells to get all the products from ONE category. I want the ability so products can be from some categories, and not from one category only. So, I changed the [Product].ProductCategoryId field t...
Hi there, I've got a simple form that enables users to enter a promotional code and email address to be signed up to an email as follows. But at present it doesn't validate the email correctly. There is an include file doreferral.asp that; Checks to see if the code they entered exists in a table of promotional codes and also Checks to ...
With a normal .cs files i can choose "Windows" -> "New Window", to work in the same file in two different locations. I prefer this feature to "Split", because it seems less error phrone in my version of VS 2008 SP1. However when I'm working on markup files (.aspx, .ascx, .asp) the "New Window" is dimmed, does anyone know if the there is ...
hi, I got a asp site hosted in a iis server. In the server there is a virtual folder products and whenever a url like xyz.com/products/abc_11.asp is provided it is forwared to xyz.com/product.asp?id=11 page. I would like to know from where we can change that settings? These settings or tasks can be done from where? Thnx ...
Language is vbscript and classic ASP. The following SQL works when values are hard coded in the sql statement: sql = "UPDATE STORE2_ITEM SET sku = 'abcd' WHERE id = 224 and host_id = 1" What I'm trying to do is add parameters so I replaced the field1 assignment with the following: sql = "UPDATE STORE2_ITEM SET sku = ? WHERE id = 224...
I have an old Classic ASP code such as: <html> <head></head> <body> <form action="test.asp" method="post" name="fname"> <select name="clients" size="3" multiple="multiple"> <option value="5311" selected="selected">5311</option> <option value="9999" selected="selected">9999</option> </select> <input type="submit" value="tes...
Hi guys. Thanks in advance for any help received. I want to allow our client to enter a URL into a text field which then checks whether the URL exists and works. There are 3 possible outcomes I want to check for: A status of 200 - OK, A status of 500 - Server Error, Or a status of 404 - page not found. When executing the following cod...
The website is set up locally on my IIS 5.1 on xp. Application protection is set to low within IIS so the asp is run inside the inetinfo.exe process. I start debugging , attach to the inetinfo.exe process and refresh the page in the browser so the page reloads and reruns the server side code. Non of the breakpoints get hit. There's no w...
I need to read the binary data (a file that is uploaded) from a form that is posted to a classic asp page. I need to do this without using a component. How do you read the binary data for that specific file? Note that there could be other non binary fields that need to be read as well. (updated to clarify) ...
I am developing an application in classical ASP that now requires sef urls. I do not have any asp.net experience but I've heard that ASP.NET+IIS6 provide built-in url rewriting functionality. So before i have someone purchase a url rewriting component for me, I am wondering if it is possible to use the ASP.NET/IIS6 url rewriting function...
I have a classic ASP 2.0 project coming up. I mostly do ASP.NET WebForms and more recently MVC. I did a little bit of ASP many years ago. Do you have any book recommendations? If I find a 3.0 book, would that confuse me too much? Any specific resource on the net for getting up to speed that you recommend? And lastly - how do you fe...
Good morning, everyone. I'm on a short-term contracting gig, trying to patch some vulnerabilities in their legacy code. The application I'm working on is a combination of Classic ASP(VBScript) and .Net 2.0 (C#). One of the tools they have purchased is Fortify 360. Let's say that this is a current classic ASP page in the application...
I have a classic asp webapp that I need to implement url re-writing in. I've used the intelligencia url re-writer in an asp.net application before , so my current trail of thought is to create a new asp.net application, add the url re-writing component to it and then add the classic asp application over the top. It's hosted in shared web...
I am working on improving our glossary functionality in a custom CMS that is running with classic ASP (ASP 3.0) on IIS with VBScript code. I am stumped on a regex challenge I cannot solve. Here is the current code: If InStr(ART_ArticleBody, "href") = False then sql="SELECT URL, Term, RegX FROM GLOSSARYDB;" Set rsGlossary = S...
Using the following code: <% Option Explicit Response.Buffer = True Dim videoVimeo : videoVimeo = "http://vimeo.com/5866977" Dim videoYoutube : videoYoutube = "http://www.youtube.com/watch?v=d8nxjUlbKJA" videoYoutube = Replace(videoYoutube,"http://www.youtube.com/watch?v=","") videoYoutube = "http://gdata.y...
We migrated our old ASP app to ASP.NET and can't seem to figure out the cause of this error. Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; InfoPath.2; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; MS-...
If I shove our intranet app live and let it be compiled on the fly without compiling it beforehand it works fine. If I publish the site by compiling it first using VS's built in publishing feature then every page works fine except for the classic ASP pages. Anyone know why this would happen? We have classic ASP because there's thousand...