Web Design Glasgow

Web Strategy Blog

It is often hard for those needing a website to justify the costs of design. Design is often viewed as a ‘talent’ before a learned skill, and as something that we either have or we don’t, and it naturally follows that if you ‘have it’ should be able to produce it without greart expensive.

Luke Wroblewski gave an excellent presentation at the An Event Apart 2007 conference (Chicago) that helps communicate the complexity and process of design, and the value a strong design can contribute.

Luke’s presentation focuses on the web form, which is any interface that accepts user input - common examples are login/registration, enquiry, and eCommerce checkout forms. It’s clear that many businesses depend upon their customers completing these forms to generate, maintaining and convert leads, and logically follows that the quicker and easier a form is to complete, the more likely those customers will do so.

Luke presents three simple variants of webform design to demonstrate the potential impact on revenue the design of the form can have. Each form input field has a label that tells the customer what information to put in that field. Luke’s variations placed the label above the field, and to the left of the field, either left-aligned or right-aligned. His referenced studies found that customers completing forms with right-aligned labels surprisingly did so twice as quickly as those with left-aligned labels, but that quicker still were those customers completing forms with top-aligned labels.

Clearly, big differences can be made to conversion rates by assessing the quality of your web form. Luke’s presentation is available on his blog, and goes on to discuss the consideration of required/optional fields, primary/secondary actions, contextual grouping and progressive disclosure, tabbing, the path to completion, inline validation and assistance, and feedback mechanisms.

He also provides excellent example of both good and bad web forms in a very accessible presentation that will ensure you know what to expect when commissioning the design of a web form.

I’ve just been struggling to enable full-text search on my installation of SQL Server 2005 Express Edition, and so want to share the solution.

If, like me, the ‘Use full-text indexing’ checkbox was greyed out under Database > Properties > Files, you first need to test whether Full-Text Indexing is installed or not. To do this, execute the query.

use [dbname]
select fulltextserviceproperty(’isfulltextinstalled’)

If this returns 0, you need to install Full-Text Search.

Firstly, did you install SQL Server 2005 Express Edition Advanced Series? Only the Advanced Series contains full-text. If not, you may need to reinstall.

However if so, then you just need to change the installation to include Full-Text Indexing. But if you originally installed from a download from the above link (most of you) then you’ll find that when you try to modify the installation via Control Panel > Applications / Programs, Windows prompts you for the installation file ’sqlrun_sql.msi’. This is because the download unpacked the installation files to a temporary folder which can no longer be found.

To resolve this issue, you need to download the file again from the link above, move it to a folder, and unzip (I used WinRAR). Then point Windows to the sqlrun_sql.msi file (under /setup, wherever you unzipped the download) when it prompts you for the installation file.

For additional info, see here.

For additional support setting up Full-Text Search once installed, watch this video on the topic from Micosoft, BUT I think you’ll find my new tutorial on seting up Full-Text Search in SQL Server 2005 Express much quicker and more intuitive to be honest..

Categories

Archive

Add to Technorati Favorites