Paging at the database in MSSQL

Lacking limit and offset, modern MSSQL can still perform acceptable paging calls, it's just a bit more syntax to make it work. Here's a basic syntax run down you can start with:


Drupal block.tpl.php Advanced

Depending on how advanced your client wants the blocks on their site themed, the standard drupal block.tpl.php won't cut it. That's the end result for most of us of course. But in my case, I have somewhat given up on the base tpl ever working. Therefore I worked up a slightly more advanced version. It's designed to allow for highly styled borders: 4 corners, and expandable sides.

Override Drupal theme_function from another module

I wanted to change the related content output html rendered by CCK for my site today. I did a bit of googling, and all of the suggestions pointed to making new field or node specific tpl.php files. While that would work for this site, it's a terrible answer once you start considering using multiple templates. Having dealt with maintenance of what should be exactly the same file / function in different themes being out of sync, I went looking for a more permanent answer. While this might not be the Drupal specific answer, it's very efficient for what I need.

File Styling

I ran across a fantastic resource for file icons today, thought I'd share it for you all. Andreas Gohr has fine archive of 16x16 .png images to use with your file styling. He's got some nice generic types, as well a fairly extensive collection of specific formats.


Subscribe to Fragmented Thought RSS