There’s a good article by Scott Guthrie here that describes the basics. Just scroll down to Tutorial 5 for the INSERT specific bit – it is pretty straightforward and there is no point my repeating it here. One point to note, however, and why I wrote this particular post. The key step in getting this [...]
Entries from January 14th, 2007
Tips for returning IDENTITY values from INSERT
January 14th, 2007 · No Comments · ASP2, SQL
Tags: programming·tips
Determining row counts for all tables in a database
January 11th, 2007 · No Comments · ASP2, SQL
Here is a usful snippet if you want a way to get the number of rows in each table in your database. I use this in an admin-only page of the web application to provide some at-a-glance statistics. It is also really useful in unit tests for checking the correctness of business logic that may [...]
Formatting code in WordPress
January 11th, 2007 · No Comments · Blogging
What a pain in the rear! WordPress appears nice as a blogging tool, but my attempts to format some code snippets was painful beyond belief. Every time I pasted some code in and surrounded it with the code tags, the generated HTML had extra paragraph markers and line breaks, and screwed up the position of [...]
Tags: programming·Wordpress
Useful CSV reader
January 10th, 2007 · No Comments · .net, Software Development
To aid my unit testing I needed to populate a database with a load of test data. This data needs to be generated by some of the less technical guys on the project and so exporting CSV (Comma Separated Values) files from Excel seemed a sensible approach. So I then cast around for any existing [...]
Tags: c#·programming·unit-testing
Don’t believe NUnit
January 5th, 2007 · No Comments · .net, ASP2
Just a quick note about a little problem I found using Nunit (2.2.9, but affects earlier revisions too). After a bunch of edits to my project, I suddenly started getting messages from NUnit GUI “could not load file or assembly nunit.core”. Try as I could, this would not go away. This included everything from reinstalling [...]
Perforce server logging problem
January 2nd, 2007 · No Comments · Perforce, Software Development
When setting up a server it is often useful to enable one of the logging levels. The admin guide states that you need to do this: p4 set P4DEBUG=server=2 which sets the server logging level to 2. You then need to restart the Perforce server. However, if Perforce is running as a service (the default [...]