SQL view error "more column names specified than columns defined"

If you ever get a ColdFusion error message such as the following:

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]View or function 'dbo.myviewname' has more column names specified than columns defined.

You/somebody probably just added or deleted a column from the view definition. Then, if you have a cfquery that does a "select *" against the view, that error will result.

The fix is to run the following system stored procedure in SQL Query Analyzer, to refresh the view.
sp_refreshview 'myviewname'

Firefox popup window

Firefox popup window
Originally uploaded by webdh.

This date picker popup is hindered by the Google Notebook (GN) plug-in. You can see the GN in the status bar of my Firefox browser. It is causing this date picker HTML table to extend wider than it needs to be, and the middle column expands. Because of this, the user can't choose a date in the Saturday column. The solution is to allow the popup window to be resized, or uninstall the GN plug-in.

Dogtown

I was into the skateboarding culture back in the 80's (never got very good at it). I even had a couple friends who even built ramps in their backyards, and I'd hang out and learned about all the big names in the sport from California and around the world. Now there are a few movies out that capture the beginning of it all in Venice, CA. I just finished watching Lords of Dogtown, and now I have Dogtown and Z-Boys on my queue. Fun to look back at those times...I never knew how the skating craze really started.

Get FREE Noodles!

Noodles & Company has a promo on their website for a free noodle meal when you sign up, and another on your birthday. You can't beat that, so check it out!