2005

You are browsing the archive for 2005.

Impetus for an OO Backend

After a long, multi-faceted discussions on CFCDev a few weeks ago,
one of the participants contact me off-list wondering about a sample
app that illustrated some of the concepts I'd mentioned in the
discussion. I don't have one, and while I could make one up, the
implementation is the easy part. It's the reasoning behind doing
things a certain way [...]

cvs2svn Rules!

I've been moving all my stuff from CVS to Subversion over the past
few months.  Some of the stuff (like server config files) I've
just been moving the top revision across since the history is of little
concern.  The larger projects, however, I've migrated the whole
history with the fantastic cvs2svn
tool.  It somehow reads your CVS directory, figures out [...]

How Nested Sets Work

I got an email question today about how nested sets work, after the
developer started using my TreeManager component.  I figured that
was a good topic for a blog post, so here it is.

Nested sets operate based on two fields, rpos and lpos (right
position and left position).  They're calculated by doing a depth
first traversal of the tree; [...]

Neuromancer Extension

I've used Neuromancer
(from Rob Rohan)
on several projects, and I finally decided to implement form posts, in
addition to the raw posts that it already supports.  Like it
should be with a well designed library, adding the new functionality
was a snap.  I forwarded the changes to Rob, and I'd expect them
to be in the next Neuromancer release, which [...]

Weird MySQL INSERT Quirk

I wrote an INSERT query today (for the first time in months), and
missed a comma between two of my values.  I also missed one of the
columns in the column list, so there while there was an extra value,
two of them weren't separated by a comma.  Something like this (though with CFQUERYPARAM, of course):
INSERT INTO mytable
    [...]

Welcome Emery Isaac!

On Friday morning, my wife gave birth to our second child, Emery Isaac Boisvert. 
8 pounds, 1 ounce, 20.5 inches long, and with thick black hair. 
Mom and baby are doing well, as came home from the hospital this
afternoon.

Connector/J 3 Gotcha

As is pretty common knowledge, CFMX 6, CFMX 7, and BD all ship with
JDBC drivers for MySQL 3.x.  There have been several posts (here's
one from Steven Erat)
about installing MySQL Connector/J 3.x, which is the driver for MySQL
4.x.  In particular, it supports the new authentication scheme
that was introduced in the 4 series.
I've done this on several
servers [...]

Movable Type Spam Killer

Last week sometime, fed up with the unending comment spam (thousands per
week), I had an epiphany.  Spammers aren't slowed down by changing
the action of the comment submission form, so it's obvious that they're
parsing that out of the markup for the form.  By simply removing
that from the form, theoretically the comment spam should stop.  Could it [...]

CFMX At Last

I finally got my copy of CF7 Standard a couple days ago, and have
just started the process of rebuilding with CF rather than JSP. 
There's a lot of stuff to rebuild, not all of it trivial, but I'm
hoping to be mostly done this week.
Hardly even worth posting, I
know, but it'd been over two weeks since my [...]

And Again! (ComboBox)

Based on some user feedback and some more of my own use, I've made a
couple more little tweaks to the script.  In a nutshell, orm
submission blocking now works in a far less intrusive way, hitting TAB
will select the active item before changing focus, and ESCAPE will
close the dropdown if it's open.
I've also been looking for [...]