I spent all day yesterday working on bttlxeForum, an ASP forum package, in order to get it to properly support MS-SQL.

They say they support it, they even give you a configuration option for 'drop in support'..... but they lie, oh they lie!

Though the authors have clearly written it with the thought of using SQL down the road, they haven't really thought too much about it. All the queries are written for MS Access, whose syntax is just different enough to make it incompatible with MS SQL.

One of the peskiest differences is the lack of a boolean data type in MS SQL. True, there's a bit data type, but that returns either 0 or 1, not TRUE or FALSE. Since much of the code is based on TRUE or FALSE in bttlxeForum, it meant a lot of reworking.

Of course, I now know almost every line of code in that damned thing. :)