I'm using custom field meta (boolean) to tag posts for display on the front page. (with the help of Custom Field GUI)
For doing so, I copied the code for an alternative loop as described in this post. This worked out better than other solutions I've read of, I can even continue using template tags!
Sadly, the single template tag not being display is the_content();! I suppose this has something to do with the database query, but that's just a guess. Is there any way to make this display the_content();?
$customkey = 'Main'; // set to your custom key
$my_posts = $wpdb->get_results("SELECT * FROM $wpdb->posts, $wpdb->postmeta WHERE ID = post_id AND meta_key = '$customkey' ORDER BY post_date DESC LIMIT 1");
foreach($my_posts as $post) :
<!-- my template here -->
<?php endforeach; ?>
Edit: Sorry, I just realized, the original post is only a week old. You can probably still post there.