Code Talking

I was playing with the database yesterday, and decided that some of my auto-incremented values (id numbers for particular tables, specifically Movable Type's PluginData) were simply getting too high….

I needed to concatenate some information in a table, and I wanted to do it with a SQL query, but I could not for the life of me figure out how to combine the two strings (one a constant, the other a field name) in order to produce…

I was redesigning the plugin pages to get the documentation into a useful format, and found that I needed an anchor tag so that the reader could jump to a particular place in the document….

The other day, I had the need to attach to a Microsoft SQL Server database that a customer had sent on CD. Not a backup mind you, just the raw files. Took me a little while to figure out this puzzler, so I figured I'd post it here…

I'm sure you've seen those images that display a changing value in them, something that you have to read and then type into a field so that you verify that you're human (the assumption being that a machine couldn't read the image to extract the text). They're everywhere….

I'm sure everyone else already knows this stuff, but since I use my blog for reference when I don't feel like trying to look things up, I'm going to do another piece on SQL. Specifically, another piece on SQL subselects….

During some conversations today, I found out that neither my experimental site nor my regular site was rendering in Mozilla. The culprit is not a new one. I had added some formatting to the page and forgot to close my tags….

I often have to change the location of web pages, and try to make sure nothing breaks in the process. Ideally, you won't see any changes at all, and clients won't lose any functionality whatsoever….

I had to use more SQL than usual the other day. It had been a while since I had much call to use SQL in my job for something more than a simple query, however. I needed to use it to update some records in a file as…

I came across a post by someone who found something I wrote to be useful. That's cool. I'm glad someone is reading. One thing that this post reminded me of, that I didn't mention previously, is the MIME type of the document being served. In the case of…