Hope someone can help me with this:
I'm using MvDO to execute a .mvc module but the global result g.zone is null.
This is the MvDO in my template:
<mvt:item name="toolkit" param="sassign|zoneZIP|015" />
<MvDO FILE="zone1.mvc" >
<mvt:if expr="isnull g.zone">zone is null<br></mvt:if>
"zone is null" is being displayed after the MvDO is executed. A variable display of g.zone shows it to be null also.
This is the .mvc file "zone1.mvc":
<mvopen
NAME="zones"
DATABASE="devpark_mm5"
TYPE="MYSQL"
username="username"
password="password">
<MvASSIGN NAME = "g.zone" VALUE = "{ 'not found' }">
<MvOPENVIEW NAME = "zones"
VIEW = "result"
QUERY="{ 'SELECT zone FROM zones where ' $g.zoneZIP $ ' >= lowzip AND ' $g.zoneZIP $' <= hizip' }">
<MvIF EXPR = "{ NOT g.MvOPENVIEW_Error }">
<MvASSIGN NAME = "g.zone" VALUE = "{ result.d.zone }">
<MvCLOSEVIEW NAME = "zones" VIEW = "result">
</MvIF>
Thanks, Larry
I'm using MvDO to execute a .mvc module but the global result g.zone is null.
This is the MvDO in my template:
<mvt:item name="toolkit" param="sassign|zoneZIP|015" />
<MvDO FILE="zone1.mvc" >
<mvt:if expr="isnull g.zone">zone is null<br></mvt:if>
"zone is null" is being displayed after the MvDO is executed. A variable display of g.zone shows it to be null also.
This is the .mvc file "zone1.mvc":
<mvopen
NAME="zones"
DATABASE="devpark_mm5"
TYPE="MYSQL"
username="username"
password="password">
<MvASSIGN NAME = "g.zone" VALUE = "{ 'not found' }">
<MvOPENVIEW NAME = "zones"
VIEW = "result"
QUERY="{ 'SELECT zone FROM zones where ' $g.zoneZIP $ ' >= lowzip AND ' $g.zoneZIP $' <= hizip' }">
<MvIF EXPR = "{ NOT g.MvOPENVIEW_Error }">
<MvASSIGN NAME = "g.zone" VALUE = "{ result.d.zone }">
<MvCLOSEVIEW NAME = "zones" VIEW = "result">
</MvIF>
Thanks, Larry
Comment