Posted on Leave a comment

CSS: Three Column Layout ( with duplicated rows)

Sometimes you’ll need to display data in rows which also align vertically. (See the example).

For this it is best to create a div for your row holder with individual divs to set the column constraints.

[div class=’row’]
[div class=’cell’]Column 1[/div]
[div class=’cell’]Column 2[/div]
[div class=’cell’]Column 3[/div]
[/div]
And within the stylesheet:
.row {
clear:both;
}

.cell {
float:left;
width:100px;
}

Duplicate the row div and you will have equal rows and columns for your data.

Posted on Leave a comment

Setting UK as default language in Word

Apparently the language setting is a property and not a program level setting so you have to define it for the document you are creating.

New documents are actually created with a paragraph present by default, and this paragraph is set by default to be US English.

To set your new document and ALL FUTURE NEW DOCUMENTS to UK english by default:
Office 2003 / XP Tools > Language > Set Language … > Have English U.K. highlighted and click ‘Default…’
Office 2007 Review tab > ‘Set Language’ option

A popup will ask you to verify that you would like to change the default setting of the normal paragraph, agree to this and close the language box.

All new documents you create will have UK as the default setting.

Note: Old documents will not be converted to UK language setting and you will need to change the setting again when you go back to edit previously created word documents.

Posted on Leave a comment

Popping / Cracking / Static Noises in Video ( Nero )

I found that my video became crackly whenever there was background music. I couldn’t understand why because when I played it in any other player on my computer it sounded fine, only in Nero Vision Express and Nero Showtime did it all go downhill.

After trying multiple codecs and updates and even other programs altogether I was getting pretty angry.

I finally discovered that if I pay for and download an additional plug-in called Multichannel Plug-in the problem is fixed!

Hurray! It looks like my sound needed the 5.1 support from the plug-in.

I hope this helps other people because during my issues I saw many other people with similar sounding problems and I think this could be your solution. They really should provide this plugin for people with older versions of Nero and not just Nero 7.

Posted on Leave a comment

Restoring a SQL server database

I was trying to move a database from the client’s existing live site to our testing database on another server.

(I actually have three databases atm, one is the existing db used for the site (old server), the second is one that I used to test before I initially put the site live (new server), and the third is one that is for the new site about to replace the current one (new server))

After much frustration, this is how I managed to move the database over and then transfer the information I needed:

1. Create the new db (or skip this step if you are going to restore to a testing database).
2. Backup the current db from the old server and transfer to the new server
3. Through EM on the new server right click the created db>All Tasks>restore database
4. Browse to the backup of the db by selecting a new device
5. Under options choose restore over existing db and be sure to have the path and names of the mdf and ldf match what is on your server for your other databases. It will be listed with the path and names from the old server.
6. You may receive an error saying it can not import over existing files. If so then specify a directory under your current data and log directories (such as one named imported).
7. Be sure to remove the old users from the other db and add the user your cp created for the db. If objects are owned by a user on the old server you will need to change ownership over to dbo before removing the old user. If this is needed there are queries through google that will change the ownership of tables and sps through query analyizer.

How to change the database owner:
Exec sp_changeobjectowner ‘dbo12323.my_table’,’dbo’

dbo12323 = make this whatever the table currently has as the db owner
dbo = the new db owner

Now I can go ahead and move the information over to my new database.
INSERT INTO myDatabase.dbo.tbl_myTable
(field1, field2, field3)
SELECT
source1, source2, source3
FROM oldDatabase.dbo.tbl_oldTable

Posted on Leave a comment

CSS : Expanding frame using css with graphics

View the example here

This example is originally based off of the ‘Flexible CSS Teaser Box’ by 456 Bereastreet.

I have modified it to use four different corner images and four expandable side images.

The site’s frame can stretch indefinitely vertically and horizontally whereas the original had width restrictions of 1600 pixels. I do agree, however, that most cases 1600 pixels wide would be overkill.