Something Subversion

Add Google Talk Online Presence to Web Pages

2008-07-13T23:04:00.004+02:00

If you use Google Talk instant messenger and would like to stay connected with visitors on your website, the Google Talk chatback badge is a cool way to display to them when you are online and available to chat / IM with them.

more...

Unable to run Proclarity Web Professional

2008-07-11T22:59:00.002+02:00

A while after installing and configuring Proclarity 6.3 the users started receiving a blank page when accessing Proclarity Web Professional:

After some searching I found this post: http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2901084&SiteID=17. There is a bug in Proclarity, for which MS has released a hotfix: http://support.microsoft.com/kb/946719.

Downloaded an installed the hotfix just to find a brand new error: "Unable to run Proclarity Professional. Either the required components are not installed or you don't have permission to download them."

more...

Grass And Sky Free website template

2008-07-11T00:34:00.005+02:00

The Grass And Sky theme is loosely based on the Dirtylicious website template by Viktor Persson which which I originally ported to a BlogEngine.NET 1.3 theme and then back into a standard website template.

more...

svn:externals with a space in the directory name [2]

2008-07-07T07:06:00.004+02:00

As promised I've published the code and instructions to my previous post...
more...

svn:externals with a space in the directory name

2008-07-07T00:34:00.007+02:00

While setting up my development environment for various BlogEngine.NET sites, I ran into the problem that when setting svn:externals: One cannot have spaces in the directory name or the external url with TortoiseSVN.
For example:

User controls svn://host/User controls

more...

Create CheckBox Option groups

2008-06-28T01:48:00.005+02:00

I was recently given a website to make changes on. The HTML was already done and signed off by the client, and could thus not be changed.
Then I came across a bunch of options that needed to be saved to the db and instead of using RadioButtonList controls, there was a table containing a lot of CheckBox controls.

more...

FeedBurner

2008-06-27T22:19:00.010+02:00

Just signed up to FeedBurner.
Subscribe Now!

Customise VisualSVN Server browser view

2008-06-27T18:40:00.002+02:00

VisualSVN Server is a basic package of Subversion with the Apache web server and a visual management console (MMC).
The VisualSVN Server browser view is very basic, but it is easy to customise via the provided XSLT stylesheet.

more...

Ode to Code, a Geek Poem

2008-06-25T18:33:00.002+02:00

I've just discovered the coolest poem 'Ode to Code, a Geek Poem' on Raphael Koster's Website

more...

Adding an Ordinal column using a sub query

2008-06-20T14:40:00.009+02:00

This is just a simple way of adding an ordinal column to a SQL result using a sub query. This method depends on the Primary Key field of the table. I used the Northwind database for this example.

more...

Microsoft Excel - How to check if a value exists in a range

2008-06-13T10:21:00.005+02:00

I had to compare some simple lists. I could have used a database, loaded the lists and used sql to do the comparisons. Not in the mood for that, then let's just use Excel.

more...

Simple lamda expression example in C#

2008-06-13T00:50:00.006+02:00

A friend asked me for an example of a lamda expression, and after going through my code and searching the net, I discovered this little gold nugget:

more...

the UNIX date command and Date manipulation

2008-06-12T23:48:00.007+02:00

You need to do something on a daily with a file in a directory named yyyy-mm-dd.txt (year-month-day.txt).
That's easy enough:

#!/bin/ksh
# just get the current date
today="`date +%Y-%m-%d`"
filename="${today}.txt"
echo $filename

Oops, you need the file from yesterday. Not so simple any more as the unix date command just sets or prints the date.

more...

View running 4GL SQL queries

2008-03-27T23:15:00.005+02:00

It has been a while since i have had to work with Informix / 4GL. I have already forgotten tha simple commands to view the current running SQL query with an executing 4GL script. So this is more of a note to myself, but if it helps you, I'll be overjoyed.

more...

Accessing fields in the BindingSource.Current property

2008-01-10T14:04:00.001+02:00

I was using the Current property of a BindingSource object in VB.Net for sometime now using inplicit conversions to access fields:
MyBindingSource.Current(0) = someValue

While in C# we need to explicitly cast the Current property to some type and use that.

more...

Windows.Forms Binding errors with .Net 2.0 (Part 3)

2008-01-05T01:04:00.002+02:00

In a DataGridView, when deleting the last remaining data row, the UserDeletedRow event does not fire.

more...

Windows.Forms Binding errors with .Net 2.0 (Part 2)

2008-01-04T23:58:00.002+02:00

I've got a BindingSource setup with the Sort property set to a valid column name and all works well, (dejavu) but the problem is when the form closes, and starts Disposing controls, I get this message:
"Sort string contains a property that is not in the IBindingList."

more...

Windows.Forms Binding errors with .Net 2.0 (Part 1)

2008-01-02T11:49:00.001+02:00

I've recently had to work on a project using DataBinding. All seemed to work well until I ran into some strange issues.

This is the first of a few posts describing these issues and how to work around them.

I've got some bound ComboBox columns in a bound DataGridView and all works well, but the problem is when the form closes, and starts Disposing controls, I get this message:
"Message: ArgumentException: Cannot bind to the property or column State on the DataSource.
Parameter name: dataMember"
It seems to affect the ComboBoxes bound to the NameValueLists where the Text property is databound.

The solution is to clear all DataBinding before Dispose().

more...

SvnPerms dot Net

2006-12-29T22:34:00.003+02:00

C# port of svnperms.py pre-commit hook script.

more...

Remove the thousand separator from CSV files using AWK

2006-12-29T18:14:00.001+02:00

This will make fields like "11,368.35" look like this "11368.35".

more...

Convert SVN Repositories from BDB to FS

2006-12-29T18:05:00.001+02:00

Having a lot of problems with 'wedged' repositories?

A shell script to convert SVN Repositories from BDB to FS.

more...

Linking Subversion changesets back to a Issue Tracking url

2006-12-29T18:04:00.001+02:00

Set the bugtraq: properties on a Subversion repository (recursively):

more...

sed to convert csv to informix unload format

2006-12-29T17:46:00.000+02:00

After searching for ever, i finally managed to compile a sed script to convert CSV formatted files to informix unload format (bar-delimited) files.
Hope I help someone with this.


#************************************************#
#                 csv2unl.sh                     #
#                                                #
#          written by Riaan Lehmkuhl             #
#                Dec  29, 2006                   #
#                                                #
#  sed to convert csv to bar-delimited records.  #
#************************************************#
# usage: ./csv2unl.sh < infile > outfile         #
#************************************************#
/./!d
s/\([^\]\)|/\1\\\\|/g
s/\`/\'/g
s/^ *\(.*[^ ]\) *$/|\1|/;
s/" *, */"|/g;
: loop
s/| *\([^",|][^,|]*\) *, */|\1|/g;
t loop
s/  *|/|/g;
s/|  */|/g;
s/^|\(.*\)|$/\1/;
s/"//g
s/$/|/g