http://www.psykel.com/blog/index.cfm psyBlog - random ramblings of a web developer en-us Mon, 08 Jun 2026 21:54:32-0700 Tue, 07 Aug 2007 13:54:00-0700 BlogCFC http://blogs.law.harvard.edu/tech/rss erikv@psykel.com erikv@psykel.com http://www.psykel.com/blog/index.cfm/2007/8/7/Chrome-CSS-Drop-Down-Menu-Offsets-with-Centered-Pages I decided to try Chrome CSS Menu on a project I'm working on. While I'd love a pure CSS solution, I don't have time to roll my own, and everything I saw relies on fixed width parent elements. The Chrome menu is very easy to drop into your existing ... web Tue, 07 Aug 2007 13:54:00-0700 http://www.psykel.com/blog/index.cfm/2007/8/7/Chrome-CSS-Drop-Down-Menu-Offsets-with-Centered-Pages http://www.psykel.com/blog/index.cfm/2007/8/2/fckeditor-and-AJAX fckeditor is cool, and so is AJAX. I've never used them together until today, and it's quite simple. One gotcha that was killing me - if/when you use Javascript to send the contents of the fckeditor window, keep these few things in mind (for us... web Thu, 02 Aug 2007 00:22:00-0700 http://www.psykel.com/blog/index.cfm/2007/8/2/fckeditor-and-AJAX http://www.psykel.com/blog/index.cfm/2007/7/11/Nested-CASE-in-SQL There's nothing especially difficult about nesting CASE statements in SQL, but I guess it could be confusing sometimes. Here's an example: case [group] when 'C' then case control when 1 then case phase when 1 then 'Init... Database Wed, 11 Jul 2007 12:17:00-0700 http://www.psykel.com/blog/index.cfm/2007/7/11/Nested-CASE-in-SQL http://www.psykel.com/blog/index.cfm/2007/6/20/Editing-single-files-with-cfEclipse One thing that kind of bugged me with Eclipse is that I thought I could only edit code contained in a project. What if you want to edit some standalone file somewhere? I thought I was out of luck. Then I stumbled upon the File Explorer tab (wind... web Wed, 20 Jun 2007 08:16:00-0700 http://www.psykel.com/blog/index.cfm/2007/6/20/Editing-single-files-with-cfEclipse http://www.psykel.com/blog/index.cfm/2007/6/11/SQL-Server-triggers-not-firing-with-replication Ran into a problem today. Two SQL DBs, using transactional replication. I had some triggers created on the subscriber end that worked off insert, delete, and update operations. The triggers worked great when inserting/updating/deleting data lo... Database Mon, 11 Jun 2007 22:29:00-0700 http://www.psykel.com/blog/index.cfm/2007/6/11/SQL-Server-triggers-not-firing-with-replication http://www.psykel.com/blog/index.cfm/2007/5/23/Apache-Monitor-on-Vista This should be my last Apache/Vista x64 post. From what I've seen, Apache Monitor won't run correctly out of the box. You'll get some lame error code like "the program completed successfully" or something like that. What you need to do is go t... Server Wed, 23 May 2007 08:46:00-0700 http://www.psykel.com/blog/index.cfm/2007/5/23/Apache-Monitor-on-Vista http://www.psykel.com/blog/index.cfm/2007/5/22/Apache-22-on-Vista-x64 More headaches from installing Apache 2.2 on Vista x64 today. The Apache connector is bad. First, see Adobe's fairly pathetic technote here. Install the new wsconfig.jar as they describe. If the remainder of the technote works for you, I ha... Server Tue, 22 May 2007 12:49:00-0700 http://www.psykel.com/blog/index.cfm/2007/5/22/Apache-22-on-Vista-x64 http://www.psykel.com/blog/index.cfm/2007/5/22/Installing-Apache-22-on-Vista I ran into a couple problems today installing Apache HTTP Server v2.2 on Vista x64. Here's the problems, and the workarounds: Install You can't simply click on the Apache install msi and have everything work as it should. You'll get permissio... Server Tue, 22 May 2007 00:04:00-0700 http://www.psykel.com/blog/index.cfm/2007/5/22/Installing-Apache-22-on-Vista http://www.psykel.com/blog/index.cfm/2007/5/10/Removing-trailing-zeros-from-decimal-numbers-in-SQL Say you've got a numeric field (SQL Server DB) which returns numbers to three decimal places, e.g. 1.000, 2.125, 3.250, etc. How do you return those numbers minus the trailing zeros? I can't believe this is so difficult. Surely there's an easy w... Database Thu, 10 May 2007 15:33:00-0700 http://www.psykel.com/blog/index.cfm/2007/5/10/Removing-trailing-zeros-from-decimal-numbers-in-SQL http://www.psykel.com/blog/index.cfm/2007/5/9/Quickly-Shrink-a-SQL-Server-Transaction-log Okay, say you encounter a SQL Server Database that's got a HUGE transaction log, and you need to shrink it quickly. MS has several KB articles such as this one. But if you really want to shrink the log file fast, and you don't need to keep the tr... Database Wed, 09 May 2007 13:23:00-0700 http://www.psykel.com/blog/index.cfm/2007/5/9/Quickly-Shrink-a-SQL-Server-Transaction-log http://www.psykel.com/blog/index.cfm/2006/7/13/appending-an-ntext-field Say you want to do something like this: update table set ntextThing = ntextThing + '!' where id = 1 That's not going to work. This does, though: DECLARE @ptrval binary(16) SELECT @ptrval = TEXTPTR(ntextThing) FROM item WHERE id =1 U... Database Thu, 13 Jul 2006 14:50:00-0700 http://www.psykel.com/blog/index.cfm/2006/7/13/appending-an-ntext-field http://www.psykel.com/blog/index.cfm/2006/5/25/Nested-Query-Loops--Worst-code-ever I had no idea how bad nested query loops are. But oh man, they are BAD. I came across this "technique" this week when a very busy site started resonding extremely slowly - like 30 seconds per request, sometimes more. I didn't write the code, b... [More] web Thu, 25 May 2006 22:44:00-0700 http://www.psykel.com/blog/index.cfm/2006/5/25/Nested-Query-Loops--Worst-code-ever http://www.psykel.com/blog/index.cfm/2006/5/22/Keep-it-scalable-kids We had a lot of trouble today with some really bad code that looked to be written about 10 years ago. It was simply horrible. Nested loops, tons of CFIFs, you name it. Opening and editing this one CF file felt kinda like fixing a leaky pipe in m... web Mon, 22 May 2006 23:55:00-0700 http://www.psykel.com/blog/index.cfm/2006/5/22/Keep-it-scalable-kids http://www.psykel.com/blog/index.cfm/2006/3/21/International-Characters-db-cf4 Every now and then you get a little job that seems simple and straight forward, but is anything but. I just encountered one of those. I recently inherited an old CF application, written in CF 4.5 or 5.0. The cfml templates have Japanese charac... [More] web Database Tue, 21 Mar 2006 15:07:00-0700 http://www.psykel.com/blog/index.cfm/2006/3/21/International-Characters-db-cf4 http://www.psykel.com/blog/index.cfm/2006/3/17/SES-can-cause-trouble-if-youre-not-careful So I recently deployed some SES URL code to a big site we did. One thing I forgot to do was adjust a layout file that is used by sort of sister site - same content, different layouts. Anyway, I did not add the BASE HREF tag to this layout file. ... web Fri, 17 Mar 2006 11:36:00-0700 http://www.psykel.com/blog/index.cfm/2006/3/17/SES-can-cause-trouble-if-youre-not-careful