- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
try this
<TABLE>
<TBODY>
<TR>
<TH align=left>Code</TH>
<TH>Description</TH></TR><%
var query = xtk.queryDef.create(
<queryDef schema="ssg:purchase" operation="select" distinct="true">
<select>
<node expr="@code" alias="code"/>
<node expr="@desc" alias="desc"/>
</select>
</queryDef>
).ExecuteQuery();
for each (var record in query )
{
vars.code=record.code;
vars.desc=record.desc;
%>
<TR>
<TD><%= vars.code %></TD>
<TD><%= vars.desc %></TD></TR><%
}
%> </TBODY></TABLE>Thanks,
David