Friday, 07 November 2008

Too much email

Sat 08 Nov 08 00:00 Attention: open in a new window. PDF | Print | Email Tips and Tricks Brian Teeman
email

There are many different approaches to keeping your email inbox under control. Personaly I always try to answer emails as they arrive as I fear that if I let them stack up I will never answer them.

Today I was pointed to a slightly different approach, although perhaps recipients of my email replies might feel that I have always used it.

two.sentenc.estwo.sentenc.es

"Treat all email responses like SMS text messages, using a set number of letters per response. Since it’s too hard to count letters, we count sentences instead."

Yes, I know I said that creative domain names were a bad idea but in this case I am prepared to eat my words.




Denver to build a snowman

Fri 07 Nov 08 12:40 Attention: open in a new window. PDF | Print | Email Across the globe Brian Teeman

Going to DenverI'm reliably informed that there will be snow in Denver between December 4th & 5th so if you want to help me build a snowman, or just share a beer or three, come along to CMS ExpoCMS Expo.

There's going to be a big crowd of Joomla gurus, pros and fanboys there so why not pack your bag and jump on a plane and join us.

If the event is anything like Chicago back in May 2008 it's going to be  great time.




Search and Replace

Fri 07 Nov 08 00:00 Attention: open in a new window. PDF | Print | Email Tips and Tricks Brian Teeman

correcting textThis post is here because in the last 3 weeks I must have googled for the answer about 5 times.

How do you search and replace a word in a database using phpMyAdmin?

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

So if I wanted to change every occurance of "joomla" to "Joomla!" in the articles of this site I would use the query window of phpMyAdmin and type

UPDATE jos_content SET introtext=REPLACE(introtext,'joomla','Joomla!');