Geeky things

Recently i had a small task of updating a database column with the contents of two other database columns.

I was trying to use a '+' or a '&', but SQL likes the concat function.

The below snippet appends the product model to the front of the products name and adds a space.

update products_description inner join products on products_description.products_id = products.products_id set products_description.products_name = concat(products.products_model, concat(' ', products_description.products_plain_name));

SOAP UI is a valuable tool for creating SOAP requests and responses.

There is a stand alone application and an Eclipse plugin.

http://www.soapui.org/eclipse/index.html

I am currently in the process of starting up a project which requires source control managment and external access for multiple users. SVN is what i’ve used in the past and it remains my favorite tool.

SVN is a command line source control client, unless you have a client like tortoise, or subclipse.

Name: Subclipse 1.2.x (Eclipse 3.2+)

URL: http://subclipse.tigris.org/update_1.2.x

Name: Subclipse 1.0.x (Eclipse 3.0/3.1)

URL: http://subclipse.tigris.org/update_1.0.x

Installing can be cumbersome as it requires you to run multiple executables…unless you have SVN One Click for the installation. This is a great tool for setting up the server itself, not just the client.

When it comes time to setting up user names and passwords and configuring the server, you must note that the default install location is: C:\svnrepos\conf\

The passwd file manages users and passwords. The authz files managers user permission relative to repositories, and the svnserve.conf manages the the settings.

A big, note and my big stumbling point was with the uncommenting of the following lines:

anon-access=read auth-access=write password-db=passwd

Make sure that there are no spaces before these, otherwise you will get some Option 12 SVN error.[…]

http://musicbrainz.org/

This is a very cool way to tag your music library. They also have an open API.[…]

I just saw this post on Digg, and wanted to have a more permanent link to the article.[…]

http://www.parallels.com/en/products/desktop/

This looks pretty amazing. TJ tell the Chief about this…[…]

I just downloaded and installed IE 7 Beta…so far so good. Looks much, much better than IE6. It’s similar to Opera. They’ve lost the File menus. I dig it…

http://www.microsoft.com/windows/ie/downloads/default.mspx[…]

http://www.kimili.com/plugins/kml_flashembed/wp[…]

[as]private function onCancelWinInit():Void{ cancelWin.content.cbtOk.onRelease = Delegate.create(this, onCancelOK); } [/as][…]

http://www.mikeindustries.com/sifr/

I have got to try this on this blog…

Sweet design…http://www.shauninman.com/plete/

[…]