Posts

Showing posts from November, 2009
Is Classic ASP Getting Dead?? Author: Mohita Damini Bhargava To generate dynamically generated web pages, Active server pages were used. But with the development of technology now ASP technology is now not anymore been used by many web development company. With the help of ASP interestingly one can put together HTML pages, COM components and create, develop and modify powerful web based applications easily. One can easily group related groups functions and data attributes. Some of the web designers are still using application because of cheap hosting. But majority of them have started using ASP.net. Classic ASP development has still not lost its importance. Many web development companies still provide with ASP development services. They find it to be a regular program with lightweight development. It is already installed, runs instantly, and there is no configuration required and is available on any PC. Further at this time of recession, many companies prefer Classic ASP development b

IIS: Creating Multiple Web Sites within IIS on Windows 2000 and Windows XP Professional

Image
Original source : http://www.xoc.net/works/tips/multiple-iis-sites-professional.asp In the server versions of Windows, you can have multiple versions of web sites installed into IIS and running simultaneously. You can install and run more than one web site within IIS in the professional version of Windows XP or Windows 2000. You just have to pull a trick to modify the IIS metabase to that it is aware of the additional sites. The user interface does not support creating more than one web site. Also, you still will not be able to have more than one site running at the same time. To create the second web site: * Create a command prompt window. * Type "cd \Inetpub\Adminscripts" and press enter. * Find out what the highest numbered site you currently have is. You can do that by typing adsutil.vbs ENUM /P W3SVC If you have never done this process before, the highest numbered site should be 1. * Add one to the highest numbered site. Then run this command: adsutil.vbs

SQL:Finding Duplicates with SQL

Do you want to find duplicates in a table. Suppose you want to find all email addresses in a users table that exist more than once: SELECT email, COUNT(email) AS NumOftimes FROM users GROUP BY email HAVING ( COUNT(email) > 1 ) you can see more information about removing duplicate rows from this microsoft article How to remove duplicate rows from a table in SQL Server

Excel : Joining Two Text Columns

Nice article : http://www.mrexcel.com/tip074.shtml =PROPER(A2&" "&B2)