Archives for 2006
This is a tip for SQL server – if you have a database where dates are stored as text and want to convert them all to date values. 1. Create a new column for the date value – columnName_asDate 2. Run the following script UPDATE table_name SET columnName_asDate = CONVERT(DATETIME, RIGHT(columnName, 4) + SUBSTRING(columnName, 3, [...]
A top tip for fixing Word documents that suddenly and inexplicably bloat in size. I was working on a 1.5Mb document that suddenly expanded to 14Mb! The following tip fixed it for me, Jim: "…formatting information, much of it obsolete, is stored in the final paragraph mark of the document. When you go to the [...]
I suppose this is a common problem but I was stuck on this for a while, until I found a helpful article (which I've now lost!) proposing a solution if you're using SQL Server 2000. Needing to get a single row of data from tables with a one-to-many relationship. tbl_users tbl_results [...]
Inbox overflowing? Here’s some simple rules I’m following to reduce email clutter and get on top of things: Read emails a couple of times per day. Turn off any ‘you got mail’ notifications. Respond immediately if its a minor (< 2 minute job), and delete the email you’re responding to. If some action is required [...]
Some notes and principles… Categorise based on for whom the Audience the Content the Context Set Access levels Public Practitioner Authorised users Internal Users Levels of information (pyramid) Edited (3%) KnowledgeBase (7%) Data (25%) Programme records (65%)
Thought I’d post my experience of invoking a complex web service written in .NET using ColdFusion. If you’re just starting a similar piece of work you have my sympathy – prepare yourself for some serious head scratching and mental anguish Prior to this project I had played around with the BabelFish service and checked out [...]
I really like the new-style Application.cfc – a big improvement over Application.cfm and OnRequestEnd.cfm in my opinion. At first it seems a little daunting but with help from Ray Camden and Strikefish things became clearer. I found that setting up an ApplicationProxy.cfc template in the {webroot} enables you to set up some server-wide globals (such [...]
I have used fValidate for a while, but the developers site has gone, so gives me cause for finding a new library. Recently getting into prototype and tried Andrew Tetlaw’s Really easy field validation with Prototype Andrew explains “I wanted a robust javascript validation library that was simple to implement and didn’t require me do [...]
Some useful notes on good Instructional Design principles for E-Learning. Each course is divided into individual lessons. This ensures that the student is not overwhelmed with the material. In these fast-paced times, students often want to learn the material during breaks between other tasks Each course has 5 to 15 lessons and is no longer [...]
Some useful notes on good Instructional Design principles for E-Learning. Selected bullet points from horton.com/ Motivate learners Provide options on how to learn. Ease anxiety. Opportunities for meaningful application. Do not require learners to keep more than a few items in memory at a time. Give opportunities for application & consolidation. Ask people to summarize [...]
Recent Comments