i tried your solution without success.
can you post the exact code? did you put it in the node template?

I couldn't get a very overview of what you're working towards. Wouldn't views be more appropriate for collating the fields from various content types? You can also fuse views for more complex aggregates.

I was trying to get a CCK node-reference loaded into a separate block on the page and was having a tough time until I found your post. I'm just starting so (node_build_content) was the key. If there is a more efficient way of doing this, then maybe someone else will update this thread.

I am trying to display the title of a node referenced node using your technique. I node reference a location_type from another CCK node type and then use a computed field to compute the title of the location type node that I selected.

$item_nid = $node->field_location_type[0]['nid'] ;
$item_node = node_load($item_nid);
$item_node = node_build_content($item_node);
$item_desc = $item_node->field_title[0]['value'];
$node_field[0]['value'] = "title = " . $item_desc;

The display that I get is ...  title =

I can confirm that item_nid is returning the correct node. That content type only has a title field, and no other fields.

I tried using both

$item_desc = $item_node->field_title[0]['value'];

and

$item_desc = $item_node->field_title[0]['view'];

with the same results.

Any idea where I might be going astray?

Your help is appreciated.

Is there any way you could retrieve the filepath field of an image using your method?
I'm using imagefield to upload images into my node, I just can't find a way to retrieve the filepath of the image when I'm using views.

** bookmark **

This works for me:

Inside node.tpl.php, OR node-TYPE.tpl.php

Where: field_FIELDNAME = the nodereference field you want to retrieve entries from. To locate this, print_r($node) so you can see what the field is called.

<?
	/* Setup Variables — this isn't needed if this code is inside node.tpl.php */
	//$field_FIELDNAME = $node->field_FIELDNAME;
	/* - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
	 * loop through all node-reference related items and print a list */
	if ($field_FIELDNAME[0]['nid']) {
	print "<h3>" . t("Related Items") . "</h3>";
	print "<ul>";
	foreach ($field_FIELDNAME as $value) {
			$value2 = node_load($value[nid]);
			$nodetoview = $value2;
			print "<li>";
			print "<strong>" . $nodetoview->title . "</strong>";
			print node_view($nodetoview,$teaser = FALSE, $page = True, $links = FALSE);
			print "</li>";
		}
		print "</ul>";
	}		

?>

----
For Keyword Searching:
Load node referenced nodes, view nodereference nodes, load referenced node

Subscribing!

Great thread. But did anyone answer the original posters question about the overhead? I am interested in that as well.

function custom_misc_retrieve_single_field($nid, $field) {
$query = db_select('field_revision_' . $field, 'f');
$query
->condition('f.entity_id', $nid)
->fields('f', array($field . '_value'))
->orderBy('revision_id', 'DESC')
->range(0, 1);
$result = $query->execute()->fetchCol();
return $result[0];
}

Hey guys. This does not work on Drupal 7/Contemplate 7.x-1.0.

How do you print node reference field values on D7?