TroyGrosfield.com TroyGrosfield.com

Archive for August, 2010

Headline

Find All Non-Distinct Rows Using SQL

Author
by Troy Grosfield
Date
August 21st, 2010
Category
Developer
Story

I want to be able to find all non-distinct rows based on multiple columns, but not using all columns, and see how many occurrences there are. I would like to find all rows for people that have the same first_name, last_name, and middle_initial. Data Table Name: my_table id first_name last_name middle_initial 1 Billy Bob J … read more

Tags
Comments
No Comments »
Headline

MediaWiki as an Online Notebook

Author
by Troy Grosfield
Date
August 19th, 2010
Category
Developer
Story

The people who made MediaWiki come to life really deserve a standing ovation.  They provide a great tool for people to download and use for free.  When I setup this site one of the first things I got working was my own wiki.  I felt like I was getting ideas all the time and when … read more

Tags
Comments
No Comments »
Headline

How I Passed the SCJP Exam

Author
by Troy Grosfield
Date
August 18th, 2010
Category
Developer
Story

One of my goals once I started writing code in Java was to one day pass the Sun Certified Java Programmer (SCJP) exam.  So on May 12th, 2010 I did just that.   I guess I like to be challenged and the further I was removed from school the more I become interested in studying … read more

Tags
Comments
1 Comment »
Headline

GoDaddy, Windows, Linux, and .htaccess

Author
by Troy Grosfield
Date
August 13th, 2010
Category
Developer
Story

Problem I was having a lot of difficulties getting my .htaccess file to work on GoDaddy.  Everything was running fine locally, but when I FTP’d all my content to the GoDaddy servers I was seeing a 500 Error message and couldn’t figure out why.  The guilty culprit was my .htaccess file.  I work on a … read more

Tags
Comments
2 Comments »