[SOLVED] Dropdown menu linked to events from JEvents DB

Question

Hi All!I try to include a dropdown menu to my chronoform parsed the list of the future events from JEvents component's DB like the module "JEvents latest" does.I've find the string that may to display the format I need:${eventDate}[!a:-${endDate(%H:%M)}]|${title}However I'm not sure that it's possible to use this JE variables globally in Joomla.The second way is to query from jos_jevents_vevdetail the values directly. I need 2 values: dtstart (start time) and summary (as the title). And I need to organize all of them to the string of dropdown menu like "5/12/2010, 11:00 - Title".But I can't understand:[list]how to build a dropdown used this string or values?how to query only the future events from DB jos_jevents_vevdetail to dropdown menu sorted from earlier to latest?and how to submit to CF form only the date and title values in one phrase ("5/12/2010 - Title", for example)?[/list]I'm not a coder, so I've try to find something similar here. But I haven't the result.There are tree files of "JEvents Latest" module that can query and display the data using format that I need:mod_latestnews.phphelper.phpget('id');

$count		= (int) $params->get('count', 5);
		$catid		= trim( $params->get('catid') );
		$secid		= trim( $params->get('secid') );
		$show_front	= $params->get('show_front', 1);
		$aid		= $user->get('aid', 0);

$contentConfig = &JComponentHelper::getParams( 'com_content' );
		$access		= !$contentConfig->get('show_noauth');

$nullDate	= $db->getNullDate();

$date =& JFactory::getDate();
		$now = $date->toMySQL();

$where		= 'a.state = 1'
			. ' AND ( a.publish_up = '.$db->Quote($nullDate).' OR a.publish_up Quote($now).' )'
			. ' AND ( a.publish_down = '.$db->Quote($nullDate).' OR a.publish_down >= '.$db->Quote($now).' )'
			;

// User Filter
		switch ($params->get( 'user_id' ))
		{
			case 'by_me':
				$where .= ' AND (created_by = ' . (int) $userId . ' OR modified_by = ' . (int) $userId . ')';
				break;
			case 'not_me':
				$where .= ' AND (created_by  ' . (int) $userId . ' AND modified_by  ' . (int) $userId . ')';
				break;
		}

// Ordering
		switch ($params->get( 'ordering' ))
		{
			case 'm_dsc':
				$ordering		= 'a.modified DESC, a.created DESC';
				break;
			case 'c_dsc':
			default:
				$ordering		= 'a.created DESC';
				break;
		}

if ($catid)
		{
			$ids = explode( ',', $catid );
			JArrayHelper::toInteger( $ids );
			$catCondition = ' AND (cc.id=' . implode( ' OR cc.id=', $ids ) . ')';
		}
		if ($secid)
		{
			$ids = explode( ',', $secid );
			JArrayHelper::toInteger( $ids );
			$secCondition = ' AND (s.id=' . implode( ' OR s.id=', $ids ) . ')';
		}

// Content Items only
		$query = 'SELECT a.*, ' .
			' CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,'.
			' CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug'.
			' FROM #__content AS a' .
			($show_front == '0' ? ' LEFT JOIN #__content_frontpage AS f ON f.content_id = a.id' : '') .
			' INNER JOIN #__categories AS cc ON cc.id = a.catid' .
			' INNER JOIN #__sections AS s ON s.id = a.sectionid' .
			' WHERE '. $where .' AND s.id > 0' .
			($access ? ' AND a.access setQuery($query, 0, $count);
		$rows = $db->loadObjectList();

$i		= 0;
		$lists	= array();
		foreach ( $rows as $row )
		{
			if($row->access link = JRoute::_(ContentHelperRoute::getArticleRoute($row->slug, $row->catslug, $row->sectionid));
			} else {
				$lists[$i]->link = JRoute::_('index.php?option=com_user&view=login');
			}
			$lists[$i]->text = htmlspecialchars( $row->title );
			$i++;
		}

return $lists;
	}
}
mod_latestnews.xml

Latest News
	Joomla! Project
	July 2004
	Copyright (C) 2005 - 2010 Open Source Matters. All rights reserved.
	http://www.gnu.org/licenses/gpl-2.0.html GNU/GPL
	admin@joomla.org
	www.joomla.org
	1.5.0
	DESCLATESTNEWS
	
		mod_latestnews.php

Recently Added First
			Recently Modified First

Anyone
			Added or modified by me
			Not added or modified by me

show
			hide

Use global
			No caching

I understand that there are the some answers in this files, but can't to find this answers.May be anybody has an experience of using JEvents or something similar with Chronoforms?Please, help me to find the example (if anybody have see this one) or show me how to do, if it's possible.