<?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	= "GF6270"
	title	= "EXCEL出力"
	date	= "2015/05/09"
	author	= "K.Hasegawa"
	text	= ""
	version	= "001"
/>

<script type="text/javascript" >
	function getO( id ) {
		var obj = document.getElementById( id );
		if( obj != null ) { return obj; }
		else {
			var nms = document.getElementsByName( id );
			if( nms != null &amp;&amp; nms.length &gt; 0 ) {
				return nms.item(0);
			}
		}
		return null;
	}

	function setV( id , v ) {
		var obj = getO( id );
		if( obj != null ) { obj.value = v ; }
	}

	function getV( id ) {
		var obj= getO( id );
		return (obj == null ) ? '' : obj.value;
	}
</script>

<form method="POST" action="forward.jsp" target="RESULT" onClick="timeSet();">
	<og:fieldset lbl="MSG0032" defaultNone="false">
	<table>
	  <tr>
		<td><b>SQL</b><br /><br />
			<span onClick="setV('INSQL','');getO('INSQL').focus();"><og:message lbl="CLEAR" /></span><br />
			<span onClick="clipboardData.setData('Text', getV('INSQL'));">Ctrl-C</span>
		</td>
		<td><textarea name="SQL" rows="6" cols="60" rtc="false"><og:text>{@USER.LASTSQL}</og:text></textarea>
		</td>
		<td>
			<table>
				<tr><og:column name="DBID"	value="{@DBID}" codeKeyVal="{@DBID_INFO}" /></tr>
				<tr><og:select name="headerSequence" lbl="MSG0027" size="4" multiple="multiple">
						<og:option value="N" lbl="Name"  selected="selected" />
						<og:option value="L" lbl="Label" selected="selected" />
						<og:option value="S" lbl="Size"                      />
						<og:option value="C" lbl="Class"                     />
						<og:option value="-" lbl="----"  selected="selected" />
						<og:option value="D" lbl="Data"  selected="selected" />
					</og:select>
				</tr>
			</table>
		</td>
	  </tr>
	</table>
	</og:fieldset><br />
	<jsp:directive.include file="optionQuery.jsp" />

	　　　　　　　　　　　　　　　　　　　　　　　　
	<og:submit value="fileInExcel" lbl="EXCEL_IN" command="NEW" />

	<og:queryButton />
</form>

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