Well, my recent car lease has come to an end so I thought I'd better get a shift on and buy a new car. Fortunately I've been working in the motor industry for quite a while now.

The quandry... Buy or lease? Leasing is great but having to put 2 months deposit down can be a bit of a p.i.t.a. So for once, I thought I'd buy a car. Once that was sorted, I started looking round the interweb to find the best deal I could. After a few hours, I came across Drive the deal. The site may look a little basic but geez, the prices were good.

I spoke to a guy there called Richard and he sorted me out with a really amazing deal on a new Audi TT. I've always fancied a little sports car but now I can actually afford one!! Wooohoo!

So, in the next couple of weeks my trusty E-class goes back to Bank of Scotland and I'll be taking delivery of my new TT. Thanks Richard.

Have a look for yourself at www.drivethedeal.com

Crikey - Yet another car leasing website... I've been busy over the Christmas period getting yet another website ready for the new year.

Crystal Lease specialise in business contract hire, personal contract hire and van leasing for small to large companies. Have a look at their site now to see what you think.

Visit: www.crystallease.co.uk

We have just completed work on a re-vamped website for John Williams Home Improvements.

John Williams are a North Wales home improvement company specialising in conservatories and replacement windows. They have been established since 1969 and have a reputation which is second to none.

John Williams have some of the UK's finest windows in North Wales. Have a look at the website now to see what you think.

To validate an email address in ColdFusion, we use the regular expression shown below.

You could easily add this to a CFC if you wanted to return a true or false depending whether the email address validates or not.

We have just finished work on a new site for the Geraint Davies Hearing Centre. Specialising in all types of hearing aids.

Geraint began his career in Audiology with the NHS in Bangor and trained at the Royal National Throat Nose and Ear Hospital, Gray's Inn Road, London.

Having qualified in 1976 he worked for ten years with the NHS before joining the private sector with Cheltenham Hearing Centre and eventually becoming Area Manager with Siemens Hearing Instruments.

If you are looking for a new or replacement hearing aid, then why not visit his new site at: www.gdhearing.com

To remove all HTML tags from a string, you can use the following regular expression.

This could be used to stop HTML being injected into URL values. Or even just for creating plain text content from a HTML page.

We have recently release a new improved version of theWebguides.net which has now been expanded to provide misspelling searches for most of the countries that ebay are active in.

Our ebay misspelling tool can find you the cheapest listings on the site. Using state of the art tools, you can find all the auction misspellings that people have mis-spelt while they were adding them to ebay.

What this means is that you will more often than not find listings either no, or very few bids on them. Fewer or no bids can only mean one thing! Cheaper prices.

For example, try these:-

• Nintendo wii (Games) or Nintendo DS
• High school musical (Toys and music)
• River island (clothing)
• Monsoon (clothing)
• Bratz (Toys)
• Bob the builder (Toys)

Enjoy!!

Another one of those funnies... Only recently Adobe dream weaver CS3 started crashing when I was selecting text in code view. For example, the code below, if I tried to select the whole CFIF block, then immediately a Vista error message appeared saying dreamweaver had crashed.

<cfif isdefined("attributes.endDate")>
 <cftry>
  <cfset attributes.startDate = dateformat(attributes.startDate, "dd mmm yy")>
  <cfcatch type="Any">
   <cfset tx = structDelete(attributes, "startDate")>
  </cfcatch>
 </cftry>
 <cftry>
  <cfset attributes.endDate = dateformat(attributes.endDate, "dd mmm yy")>
  <cfcatch type="Any">
   <cfset tx = structDelete(attributes, "endDate")>
  </cfcatch>
 </cftry>
</cfif>

After some investigation, I found the following thread which helped immensely:-

http://groups.google.com/group/macromedia.dreamweaver/browse_thread/thread/e493f48243a14b28/2fa3ea8a3c34ba5b

The crux of it was deleting the winfilecachexxxxx.dat file - Once doing this, it was plain sailing and hasn't crashed since.

On Windows Xp, the file is at:-

[drive]:\Documents and Settings\[username]\Application Data\Adobe\Dreamweaver
9\Configuration

On Windows Vista, you can find it in:-

[drive]:\Users\[username]\AppData\Roaming\Adobe\Dreamweaver 9\Configuration
or accessible via windows explorer in
Desktop\[username]\Roaming\Adobe\Dreamweaver 9\Configuration

We have just released a re-designed version of the Plas Llwyd guest house, Llandudno. Amanda wanted a more subtle and lighter feel to their previous website and a more authentic feel for her Victorian guest house.

We opted for light and airy with classy photographs from this tastefully decorated property. If you are looking for a bed and breakfast in Llandudno, the Plas Llwyd guest hosue would be a really great place to visit. The guest house is a 4 star guest accommodation as rated by the Visit Wales (formerly the Welsh Tourist Board)

Why not visit the website now at http://www.plasllwyd.com

My good friend Paul Levy ( visit his blog at www.ideasman.com ) has recently revamped his North Wales website. On Beautiful North Wales you can find a wide variety of guest houses, hotels and other accommodation - You can also find a list of the many attractions in North Wales and Llandudno.

Why not see what Paul has done by visiting his site at http://www.beautiful-northwales.com

We have just completed work for a credit card comparison website. We developed the back end tools which enables the webmaster to easily aggregate the best credit card offers from all the major UK card providers.

In addition, we wrote the tool which enables the visitors to compare credit cards and find the best card for them. They are presented with a simple to understand breakdown of the best cards available, and from there they are able to find out detailed information about any of the credit cards presented to them. There is also a rating system which is dynamically managed based on user feedback.

Visit the website now to see how it works:- http://www.airaid.co.uk

Marine Park is a family oriented holiday park in Rhyl North Wales Rhyl, North Wales. We wanted the site to be very simple to navigate and also to be bright, and fun.

Although attracting new guests to stay at the park was key, it was also very important to increase the exposure and traffic for their caravan sales department. Therefore, all the pages were search engine prepared by default (our usual practice) but with extra emphasis on the static caravans for sale and used holiday home caravans ( Park homes).

I recently had a problem with CFINSERT when I had to insert data into an autonumber column. Even after deleting all columns in the table, when I tried CFINSERT ing I got the error: Cannot insert explicit value for identity column in table 'style' when IDENTITY_INSERT is set to OFF. <br>The error occurred on line 65535.

Now, being a lazy git, I couldn't be bothered interrogating the DB structure so that I could use the correct CFQUERYPARAM for each field. So, as CFINSERT is dead easy to use, I thought I'd rather find a workaround..

Simple really, enclose the CFINSERT in a CFTRANSACTION so as far as the DB server is concerned it's all part of the same query.

   <cftransaction>

    <cftry>
     <cfquery datasource="#odbc_datasource#">
     set identity_insert #arguments.tablename# ON;
     </cfquery> 
     <cfcatch type="any">
     <!--- Probably doesn't have an identity column --->
     </cfcatch>
    </cftry>

    <cfinsert tablename="#arguments.tablename#" tableowner="dbo" formfields="#lcase(tColumns)#" datasource="#odbc_datasource#">

    <cftry>
     <cfquery datasource="#odbc_datasource#">
     set identity_insert #arguments.tablename# OFF;
     </cfquery> 
     <cfcatch type="any">
     <!--- Probably doesn't have an identity column --->
     </cfcatch>
    </cftry>

   </cftransaction>

The CFCATCH in the IDENTITY part catches the following error:-

Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Table 'style_links' does not have the identity property. Cannot perform SET operation. <br>The error occurred on line 65535.

At last, I have my own pool table! After trawling eBay for weeks I finally found a local company called Amazon Leisure who have been EXTREMELY helpful in finding me the perfect table. Mark has been in the industry for over 25 years and knows his stuff!

There was a really wide choice of pool tables to choose from. There were coin operated tables, dining table pool tables and normal pool tables. Making the right choice was tough but I got there in the end.

If you live in the UK and are looking for a pool table, I can wholeheartedly recommend a visit to http://www.pooltablesuk.co.uk they have a great selection, and expert advice is only a phone call away.

We have recently completed some SEO work on KeyPT's website. Todd Thornberry is a personal trainer in North Wales and is a fully qualified sports trainer, sports massage therapist, nutritional adviser and first aider.

Todd provides personal fitness training home visits across the North West and North Wales. In addition to traditional personal training he is also an expert in Golf conditioning to help golfers improve their game and also to help other sports people reduce risk of injury and build their overall fitness.

Interested in some personal training yourself?? Why not visit Todd's site at www.keypt.co.uk