In the last SQL post, I showed you SUBSTRING, and how you could use it to locate the area code in an un-formatted phone number. The problem was the field we were working from was full of malformed numbers. Today, we’ll start on cleaning up the numbers. But first, I need to include my standard…
Author: slowder
Work, work, then some more work.
After the last post, I worked on getting a heating system put into the addition. As of last night, that’s done. It only cost 3 grand. (that’s more than i used to make in 7 weeks) I am ever so thankful to have a job that pays me a good wage. If i was still…
Project 1
I’ve been back from Christmas for nearly a week now. I’ve accomplished much more than I thought I was going to be able to this week. I have been able to create my XML parser that will allow myself and others to develop forms more rapidly. Basically the way it will work is, you will…
The Incredibles
I went to see The Incredibles yesterday. It was a great flick. It has a very unique animation style, within moments, you’ll notice it. The have gone out of their way to make it feel like an old school comic book. In fact many of the heroes are based on characters you know. For example,…
Changes to ToyboxCreations!
I hope you all can appreciate the new face lift I’ve given the site. This version is built from scratch in PHP with a MySQL backend. The template is based on a demo site I found online. If you are interested, check out google images for “web site templates”, there are thousands of amazing templates…
String Manipulation — SUBSTRING
Sooner or later in SQL, you’re going to be asked to change how some text is formatted. Making changes to text is pretty straightforward. First, you need to know that when you’re manipulating text (in SQL it’s stored as a VARCHAR or NVARCHAR), you’re manipulating a string. If you think of the string to the…
My Milage Widget
After getting back from a long vacation weekend filled with plenty of driving, I started thinking. How many miles have I driven. Not just today, not just this week, but since I started driving. I started thinking back to my truck. I got it with 1.7 miles on the odometer. So I started thinking about…
Sample Databases Available for Download
Whenever someone starts learning Microsoft SQL Server they always ask for a demo database they can connect to. If you don’t have access to one already there is hope. Search on amazon and see how cheaply you can find a copy of Microsoft SQL Server 2000 Developer edition. I’ve found them as low as $50. …
Hello World!
I’d like to introduce you to my new site. ToyboxCreations.net. I wanted .com, but it is currently being squatted on. But that’s besides the point. This site will be my virtual home base. I’ll keep track of all my projects, my SQL training, photography, etc. Hopefully this site will introduce me to more people than…
Development for GoRowan.com
(imported from twistedCircle.com) Recently I completed work on a network of sites: GoRowan.com, High-Rock.com, and spencer-inn.com. On these three sites, I developed a Content Management System in PHP and MySQL. I developed a company index based loosely around the Yahoo category system. And finally, I built several banner ads for advertisers on the sites. By building…