Skip to content

SiteKickr Web Development

search
search
Jun06Server / Performance

Mod Rewrite w/ HTTP Authentication

Putting a site behind HTTP Authentication is a pretty simple task, but when your site is being served by another application server – let's say…

Jun05June 5, 2011Brick Wall, SQL / Database

MySQL AsText returns BLOB

I've seen many posts regarding this issue, but most point to a bug in MySQL 5.0, resolved in 5.1. This may be true, although I'm…

Jun04June 4, 2011Brick Wall, SQL / Database

MySQL GeomFromText Polygon returns null

Trying to add a POLYGON using GeomFromText? I don't know about you, but although it's documented as being able to "construct a geometry value of…

Jun04ColdFusion

ColdFusion function / CFC – dynamic arguments

Passing a dynamic number of arguments to a ColdFusion function is possible, but the method isn't obvious. ColdFusion provides the argumentCollection attribute, which assists the…

Jun03June 3, 2011Brick Wall

Constant Contact REST API – New Subscriber

This is not a typical post, but I just had to share as it took me a good afternoon of trial error to figure out…

Jun01JavaScript

Labels activate checkboxes / radio buttons with jQuery

The small jQuery snippet below will make those plain old labels that follow checkboxes and radio buttons active. That is, they will activate/deactivate the checkboxes…

May27SQL / Database

MySQL full text search w/ relevance percentage

We're using an FAQ table below, to demonstrate how to return a result set that includes the keyword relevance as a percentage of the maximum…

May26July 27, 2011Brick Wall, JavaScript

JavaScript Date object – 0 offset Month

I find the Javascript Date constructor to be a little non-intuitive, primarily because the Month is 0 offset, but the day is not. The script…

May25Server / Performance, SQL / Database

Make those SQL queries chunky

I'm by no means saying that my tests below are evidence enough to support the case for "chunky" SQL queries. By chunky, I mean queries…

May19May 19, 2011JavaScript, One-Liner

Labelling form fields without using labels – Method II

Here's a handy method I came up with to "move" labels inside form fields, to save real estate. It also degrades gracefully if the user…

Posts navigation

Previous 1 … 26 27 28 … 33 Next
© 2025 SiteKickr