We’ve all seen it. Some 3rd party database you’ve inherited from someone else was simply never designed with scalability and portability in mind. There’s no hope to change it, as it will break the original design and thus the original application that it is supporting.
It’s easy to grab the date from a field in a database so long as you saved a timestamp field along with your data row. However, there are often times in developing stored procedures and advanced queries where one needs to look up events in the future, or past based on some other reference point… Continue reading Quick SQL Date Functions and Queries
Tonight I was working on an RSS package for a client of mine. Having dealt with RSS feeds in the past, I figured it wouldn’t be a big deal. However, my experience with them has always been on the ‘receiving’ end of it, imploding out the ‘s and making sense of the xml. For the… Continue reading RFC-32 Date Formatting with Classic ASP
I recently wrote an article on BloggerSkills.com on how to better utilize the Lightbox functions within a WordPress blog. No more manually typing rel=”lightbox” attributes! read more | digg story
Sometimes, all you want to do is a simple ORDER BY, but it just doesn’t work. SQL has some quirks when trying to sort “text” numbers, especially when they are decimal numbers. Consider the following Database table, myTable: Code varchar(5) | Descr varchar(100) ——————|——————– 1 | Code 1 1.1 | Code 1 point 1 1.2… Continue reading Problematic SQL Sorting
Yesterday, May 15th 2006, Yahoo! Inc. released a link in their blog to a preview page of their new layout which perhaps may set the standard in pushing away from developing for 800×600 resolution. It will not fit without horizontal scrollbars at 800×600 resolution, but fits the screen nice and neatly with just a small… Continue reading Is it Time to Abandon 800×600?
Hell must have frozen over sometime in the past month or so. With the newest rendition of the Microsoft.com Home Page, the markup actually passes W3 validation for HTML 4.01 transitional. Further noteworthy, is that there are accessibility features in place, such as “Skip to main content” links for CSS disabled browsers. Unfortunately, there are… Continue reading Microsoft.com Goes Valid
This is quite possibly one of the biggest debates in the pre-sale sections of both official sites, vBulletin.com and invisionboard.com. Before choosing a software, potential customers want to hear from people who use it. The biggest problem is asking which one is better on the respective sites, is like asking the CEO of Coca Cola… Continue reading vBulletin VS. Invision Power Board
There arenâ€™t many tutorials on the web for Classic ASP and AJAX interfaces. Classic ASP is just about fazed out at most companies, but there are still plenty of legacy applications that use it. There is a lot of confusion about AJAX and what it is. Mainly, it is a client-side application that sends data… Continue reading Classic ASP and AJAX