"The first is a task to load an Excel spreadsheet into a SQL Server table. We’ve found this to be a fair way to manage code tables. They’re easy to edit and print out for review. They don’t handle the foreign key checking until we load them in but that’s been a fair trade-off for their ease of use.
The second task imports an image file into SQL Server. It’s basically a mirror image of TEXTCOPY.EXE except that it’s a NAnt task and the trust connection works.
The last task is an updated SQL task from NAntContrib. This version adds back proper column formatting for result sets. They should come out nice and lined up. We have SELECT statements in our build that we wanted to see in a readable format.
I’m considering writing a task that will execute a series of SQL files against SQL Server to create stored procedures. The key being that it will sequence them properly. I’ve got a rough draft working but it’s not very fast at this point. It will also process the command files that Visual Studio generates."
You can filter for a valid URL format using a regular expression, as the following:
^(?:http(?:s)*|ftp)://[a-zA-Z0-9\.\-]+(?:\:\d{1,5})?(?:[A-Za-z0-9\.\;\:\@\&\=\+\$\,\?\-/]|%u[0-9A-Fa-f]{4}|%[0-9A-Fa-f]{2})*$
I found the original regexp at msdn but I’ve extended it with one more character: "-" in the "virtual dir" section and have made the first group shorter.
Advanced CSS Layouts: Step by Step
The Challenge: Replicate WebRef’s front page using CSS. The Solution: CSS and lots of iterations.
Advanced CSS Layouts: Step by Step - WebReference.com
The Regulator is an advanced, free regular expressions testing and learning tool written by Roy Osherove. It allows you to build and verify a regular expression against any text input, file or web, and displays matching, splitting or replacement results within an easy to understand, hierarchical tree.
The Regulator - Get Serious About Regular Expressions
Control.Tabs : Unobtrusive CSS Tabs for Prototype
"Control.Tabs is a JavaScript library for creating accessible, flexible & unobtrusive tabbed interfaces in your applications or pages. It uses anchors and element ids to function, so browsers that do not support JavaScript will still be able to navigate through your tabs.
Requirenments
This script uses the Prototype javascript framework. You must include version 1.5 in your pages before including this script. This library is known to work in recent versions of all major browsers (IE 6/7,FireFox,Safari,Opera)."
Control.Tabs : Unobtrusive CSS Tabs for Prototype
"In this article I’ll go through the creation of a custom navigation bar with some cute Javascript effects that will certainly impress your friends. Thanks to the great Mootools library, this beauty is contained in 1.5kb. Not only that, but it’s also cross browser (tested on Internet Explorer 6/7, Firefox and Safari) and accessible!"
Devthought - Guillermo Rauch’s Blog » CSS+Javascript power. Fancy menu
