evolution creations

Lets say you want to create a subdomain, and then route it to a completely different webpage after a predefined length of time, but you want it to execute the Google Analytic code to be able to then track the transaction. How do you do that?

http://evolutioncreations.wik.is/Ubuntu/FAQ’s/Apache2/Refreshing_HTML_Page_and_Google_Analytics_Integration

New WIKI!

2 years ago

by george in Thoughts

For awhile now I’ve been adding technical docs to this blog in attempt to both retain knowledge that I find over the ages, but also to share with the wider community and partipate in the conversation.

In an effort to better facilitate this, I have a new Deki wiki solution that will be used to house all the existing articles, as well as future articles. I hope that you find this a better solution as I have found so myself and participate in the wiki to make it better!

http://wiki.evolutioncreations.com/

Update and append to end of string in MSSQL

2 years ago

by george in How-to

How do you take a string in an MSSQL table and append another string to the end of it? To do this, you can run a bit of SQL such as:

update tablename set Columnname = Columnname + ‘newstring’ where id = X

So if you are say updating a column that is a URL and you want all instances in the table to receive a new value at the end of the URL, your query might look like:

update url_table set urlfield = urlfield + ‘&additionalfield=true’

Rob Thomas – Little Wonders

2 years ago

by george in TV & Movies

This has to be one of my favorite songs from my all time favorite movie, Meet the Robinsons.

T.I. Road to Redemption – A surprising production from MTV

2 years ago

by george in TV & Movies

Once in a while, a TV station like MTV who has previously been known to do nothing but reality shows that are geared to the lowest common denominator and of the poorest taste considering the day and age that we live in, will break through and provide something to the viewing audience that really shows that it’s a station that not only has star power through it’s ability to command any Hollywood star, but also to leverage those contacts to produce something really worthwhile.

I don’t say this often, as I have come to think of MTV as the filth that has become the degeneration of our generation and future generations to come, but there is a new show that my wife DVR’ed the other day that I reluctantly watched today, that is T.I.’s Road to Redemption.

What makes this interesting is the story behind this series. Apparently T.I. was brought to trial by the ATF for possession of weapons that were in violation of his previous felony conviction. With this, if the Federal government won a conviction, he could face up to 30 years in prision for those possessions. Apparently he made a deal with them that before March/2009, he would complete 1000 hours of community service–if he was able to do this, he would only face 1 year and 1 day in prison–if he failed to do so, he could face the full term. Obviously it doesn’t take a brain surgeon to know that the decision he made was clearly the best one, but wasn’t so obvious was his move to have MTV produce a show where he goes after 7 teens at risk to the streets and to help them understand what they are doing and the life that they can come to expect.

I have to admit, although I don’t agree with T.I.’s life decisions, to take the extra time on top of his 1000 hours of community service, to help these troubled kids, really gives me hope that Hollywood hasn’t been completely lost to the scum that is what we believe it to be. With people who are too into themselves and what’s in it for them, instead of looking out and using their star power and influence to help those who would be their fans and people who can be influenced by direct interactions with them.

I’ll be interested to see how things progress in the future shows, but for now after watching the first episode, I am impressed and give T.I. credit where credit is due for the work that he is doing. If he is able to complete this community service and have any impact on the kids he is helping, that should earn him a pass to get out of jail free. That is more than what you can say others in similar positions in either Music or Film have done for kids who are clearly at risk.

Error when installing SQLTools

3 years ago

by george in How-to

When you first install SQLTools, you receive an error message:

SQLTools.exe – Unable to Locate Component

This application has failed to start because OCI.dll was not found. Re-installing the application may fix this problem.

To fix this, you will need to install Oracle Client 10g Express Client. Once this is installed, you’ll need to try to launch SQLTools and it should open for you then.

Inserting string with an Apostrophe in MSSQL

3 years ago

by george in How-to

When you try to use an insert statement in MSSQL and the string contains an apostrophe, such as:

insert into test_table set destinationfield = ‘Sometime’s’ where id = 1

Obviously test_table equals the table that holds the data, destinationfield equals the field in the table that is going to get updated, and id would equals the unique identifier of the row that is going to be changed. When you try and run this you will always get a SQL error. To get around this, you want to use double quotes:

insert into test_table set destinationfield = ‘Sometime”s’ where id = 1

You’ll notice that in the first example there is only one single quote at the end of the string. Just adding another single quote will allow the insert to go through.