Sunday, 27 February 2011

Skoda Fabia – Boot Strut fitment guide

(credit to : http://www.tailgatestruts.com/gas-strut-fitting-mounting)

How to Fit & Remove Tailgate Struts

Band Type Ball Sockets

Removing and installing gas struts on your car is often a quick and simple job which does not require a mechanic.
If your gas struts have a ball and socket fittings then the only tools required are flat blade screwdriver and someone to hold the boot for you.

Look at the end of the gas strut for a rectangular plastic block with a metal band running around the back.
Some struts use metal fittings but the band will be in a similar position.

  • Slide a flat head screwdriver down the groove along the back of the fitting and under the metal band.
  • Lever the band back and pull on the gas strut to remove it from the car. You do not need to remove the band to do this – just lever it back.
  • Your new gas struts will simply push fit back onto the ball studs.


Replacing car tailgate struts is a two person job.
 
Do not remove one strut and rely on the other to hold the tailgate.

 

Pin Type Ball Sockets

If your gas struts have a dome end fitting with a small metal pin -

  • Unclip the pin from around the base of the fitting and totally remove it from the fitting.
  • Once the pin is removed the gas strut can be pulled off, leaving the ball attached to the vehicle.
  • To fit your new struts remove the pin, push fit them onto the ball stud and replace the pin.


Skoda Fabia – Boot Strut

Model: Skoda Fabia Hatchback Gas Strut
Body: Hatchback
Year: 1999 - 2007
Part#: 6Y0827550A 7969MW

 

 

http://www.tailgatestruts.com/gsc2142-skoda-fabia-tailgate-strut

 

 


 

Other suppliers: SGS Engineering £13.99

Thursday, 17 February 2011

SQL – Simple way to return messages at runtime instead of using PRINT

Care of David Poole of SQLServerCentral: http://www.sqlservercentral.com/articles/Documentation/72473/

 

 

RAISERROR ( 'DATA DICTIONARY: %i tables & %i fields added', 10, 1,

    @TableCount, @FieldCount ) WITH NOWAIT




The "10" parameter is the SEVERITY of the error message raised.

10 : this is more of a notice message, or minor alert

16 : this is reserved for true error messages


You can find more via:
http://www.sqlservercentral.com/articles/SQL+Puzzles/quickhintsforusingtheraiserrorcommand/2114/

http://msdn.microsoft.com/en-us/library/ms178592.aspx

Friday, 11 February 2011

Word of the Day - Antiquated

Pronunciation
  • IPA: /ˈæntɪˌkweɪtɪd/, SAMPA: /"{ntI%kweItId/


    Adjective
    antiquated (comparative more antiquated, superlative most antiquated)
    1. old-fashioned, out of date  [quotations ▼]
  • Internet Explorer IE Shortcut Keys

    Care of http://support.microsoft.com/kb/306832

    How to View and Explore Web Pages Shortcut Keys


    To view and explore Web pages with shortcut keys:


    To
    do this


    Press this key


    Display
    Internet Explorer Help or to

    display context Help about an item in

    a dialog box


    F1


    Toggle
    between full-screen and other

    views in the browser


    F11


    Move
    forward through the items on a

    Web page, the Address box, or the

    Links box


    TAB


    Move
    through the items on a Web page,

    the Address box, or the Links box


    SHIFT+TAB


    Go
    to your Home page


    ALT+HOME


    Go
    to the next page


    ALT+RIGHT ARROW


    Go
    to the previous page


    ALT+LEFT ARROW or BACKSPACE


    Display
    a shortcut menu for a link


    SHIFT+F10


    Move
    forward between frames


    CTRL+TAB or F6


    Move
    back between frames


    SHIFT+CTRL+TAB


    Scroll
    toward the beginning of a


    UP ARROW


    document


     


    Scroll
    toward the end of a document


    DOWN ARROW


    Scroll
    toward the beginning of a

    document


    PAGE UP


    Scroll
    toward the beginning of a

    document in larger increments


    PAGE DOWN


    Move
    to the beginning of a document


    HOME


    Move
    to the end of a document


    END


    Find
    on this page


    CTRL+F


    Refresh
    the current Web page


    F5 or CTRL+R


    Refresh
    the current Web page, even if

    the time stamp for the Web version and

    your locally stored version are the same


    CTRL+F5


    Stop
    downloading a page


    ESC


    Go
    to a new location


    CTRL+O or CTRL+L


    Open
    a new window


    CTRL+N


    Close
    the current window


    CTRL+W


    Save
    the current page


    CTRL+S


    Print
    the current page or active frame


    CTRL+P


    Activate
    a selected link


    ENTER


    Open
    the Search box


    CTRL+E


    Open
    the Favorites box


    CTRL+I


    Open
    the History box


    CTRL+H


    In
    the History or Favorites boxes,

    open multiple folders


    CTRL+click






    How to Print Preview With Shortcut Keys


    To Print Preview Web pages with shortcut keys:


    To do this


    Press this key


    Set printing
    options and print the page


    ALT+P


    Change paper,
    headers and footers,

    orientation, and margins for this page


    ALT+U


    Display the first
    page to be printed


    ALT+HOME


    Display the previous
    page to be printed


    ALT+LEFT ARROW


    Type the number of
    the page that you

    want displayed


    ALT+A


    Display the next
    page to be printed


    ALT+RIGHT ARROW


    Display the last
    page to be printed


    ALT+END


    Zoom out


    ALT+MINUS


    Zoom in


    ALT+PLUS


    Display a list of
    zoom percentages


    ALT+Z


    Close Print Preview


    ALT+C



    How to Use the Address Box Shortcut Keys


    To use the Address box with shortcut keys:


    To do this


    Press this key


    Select the text in
    the Address box


    ALT+D


    Display a list of
    addresses that you

    have typed


    F4


    When in the Address
    box, move the cursor

    left to the next logical break in the

    address (period or slash)


    CTRL+LEFT ARROW


    When in the Address
    box, move the cursor

    right to the next logical break in the

    address (period or slash)


    CTRL+RIGHT ARROW


    Add
    "www." to the beginning and ".com"

    to the end of the text that you type in

    the Address box


    CTRL+ENTER


    Move forward
    through the list of

    AutoComplete matches


    UP ARROW


    Move back through
    the list of

    AutoComplete matches


    DOWN ARROW


    How to Work With Favorites By Using Shortcut Keys


    To work with Favorites by using shortcut keys:


    To do this


    Press this key


    Add the current
    page to your favorites


    CTRL+D


    Open the Organize Favorites dialog box


    CTRL+B


    Move selected item
    up in the Favorites

    list in the Organize Favorites

    dialog box


    ALT+UP ARROW


    Move selected item
    down in the

    Favorites list in the Organize Favorites

    dialog box


    ALT+DOWN ARROW


    How to Edit With Shortcut Keys


    To edit with shortcut keys:


    To do this


    Press this key


    Remove the selected
    items and copy them

    to the Clipboard


    CTRL+X


    Copy the selected
    items to the Clipboard


    CTRL+C


    Insert the contents
    of the Clipboard at

    the selected location


    CTRL+V


    Select all items on
    the current Web page


    CTRL+A

    Sunday, 6 February 2011

    Android ADB Wireless

    http://www.androidcentral.com/android-quick-app-adb-wireless

     

    With the "adbWireless" app, you can connected to the android phone, over WIFI, as though you were connected via a USB cable.

     


    (image care of AndroidCentral)

     

    The "adb" command is usually part of the "Android SDK" (software development kit) which can be downloaded here.

     

    A great article on the SDK can be found on AndroidCentral also, click here to be re-directed.

    Installing Android 2.3 GINGERBREAD to Android HTC DESIRE

    There's full instruction list on HOW TO INSTALL GINGERBREAD (Android 2.3) onto the HTC DESIRE over at BrightHub.

    Some of the important steps are:
    1. Download (from MARKET) Rom Manager - by ClockworkMod
    2. Download the HTC Desire Android 2.3 Gingerbread ROM "update-oxygen-2.0-RC5-signed.zip" Download Oxygen 2.0 Gingerbread ROM for your HTC Desire. Note where you save the file on the phone, or tansfer the file to your phone from the pc and note the location.
    3. In ROM MANAGER, select the Flash Clockworkmod Recovery option. It will install the recovery image and backup the current ROM on your HTC Desire.
    4. In ROM MANAGER, select "Install ROM from SD Card" option.

      Select the Android 2.3 Gingerbread ROM (ocation previously noted) and click on install it.
      NOTE: Make sure to select the Wipe Data and Cache options before you install it.

    5. Wait whilst ROM MANAGER performs the install.


    6. In case of any problems with ROM Manager on your Desire,
      just boot your rooted HTC Desire into recovery mode and install the ROM via recovery directly.

    Thursday, 3 February 2011