Posts tagged as:

sql

iTunes Playlist Options Improvement

Tuesday April 3, 2007

The feature I’d most like to see added to iTunes “smart playlist” building is the ability to exclude songs based on metadata. I like to listen to music that I haven’t heard in a long time and / or that I haven’t heard very often. The only problem is that when I choose to select [...]

{ 0 comments }

LIMIT and OFFSET in MS SQL Server

Friday September 22, 2006

How to Hack MySQL Paging Functionality into Microsoft SQL Server Web developers using PHP and MySQL have a crucial piece of functionality that classic ASP developers working with Microsoft SQL Server don’t. It’s pagination. Using MySQL’s LIMIT and OFFSET commands you can very easily add pagination to recordsets that you want to display on web [...]

{ 5 comments }

MySQL Triggers Tutorial

Tuesday September 19, 2006

Jon is one of my developers at work. He recently started a WordPress blog called Rusty Razor Blade. I’m guessing that most of what he’ll be posting is going to be fairly technical stuff about MySQL, LAMP, AJAX, and JSON. So far his first really interesting post is a MySQL Triggers Tutorial. It’s actually a [...]

{ 1 comment }

SQL

Tuesday October 16, 2001

If any of my beloved readers are SQL whizzes, I have a little problem posted on my development blog. I will love you forever if you can give me any ideas …

{ 2 comments }

SQL

Tuesday October 16, 2001

Help! If anyone can help me out with this I will severely owe you one. I have this SQL query that I need to return just one more field, and I can’t figure out how to do it. (The query is in the extended text for this entry; click on the icon or the comments [...]

{ 2 comments }

bDeleteWeek

Friday October 12, 2001

I’m almost ready for a beta release of PoolPlayer. I need to get a better name for it, I know. Right now I’m working on letting the user (or the app) delete a week from the database regardless of whether there are any games associated with that week. It’s not as easy as it sounds. [...]

{ 0 comments }

Beginning

Wednesday October 10, 2001

This is going to be a blog for information related to my many projects. Mostly I will probably write about programs I am writing and web development work I am doing, and I imagine this will mainly be a personal blog. I doubt many people will be interested in learning about listview columnheaders or SQL [...]

{ 1 comment }