This user-defined function (only available in SQL 2000 and above) is part of a larger project I'm working on. PARSENAME in SQL Server is my new favorite function.. Thanks to Jeff Smith for the heads up. 1CREATE FUNCTION [dbo].[IPtoNumeric] (@strIP varchar(255)) 2RETURNS bigint 3AS 4BEGIN 5 DECLARE @intIPNum bigint 6 IF …

Wow, have ya'll seen the new Google Groups interface? It's sex on legs. Now if only they'd put back "Groups" in the main Google navigation text.

Update: If you are an iTunes user that needs VBScript, this page won't help you. Please visit the following two sites for two different solutions: Apple Docs and KeathMilligan.net. This is an old script I dug up which I call "fileFetch". It's a script that downloads a binary file using XMLHTTP and saves it …

I've used CDONTS for years, even though it hasn't been included in a Windows Server release since NT4. Anytime I needed to send mail, I'd copy over CDONTS.dll, register it then use my old CDONTS code. Not sure why I resisted it for so long.. I think the weird Configuration Fields were too odd to accept. But I've …

This is some super old code but I used it recently and figured I'd archive it on this site for my future reference. The sample code below aims to allow authenticated users to download files which are not available via direct download (ie. files within the web root). The script accomplishes this by doing the following: …

I keep track of all hits to my website RealCajunRecipes.com in a SQL table called hitcounter which has columns for the user's IP, browser, referring URL and the date. Recently, I saw a surge in traffic and wanted to know which domains were sending the traffic our way. After getting tired of issuing ad-hoc queries that …

Recently, a user trying to login to OWA encountered the following error: HTTP 403.1 Forbidden: Execute Access Forbidden You have attempted to execute a CGI, ISAPI, or other executable program from a directory that does not allow programs to be executed. Another network administrator noticed that the URL was strange …

I've got two 10 page papers to write by Wednesday so I figure there's no better time to write a post about the things you can find in my Swiss Synergy backpack. This backpack is rather large but its size often comes in handy (grocery store trips and school finals come to mind). I used to value micro sized bags but …

In Dwight D. Eisenhower's Farewell Address to the Nation, he pleaded with the American people to "avoid the impulse to live only for today, plundering, for our own ease and convenience, the precious resources of tomorrow." He also acknowledged the existence and influence of a militaryindustrial complex on …

If you haven't been to meebo.com (archived), you probably haven't needed to chat from a location that restricts chat program installs ;) Meebo.com is super slick; with nothing more than a browser, you can access your favorite chat network. The unencrypted meebo.com site does encrypt your password but stops there. By …