<?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="query" />
<jsp:directive.include file="/jsp/custom/query_info.jsp" />
<og:comment
	system	= "GF:エンジンサンプル"
	pgid	= "GF7070"
	title	= "Valueタグ"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>
<form method="GET" action="forward.jsp" target="RESULT" onSubmit="timeSet();">
<table summary="layout" >
<tr>
	<og:select name="TABLE_NAME" multiple="true">
		<og:queryOption>
			select TABLE_NAME,NAME_JA from GF02
			where SYSTEM_ID='GF' AND  FGJ in ('0','1') AND TBLSYU='D'
			order by TABLE_NAME
		</og:queryOption>
	</og:select>
	<og:select name="TABLE_NAME" multiple="true">
		<og:queryOption>
			select TABLE_NAME,NAME_JA from GF02
			where SYSTEM_ID='GF' AND  FGJ in ('0','1') AND TBLSYU='D'
			order by TABLE_NAME
		</og:queryOption>
	</og:select>
	<og:value command="SQL" action="ROW_APPEND">
		select TABLESPACE_NAME from GF01
		where SYSTEM_ID='GF' AND  FGJ in ('0','1') AND TBLSYU='D'
		group by TABLESPACE_NAME
		order by TABLESPACE_NAME
	</og:value>
	<og:column name="TABLESPACE_NAME" value="{@TABLESPACE_NAME}" />
</tr>
<tr>
	<og:column name="TABLE_NAME"  />
	<og:column name="TABLE_NAME"  />
	<og:column name="TABLE_NAME"  />
</tr>
<tr>
	<og:column name="EXEC_VAL" value="Math.sin(30 * (Math.PI / 180))" />
	<og:column name="CASE_VAL" value="B" />
	<og:column name="CASE_FRM" value="A:1 B:2 C:3 D:4" />
</tr>
<tr>
	<og:column name="TM_FROM" value="{@DATE.HMF}" />
	<og:column name="TM_TO"   value="24:00" />
	<og:column name="TM_SKIP" value="45" />
</tr>
</table>

<og:queryButton />
</form>

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