table menu

Scar.kz 10.03.2009 13:31 / 10.03.2009 14:20

$xml[^xdoc::create{<?xml version="1.0" encoding="WINDOWS-1251"?>
  <companylist>
   <branch>$comn.branch</branch>
   <comn>$comn.comn</comn>
   <cid>$cid</cid>
^complist.menu{
   <fil>
     <dest>$complist.dest</dest>
^dislist.menu{^if($dislist.cid eq $complist.cid){
	<di>
	  <disn>$dislist.disn</disn>
	  <did>$dislist.did</did>
	</di>}}
^ms.menu{^if($ms.cid eq $complist.cid){
	<mi>
	  <name>$ms.name</name>
	  <linen>$ms.linen</linen>
	  <line>$ms.line</line>
	  <msid>$ms.msid</msid>
	</mi>}}
</fil>
}
</companylist>
}]

выдает ошибку у ^ms.menu:

'menu' junction may not be overwritten with junction, store it to variable instead.

Если убрать <line>$ms.line</line> - то все работает. Где грабли?

вот собственно таблицы:

$comn[^MAIN:oSql.table{SELECT comn, branch, city FROM com WHERE cid=$cid}]
$complist[^MAIN:oSql.table{SELECT cid, dest FROM com WHERE comn='$comn.comn'}]
$ms[^MAIN:oSql.table{SELECT  a2.cid, a1.msid, a3.line, a4.name, a3.linen FROM cms AS a1, line as a3, com as a2, ms as a4 WHERE a1.msid=a4.msid and a4.line=a3.line and a1.cid=a2.cid and a2.comn='$comn.comn'}]
$dislist[^MAIN:oSql.table{SELECT a2.cid, a1.did, a4.disn FROM cdis AS a1, com as a2, dis as a4 WHERE a1.did=a4.did and a1.cid=a2.cid and a2.comn='$comn.comn'}]

---