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 [...]
Tagged as:
iTunes,
itunestuesday,
music,
playlists,
sql
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 [...]
Tagged as:
code,
database,
Programming,
query,
sql
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 [...]
Tagged as:
code,
database,
mysql,
sql
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 …
Tagged as:
code,
sql
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 [...]
Tagged as:
code,
football,
Programming,
sql
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. [...]
Tagged as:
code,
databases,
football,
sql
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 [...]
Tagged as:
code,
development,
Programming,
sql