February 24th, 2010

MySQL queries to update conference descriptions

Posted on February 24th, 2010 by tom

Here are MySQL queries for my records with use of a subquery to update empty conference descriptions.

UPDATE `message` SET `content_markup` = IF( `content_markup` = '', 'uploaded files are added here', `content_markup` ), `content` = `content_markup` WHERE `id` = (SELECT `conference_message_id_files` FROM `configuration`);

UPDATE `message` SET `content_markup` = IF( `content_markup` = '', "put the topic here if it doesn't fit elsewhere", `content_markup` ), `content` = `content_markup` WHERE `id` = (SELECT `conference_message_id_general` FROM `configuration`);

UPDATE `message` SET `content_markup` = IF( `content_markup` = '', 'uploaded images are added here', `content_markup` ), `content` = `content_markup` WHERE `id` = (SELECT `conference_message_id_images` FROM `configuration`);

UPDATE `message` SET `content_markup` = IF( `content_markup` = '', 'optionally add webpages here', `content_markup` ), `content` = `content_markup` WHERE `id` = (SELECT `conference_message_id_webpages` FROM `configuration`);

Comments (0)       
Tags: mysql, sql, subquery

New World-Record Stick Bomb -- 2250 Sticks!

Posted on February 22nd, 2010 by tom

Comments (0)       
Tags: bomb, explosion, stick, tongue depressor

Entering Relative Url Change

Posted on February 3rd, 2010 by tom

The steps for entering a relative url for a message have changed. The relative url is now entered in the Add/Edit Message forms.

Comments (0)       
Tags: change, relative, url

Captcha Links

Posted on January 25th, 2010 by tom

Some time ago I did some research on the use of Captchas for my previous hosting service. Just capturing some links here for future reference.

Comments (0)       
Tags: captcha, implicit, reference

Email Discussion Message Replies

Posted on January 9th, 2010 by tom

Users of your website can now receive replies to discussion messages via email.

Comments (0)       
Tags: email, hosting, message, replies, tom's web hosting, web

Email Added/Changed Messages

Posted on January 8th, 2010 by tom

Superusers of your website can now set a permission for users to be emailed added/changed discussion messages. Check out the how tos < How To Email Added Messages > and < How To Email Changed Messages.

Comments (0)       
Tags: added, changed, email, hosting, message, tom's web hosting, web

Let It Snow!

Posted on December 29th, 2009 by tom

It's been snowing the last several hours here. It's even deeper than when I took these images several hours ago. Taken at dusk with iPhone 2 megapixel camera.

Comments (0)       
Tags: buildings, images, personal, snow, trees

<  February 2010  >
SunMonTueWedThuFriSat
 123456
78910111213
14151617181920
21222324252627
28