I come from a mainly PHP background and make good use of the Apache error logs by using the command line. I've recently been handed a large ASP/ASP.NET project that I need to make changes to, where do I find the error logs on a Windows IIS setup so that I may troubleshoot some issues? ...
I'm attempting to check that a file exists before including it with Server.Execute in Classic ASP. While FileExists() returns False, Server.Execute successfully executes the file. Both calls use the exact same file path. Why does this happen and how can I work around it? ...
Assume a typical, database and session driven ASP application developed using best practices just before the first release of .NET. Assign the amount of effort required for seasoned professionals to implement it properly and efficiently to be 1.0. What would you estimate to be the amount of effort required to maintain it using best no...
I have an ASP page which will query records from a DB Table and do some processing and then Render an HTML table in the browser.My table has more than 16000 rows in it. When i am running the prigram with select top 2500 StudId,StudName from StudentsTbl, It is working fine.But when i am Using select "StudId,StudName from StudentsTbl",It ...
I am running a query from ASP using a MySQL database, I want to create a variable (ssResult) based on the result with a person's name (fullname), if the record does not exist I want to assign the text 'N/A' to the variable, code below, I currently use a function getOther for my database connections which passes the column name "fullname"...
I have a loop on page to update an access database that takes 15-20 seconds to complete. I only run it once a month at most but I noticed that every time I run it the web site (IIS 6) simply stops serving pages. After the loop ends, pages begin opening again. Here's my code: For each Email in Emails if Trim(Email) <> "" then ' exec...
I'm trying to migrate a website from Windows 2000 to Win2k3 using the IIS 6 Migration Tool. I'm getting a bunch of 404s on content. A popular theory is that my IWAM account is out of sync with the IIS metabase, and to run synciwam to fix it. However I'm getting this 1B6 error and the only link I haven't chased in google (that's obviou...
I have the following route defined routes.MapRoute( "ItemName", "{controller}/{action}/{projectName}/{name}", new { controller = "Home", action = "Index", name = "", projectName = "" } ); This route actually works, so if I type in the browser /Milestone/Edit/Co-Driver/Featur...
I use an SQL statement to remove records that exist on another database but this takes a very long time. Is there any other alternative to the code below that can be faster? Database is Access. email_DB.mdb is from where I want to remove the email addresses that exist on the other database (table Newsletter_Subscribers) customers.mdb i...
I have a DAL that I want to return an ADODB.recordset when executed from a classic asp. The object is exposed as a com object and I have a complete dal workin but I am not sure how to return an object that is a recordset that .net can use. Any help would be aprcitated. Thank you! --Nicolas ...
Hi! have a problem with classic asp. The encoding gets wrong when I send data with XMLHttp.send. The response is an pdf file, but the “ÆØÅ” gets wrong, the “Ø” is read as “øy” for example. It’s like it’s a converting mistake from UTF-8 to ISO-8859-1, but it should be ISO-8859-1 now. I have <%@CODEPAGE="28591"%> at the top at the page...
Hey guys, I need to create a photo gallery for a website running IIS 4.0 or IIS 5.0 (im not sure which). It needs to display a low resolution version of the gallery to anyone, and it must show both the low and high resolution images for "priviledged" users. So I need access priviledges, photo albums and once the site is complete, the pe...
I'm making some changes to a legacy classic ASP application. I've made the changes locally, and now I want to copy the changed files to the server. At the same time, I need to download the Access database, add some fields to some tables, and upload it again. For this reason, I need to be able to stop visitors from modifying the database ...
For example, how can I run me.test below? myvar = 'test' me.myvar ASP looks for the method "myvar" and doesn't find it. In PHP I could simply say $me->$myvar but ASP's syntax doesn't distinguish between variables and methods. Suggestions? Closely related to this, is there a method_exists function in ASP Classic? Thanks in advance! ...
Is it possible to store encrypted connection string so it can be used from server-side vbscript? Was there an equivalent of web.config in 'the good old days'? ...
Presently, I am working on a project using classic ASP. My development machine is Vista Enterprise. Although Vista does allow you to have multiple Web Sites (not without a workaround in XP), it has removed the SMTP service from IIS. Is there a standard workaround for this issue? As more web developers at my company receive new machine...
For statistical reasons, I want an extensive analysis from a dataset. I already have a function that exports the data to Excel, but I have raw data that way; 500 lines, 35 columns, heaps of text sometimes... Is it possible to include a macro into a function so that the excelfile is readymade to be analyzed? I am using ASP, Javascript,...
i am trying to use an ASP conditional here: if (Request.Cookies("username")) and (Request.Cookies("password")) <> "" Then And i keep getting this error: Type mismatch: '[string: ""]' Any ideas what I am getting that? Thanks, Ryan ...
I created a Web site in VS2008. I'm wondering if I should have created it as a project instead and, if so, can it be converted? Any advantages/disadvantages to either approach? TIA ...
I need to check all of my asp code to prevent SQL injection. Should I check the session object, too? How might a session be hijacked? Thank you!! ...