<?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	= "DOC04"
	title	= "バージョン差分"
	date	= "2008/10/27"
	author	= "Hiroki.Nakamura"
	text	= ""
	version	= "001"
/>

<!-- 変更はここから -->

<og:equals val1="{@VIEW}" val2="FULL" >
	<og:value command="SET" key="SQLDATA" value="a.TAGNAME,a.VALUENAME,a.REQUIRED,b.HTMLEXT,to_char(b.CONTENTS) as CONTENTS" />
</og:equals>
<og:equals val1="{@VIEW}" val2="FULL" notEquals="true" >
	<og:value command="SET" key="SQLDATA" value="a.TAGNAME,a.VALUENAME,a.REQUIRED,b.HTMLEXT" />
</og:equals>

<!-- DB検索 SQL文記述 debug="true" でSQL文を確認できます。-->
<og:query command="{@command}" debug="{@debug}" maxRowCount="{@maxRowCount}">
		select  {@SQLDATA}
		from    GF22 a left outer join GF24 b
		on      a.VERNO   = b.VERNO
		and     a.VALUENAME = b.VALUENAME
		and     a.TAGCLASS  = b.TAGCLASS
		where   a.VERNO   = '{@VERNO}'
		and     a.PRE_FIX    = '{@PRE_FIX}'
		minus
		select  {@SQLDATA}
		from    GF22 a left outer join GF24 b
		on      a.VERNO   = b.VERNO
		and     a.VALUENAME = b.VALUENAME
		and     a.TAGCLASS  = b.TAGCLASS
		where   a.VERNO   = '{@VERNO2}'
		and     a.PRE_FIX    = '{@PRE_FIX}'
		order by TAGNAME,VALUENAME
</og:query>

<!-- ColumnEditorTagを使用すると、登録画面の入力フィールドで、入力の必須状態を表したり(must="true"を使用)、 -->
<!-- DBからの検索結果を、コンボボックスでプルダウン表示させる(editor="DBMENU"を使用)ことが可能となります。 -->

<og:viewLink command="{@command}">
	<og:link column="TAGNAME" gamenId="DOC02" href="index.jsp" target="CONTENTS"
			keys="command,VERNO,TAGNAME,VIEW" vals="NEW,{@VERNO},[TAGNAME],FULL" />
	<og:link column="VALUENAME" gamenId="DOC02" href="index.jsp" target="CONTENTS"
			keys="command,VERNO,TAGNAME,VALUENAME,VIEW" vals="NEW,{@VERNO},[TAGNAME],[VALUENAME],FULL" />
</og:viewLink>

<!-- DB検索結果を表示させます。 -->
<og:view
	viewFormType = "HTMLTable"
	command 	 = "{@command}"
	checked      = "{@checked}"
	startNo      = "{@startNo}"
	pageSize     = "{@pageSize}"  />

<!-- ここまで。 -->
	<jsp:directive.include file="/jsp/common/htmlend.jsp" />
</jsp:root>
