- Posted by justin on October 26, 2004
Script to generate insert statements from SQL using nothing more than a stored procedure. http://vyaskn.tripod.com/code.htm#inserts
Script to give you N biggest tables in your database http://vyaskn.tripod.com/sp_show_biggest_tables.htm
- Posted by justin on October 17, 2004
We ran across a problem with VS 2002 and IIS 6 where it would not find the web directories or tell you that the directory location did not match the URL. Below is how to fix this problem.
The problem may be that Internet Information Server 6.0 blocks all
extensions that are not explicityly mapped (for security purposes), while
VS.Net tests whether the URL and UNC path match by writing a file with the
".tmp" extension to the server and then requesting it back via an http
call. Since Internet Information Server 6.0 blocks .tmp file the call fails
with a 404 error.
Workaround
1. Launch the Internet Information Services MMC.
2. Right click on your web site and click properties.
3. In the 'HTTP Headers' tab click 'MIME Types...' button.
4. Add a new MIME type by clicking 'New...' button.
5. In the 'Extension' edit control type (without the quotes) '.tmp'.
6. In the 'MIME type' edit control type (without the quotes) 'temp'.
The above steps will allow .tmp files to be served up by IIS. On a
development machine where web project are created this is usually not an
security concern. However if you have .tmp which contain sensitive data
which you do not want exposed, you will have to reverse the above 6 steps.
If the mime entry for .tmp file is deleted after creating the project you
will receive a http 404 error when you try to reopen the project. So you
will have add .tmp mime type before you open the project and remove it
after opening the project.
- Posted by justin on October 5, 2004
Talking with D1 he mentioned that blogs are kind of like a "geek version of a diary." It was funny but once you think about it, it is so true.
- Posted by justin on October 5, 2004
I ran across this in one of the blogs I monitor and thought it was pretty funny. If you go to http://www.applelegal.com in IE you get the following message:
Warning- Internet Explorer Detected!
AppleLegal has detected that you are using a browser that was created by Microsoft. If you are using a Microsoft-based browser, we are sorry that your browser has been updated many times over the last 2 years, but still doesn't support some CSS and PNG files that are used on Apple Legal. This is because Microsoft refuses to update their browser to support important internet standards.
We request that you find an alternative browser to view our site correctly (of which there are many). If you have any more questions on why AppleLegal doesn't work with IE, you may email us at team@applelegal.com.
Safari (Mac): Download Here
Camino (Mac): Download Here
OmniWeb (Mac): Download Here
Firebird (Win/Mac): Download Here
Mozilla (Win/Mac): Download Here
Opera (Win/Mac): Download here
If you still would like to view our site incorrectly: Click Here
- Posted by justin on October 1, 2004
Looks like a pretty good article about using HTTP modules and handlers to add error logging to your asp.net applications.
http://msdn.microsoft.com/asp.net/default.aspx?pull=/library/en-us/dnaspp/html/elmah.asp