To do this, end your SQL query with LIMIT 1

Tips from an old issue of .NET...

If your image is a JPEG, double-click it in the library, check the 'Use imported JPEG data' box and uncheck 'Allow smoothing'.

If it's a GIF, uncheck 'Allow smoothing' and make sure it has a one pixel transparent border (?!!)

I've used Flash a little at work but never noticed imported graphics being degraded. Maybe this only applies to an earlier version of Flash?

Checking and Setting up the Correct Permissions on IIS Server via Web Wiz Guide.

Note: in point 5, the 'Security' tab isn't there by default. To turn it on, Windows Explorer > tools > folder options > view tab > turn simple file sharing off

Cash in on call time - Sceptical Guardian article on VOIP from August.

The Spying Game - Spyware summary from the Guardian.

See the grey rectangle above the vertical scrollbar? Drag it down.

Useful .NET links:

http://www.gotdotnet.com/
http://www.dotnetjunkies.com/
http://msdn.microsoft.com/netframework/
http://www.windowsforms.net/
http://www.microsoft.com/net/default.mspx

Turning a list into a navigation bar

Using Microsoft's createpopup method to get round the SP2 restrictions on javascript window.open popups.

Want to connect your laptop to the net wirelessly or through your mobile while you're on holiday? Read this.

Test your PC for security holes (note: at time of writing this doesn't work with Firefox)

Blocking Unwanted Parasites with a Hosts File from MVPS.opg

http://www.cbtcafe.com/photoshop/batch/batch.html

EasyCleaner is a freeware utility for cleaning files and registry entries you don't need off your machine. Be warned though, programs like this can break things (see the blacklist updates on the homepage, which shows programs it used to break!)

If you do decide to give this software a spin, you might want to avoid messing with duplicate files, and stick to just unneccessary files and the registry (after backing this up first, natch).

A guide to windows services from the elder geek. There are lots of these around but this is the first I've seen which starts with a note that changing the services settings is pretty much a waste of time!

"Frankly, I don't recommend you change any of the services from the default installation of XP. Yes, you may pick up a tiny performance gain by fiddling with the settings, but it won't be anything substantial."

Don't have MS Office but need to view an MS Office document? You could install OpenOffice, or NeoOffice for Mac OS X, (which are both free) or you could use a free viewer from Microsoft.

"EyeRelief is a small, simple and free Windows utility that provides improved legibility to high density LCDs, allowing larger font, icon, tool and taskbar sizes at native resolutions."

Plenty of free IT tutorials here. Can be frustrating as they seem to be single chapters from books, but hey the price is right!

Unsafe Email from 'Ask Jack' at the Guardian.

Also liked the comment...
"Never put anything in an e-mail that you wouldn't mind appearing on the front page of 'The Sun'"

Highly regarded boot-up rescue tool fot win 2000 or XP. Note: you'll need your original windows disk when creating your BartPE disk.

http://www.nu2.nu/pebuilder/

More on BartPE here.

This is similar to Windows Preinstallation Environment - WindowsPE - except that product is only available to Microsoft's enterprise or SAM customers.

Free ASP helpdesk software. No idea if this is any good btw.
http://www.liberum.org/

Hesk - free helpdesk software
http://www.phpjunkyard.com/free-helpdesk-software.php

Customise your windows installation CD
http://www.nliteos.com/nlite.html

http://labnol.blogspot.com/2005/11/add-language-translation-to-website.html

When closing Outlook 2000 it hangs with the message "Please wait while Microsoft Outlook exits" and has to be shut down from task manager. To fix this, first run microsoft office update to bring your copy up to service pack 3, then there is a hotfix for this issue which can be found in various places on the web (eg. http://djbumrush.com/outlook.html at time of writing).

All the basics of search engine optimization, including some handy tips I hadn't heard before...
http://www.seomoz.org/articles/bg2.php

http://www.mediawiki.org/wiki/MediaWiki

Open the folder Program Files\Adobe\Acrobat 6 (or whatever)\Reader\Plug_ins.

Move all files except EWH32.api, search.api and printme.api into the 'Optionals' folder.

Open Acrobat Reader. Edit > Preferences > Startup. Uncheck 'Display Splash Screen'.

Update 27/12/05:
More here...
http://insidemicrosoft.blogspot.com/2004/12/how-to-optimize-adobe-reader-70.html

Two really handy online tools to help you identify a font.

http://www.identifont.com/
This one works by asking you a series of questions about the letters of the font, eventually coming up with one or a handful of suggested fonts. In my experience it is very accurate.

http://www.myfonts.com/WhatTheFont/
Here, you upload an image of part of the font in question and find the closest matches in their database.

Stick this in your page header...

<LINK REL="SHORTCUT ICON" HREF="/favicon.ico">