Рано обрадовался

Sanja v.2 06.08.2003 13:45

^MAIN:dbconnect{
	$sqlpage[^table::sql{
		SELECT 
			site_content.id,  
			site_content.doc_id,  
			site_content.page_title,  
			site_content.page_body,  
			site_content.is_code,  
			site_content.keywords,  
			site_content.description,  
			site_content.add_css,  
			site_content.allow_robots,  
			site_content.template,  
			site_content.revision,  
			site_content.notes,  
			site_content.author,  
			site_content.ipaddr,  
			site_doctree.doc_id, 
			site_doctree.orderidx,  
			site_doctree.parent_id,  
			site_doctree.thread_id,  
			site_doctree.is_locked,  
			site_doctree.lang,  
			site_doctree.filename,  
			site_doctree.fullpath,  
			site_doctree.itemtype,  
			site_doctree.is_deleted,  
#			site_doctree.notes,  
			site_doctree.access,  
#			site_doctree.author,  
#			site_doctree.ipaddr,  
			site_doctree.in_menu,  
			site_doctree.is_cached
		FROM site_content, site_doctree WHERE site_doctree.doc_id = site_content.doc_id AND
		site_doctree.fullpath = "${uri}"	AND
		site_doctree.lang = "${page_lang}"
		ORDER BY site_content.revision DESC
	}[$.limit(1)]]
}

^sqlpage.count[]

^rem{$sqlpage.id <br>
$sqlpage.doc_id <br>
$sqlpage.page_title <br>
$sqlpage.page_body <br>
$sqlpage.is_code <br>
$sqlpage.keywords <br>
$sqlpage.description <br>
$sqlpage.add_css <br>
$sqlpage.allow_robots <br>
$sqlpage.template <br>
$sqlpage.revision <br>
$sqlpage.notes <br>
$sqlpage.author <br>
$sqlpage.ipaddr <br>
$sqlpage.doc_id <br>
$sqlpage.orderidx <br>
$sqlpage.parent_id <br>
$sqlpage.thread_id <br>
$sqlpage.is_locked <br>
$sqlpage.lang <br>
$sqlpage.filename <br>
$sqlpage.fullpath <br>
$sqlpage.itemtype <br>
$sqlpage.is_deleted <br>
$sqlpage.notes <br>
$sqlpage.access <br>
$sqlpage.author <br>
$sqlpage.ipaddr <br>
$sqlpage.in_menu <br>
$sqlpage.is_cached <br>
}

Код в SQLFront выполняется на ура, выборка делается расчудесно. Только вот если убрать ^rem{}, Parser начнёт вякать про "column not found". Как так не found, если есть она, в MySQLFront своими глазами вижу! "SELECT site_content.id AS id" не помогает - всё то же column not found.

---