<?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	= "GF6090"
	title	= "棒グラフ"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>
<form method="GET" action="forward.jsp" target="RESULT" onClick="timeSet();">

<!-- 変更はここから -->
<table summary="layout" >
<tr>
	<og:select name="YEAR" must="true">
		<og:queryOption>
			<jsp:text>select YEAR from GF43 group by YEAR order by YEAR DESC</jsp:text>
		</og:queryOption>
	</og:select>

	<og:select name="BLOCK" >
		<og:option value=""  lbl="" />
		<og:queryOption>
			<jsp:text>select BLOCK from GF43 group by BLOCK order by BLOCK</jsp:text>
		</og:queryOption>
	</og:select>
	<og:space />

	<og:select name="ORDER_BY" lbl="ORDER_BY">
		<og:option value=""              lbl=""               />
		<og:option value="SALES DESC"    lbls="SALES,DESC"    />
		<og:option value="AMOUNT DESC"   lbls="AMOUNT,DESC"   />
		<og:option value="PROFIT DESC"   lbls="PROFIT,DESC"   />
		<og:option value="PROFIT"        lbl="PROFIT"         />
		<og:option value="BRANCH"        lbl="BRANCH"         />
	</og:select>
</tr>
</table>
<og:queryButton />
</form>

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