db-table-data.adp

Delivered as text/html

Related Files

[ hide source ] | [ make this the default ]

File Contents

<master>
<property name="title">Table Data Explorer - Table: "@t@"</property>
<property name="show_title">1</property>
<property name="header_css">
	stylesheet text/css /resources/ajaxhelper/yui/menu/assets/skins/sam/menu.css all
</property>

<property name="header_js">
	text/javascript javascript /resources/ajaxhelper/yui/yahoo-dom-event/yahoo-dom-event.js
	text/javascript javascript /resources/ajaxhelper/yui/container/container_core-min.js
	text/javascript javascript /resources/ajaxhelper/yui/menu/menu-min.js 
</property>



<script type="text/javascript">

<multiple name="fk_references">
	
	function show_@fk_references.column@Menu (column_value, id) {
			var oMenu_id = new YAHOO.widget.Menu(id + "-menu"); 
			
			oMenu_id.clearContent();
			<group column="column">
			oMenu_id.addItem(
				{text: "@fk_references.ref_table@(@fk_references.ref_column@)", url: "db-table-data?t=@fk_references.ref_table@&where=@fk_references.ref_column@%3d%27"+ column_value + "%27" }	
				);
			</group>
			
			oMenu_id.setItemGroupTitle("This value is used as foreign-key in:", 0);
			oMenu_id.showEvent.subscribe(function () {
		
		           this.focus();
		       
		       });
	
			oMenu_id.render(id);
		oMenu_id.show();
	}
</multiple>

</script>

<div class="yui-skin-sam">
    <h1 class="page-title" style="margin-bottom:15px;background-color:#C6B5A4;">Data in @relkind_pretty@: "@t@" (@table_rows@ rows total)</h1>
    
    <div>
    	<div style="float:left;border-right:1px dashed #000000;margin-right:10px;">
    		<b>Restrict output</b>
    		<formtemplate id="restrictions"></formtemplate>
    	</div>
		<div>
			    <p style="margin-top:10px;"><b>View <a href="db-table-info?table=@t@">@relkind_pretty@ Definition</a></b></p>

		</div>
    </div>
    
    <div style="clear:both;border-top:1px dashed #000000;margin-bottom:10px;"></div>
    <div class="form-help-text" style="margin-bottom:20px;"><img src="/shared/images/info.gif" width="12" height="9" alt="[i]" title="Help text" border="0">
       FK: This value is a foreign-key. Click to look up this value;<br>
       RFK: This value is used as a foreign-key in an other table. Click for a list of all tables using this value.  
                </div>
 
    	<listtemplate name="table"></listtemplate>

</div>