July 2007 - Posts

• Ooo Verizon is l33t

  Look ma, verizon is hip and cool because they're up on my lingo. I wonder what cat they had build their website. See if I enter teh text "later" into their text box and click a button it will instantly transform it into cool l33t speak. Before:   After: Posted Jul 25 2007, 02:59 PM by chrisortman with no comments

• Generating stored procedures to multiple files - SQL2005

  Remember that functionality in Enterprise Manager that let you generate scripts for all your stored procedures to multiple files? I guess no one used that feature because in SQL Management Studio (2005) that feature was removed. I found some information here that says it was put back in SP2. However SP2 is a 292MB download. So I started the download, but while it was downloading I figured I'd just write my own script to do this for me. I saw some forum posts saying you could do this all using SQL, but that just sounded boring so I thought I'd use Ruby instead. 1 require 'ftools' 2 File.makedirs 'split_sp' 3 4 File.open('storedprocs.sql','r') do |file| 5 6 text = file.read 7 8 text.scan(/CREATE PROCEDURE \[dbo\]\.\[(API_\w+)\]\s*(.*?)'\s*^END$\s*^GO$/m) do |match| 9 File.open("split_sp/#{match[0]}.sql",'w') do |write_file| 10 write_file.write "CREATE PROCEDURE [dbo].[#{match[0]}]\n" 11 write_file.write match[1] 12 end 13 end 14 15 end Code syntax highlighting by VIM captured with ScreenShot script Posted Jul 24 2007, 06:06 PM by chrisortman with no comments Filed under: Ruby

• Good Installer Experience

  Jeff Atwood points out some definciencies in the install process for many of today's applications. Having just installed Jing yesterday I wanted to point out how pleasant I found their installer.   Click the check box and then the install button and it's done. Not only is the install a breeze, but the app is quite slick as well. Posted Jul 20 2007, 09:18 PM by chrisortman with 1 comment(s) Filed under: Tools

• Taking SharedView for a test drive

  I needed to do some training remotely today. Typically I would use GotoMeeting for this, but I have been wanting to give SharedView a try and see how it worked. You can grab the download here http://r.office.microsoft.com/r/rlidSV?clid=1033&p1=1&p2=download_msi Setup was nice and simple. Once it's installed you enter your windows live ID and you're ready to go. There is an option to preview the window you are currently showing which I like. Other than app sharing I didn't get too deep into the functionality. I did allow another user to take control of the session for a while. When I move my mouse it would affect him which I don't like. I'd like to be able to give control while I do some other work on my other monitor. My coworker that took control for a while thought performance was "herky-jerky" so hopefully that can get a little smoother. All in all though I liked what I saw. Posted Jul 13 2007, 07:50 AM by chrisortman with no comments

• Visual Studio template information is out of date?

  What? Good question. In the middle of working I thought I'd add a new class to my project when low and behold I get a dialog box: No Visual Studio template information found. Seel the application log in Event Viewer for more details. Ok, so I open up event viewer and find this Event Type: Warning Event Source: Visual Studio - VsTemplate Event Category: None Event ID: 1 Date: 7/11/2007 Time: 4:31:56 PM User: N/A Computer: Description: The Visual Studio template information is out of date. Regenerate the templates by running 'devenv /installvstemplates' or reinstalling Visual Studio. Note: corrective action requires Administrator privileges. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp. Except a lot of them. I have no idea why this suddenly started happening. Well let's check google http://traversee.spaces.live.com/blog/cns!660EC1EE75BC1F77!142.entry http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=52248&SiteID=1 http://geekswithblogs.net/jeelz/archive/2007/04/03/110665.aspx Sigh....I'll probably just run the command line as it seems to fix it. Hopefully it doesn't break ViEmu or R# or TD.Net. Posted Jul 11 2007, 03:06 PM by chrisortman with no comments Filed under: VisualStudio

• innerHTML does not work in IE select boxes

  Doing some MonoRail work I have a JS view that needs to update the options in a select box. Things had been working swimminly in Firefox, but then I tested in IE. Note to self: BUG: Internet Explorer Fails to Set the innerHTML Property of the Select Object   I searched around and found this commit to the prototype code, but how do I get this change? I see a change to the change log in the branch that contains this line * Make Element#update work for SELECT tags in IE and Opera. [Tobie Langel]   My next step is then to check the change log on the trunk using svn blame Where I see that this branch was merged with the trunk in revision 6725. I wonder what revision the latest and greatest code is based off? svn info http://svn.rubyonrails.org/rails/spinoffs/prototype/tags/rel_1-5-1 Path: rel_1-5-1 URL: http://svn.rubyonrails.org/rails/spinoffs/prototype/tags/rel_1-5-1 Repository Root: http://svn.rubyonrails.org/rails Repository UUID: 5ecf4fe2-1ee6-0310-87b1-e25e094e27de Revision: 7180 Node Kind: directory Last Changed Author: sam Last Changed Rev: 6643 Last Changed Date: 2007-04-30 23:13:14 -0500 (Mon, 30 Apr 2007) Nope not what I want. Guess I'll take a chance on running from trunk. mkdir prototype cd prototype svn co http://svn.rubyonrails.org/rails/spinoffs/prototype/trunk . rake dist copy dist\prototype.js .... See if my problem is fixed.....Eureka! Posted Jul 11 2007, 02:03 PM by chrisortman with 2 comment(s)

• Ruby include and extend

  Nice write up by Marc about ruby extend and include. He succinctly explains what each of the methods do, however I think his explanation is for a ruby programmer, not a C# programmer trying to learn more about ruby. Upon further research I found another post that made it quite clear for me. The extend method will mix a module’s methods at the class level. The method defined in the Math module can be used as a class/static method. The include method will mix a module’s methods at the instance level, meaning that the methods will become instance methods. It is much easier for me to relate that to what I am familiar with in C#. Posted Jul 07 2007, 09:23 AM by chrisortman with 6 comment(s) Filed under: Ruby

• Here's a new one

  Just got this error when trying to invoke MSBUILD from the VS2005 command prompt. MSBUILD : warning MSB4056: The MSBuild engine must be called on a single-threaded-apartment. Current threading model is "MTA". Proceeding, but some tasks may not function correctly. It was working fine, and I have no idea what changed. I retried it and it worked fine the second time....odd Posted Jul 05 2007, 03:50 PM by chrisortman with no comments Filed under: .NET, Build