Category Archives: tips and tricks

Collection of things I think are helpful

An aggregate may not appear in the set list of an UPDATE statement

Posted on 02/20/2011 by Eric Fickes

Ever seen the error “An aggregate may not appear in the set list of an UPDATE statement” when working with SQL Server?  I ran into this one recently after trying to put a COUNT in an UPDATE statement.  I was rewriting … Continue reading →

Posted in database, development, internets, microsoft, SQL, tips and tricks, tsql | Leave a comment

Eleven Coldfusion-ish tips from the field

Posted on 02/20/2011 by Eric Fickes

I’ve had this running list of Coldfusion tips on my wall for the last few years and it’s time to get these online.  All of the items in this list came from Coldfusion projects over the last few years, but … Continue reading →

Posted in adobe, coldfusion, database, tips and tricks | Tagged , , , , , , , , , , , , , , | 10 Comments

Injecting javascript into asp.net via code

Posted on 02/18/2011 by Eric Fickes

Microsoft has a great MSDN article on using javascript along asp.net, but they didn’t mention a technique I like to use, put it in a Literal control.  While there are many ways to add javascript to a page, I find … Continue reading →

Posted in .net, C#, development, microsoft, tips and tricks | Tagged , , , , , , | 2 Comments

Today I took 30 minutes to save hours

Posted on 01/03/2011 by Eric Fickes

UPDATE – 1/6/2011 : Since writing this post I have bundled this entire reset process into a single windows batch file. In addition to restoring my database, I also have to remove temp files from my server, so it was … Continue reading →

Posted in database, development, SQL, tips and tricks | Tagged , , , , , , , , , , , , , , , , , , , , , , | Leave a comment