<?xml version="1.0" encoding="UTF-8" ?>
<jsp:root
	xmlns:jsp="http://java.sun.com/JSP/Page"
	xmlns:og="hybs-taglib.tld"
	version="2.0">
<jsp:directive.page language="java" contentType="text/html; charset=UTF-8" />

<og:head headType="result" />
<!--
<jsp:directive.include file="/jsp/custom/result_info.jsp" />
-->
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF6160"
	title	= "タブリンク"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<og:errorMessage command="{@command}" clear="{@clear}" displayMsg="{@displayMsg}" />
<og:columnCheck command = "{@command}" />
<og:entry command = "{@command}"  />

<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
		select	A.MGR,A.JOB,A.EMPNO,A.ENAME
			,	A.SAL,A.COMM,A.HIREDATE,A.DEPTNO,B.DNAME,B.LOC
		from EMP A inner join DEPT B
		on	A.DEPTNO = B.DEPTNO
	<og:where>
		<og:and value = "A.MGR  =  {@MGR} " />
	</og:where>
		ORDER BY A.MGR
</og:query>

<og:viewLink command="{@command}">
	<og:link column="MGR" gamenId="GF6050" href="index.jsp" target="CONTENTS"
		keys="command,MGR"
		vals="NEW,[MGR]" />
</og:viewLink>

<form method="POST" action="forward.jsp" target="RESULT">

<og:view
	viewFormType = "HTMLTable"
	noMessage	 = "true"
	command		 = "{@command}"/>

</form>

<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
