<!--#include file="../../owFunctions/I_GeneralFunctions.asp"-->
<!--#include file="../header.asp"-->
<%
	'************************************************************************************
	'*																					*
	'*	MODIFICATION TO THIS SCRIPT OR ANY FILES INCLUDED WITH 							*
	'*		ONEWORLDSTORE IS DONE AT YOUR OWN RISK!										*
	'*	Product  : OneWorldStore														*
	'*	Version  : 9.0000																*
	'*	Modified : June 2004															*
	'*	Copyright:	Copyright (C) 2004 OneWorldStore.Com								*
	'*				Registration Number: 1024507										*
	'*				http://strategis.ic.gc.ca/											*
	'*																					*
	'************************************************************************************

	
	%>
	<script language = "javascript">
		
		function ColumnOn(sStyle)
		{
			sStyle.background	= "#F5C058";
		}
		function ColumnOff(sStyle)
		{
			sStyle.background	= "#C3DAF9";
		}
		
		function ColumnDataOn(sStyle)
		{
			sStyle.background	= "#EAF1F9";
		}
		function ColumnDataOff(sStyle)
		{
			sStyle.background	= "#FFFFFF";
		}
		
		function SubmitForm(sSQLText){

			document.RunSQL.sSQLText.value = sSQLText;
			document.RunSQL.submit();

		}
		
	</script>
	<body style="font-family: Arial; font-size: 11px" topmargin="0" leftmargin="0" bgcolor=C3DAF9>
		<table width=100% height=100% cellpadding=0 cellspacing=0 border=0>
			<tr>
				<td align=center valign=center>
					<table border="0" cellpadding="0" cellspacing="10" style="font-size: 11px;" bgcolor=FFFFFF>
					<form method="post" action="owGenericSqlExec.asp" name="RunSQL">
						<tr>
							<td align=center bgcolor=EAF1F9>
								<b><%=LANG_DT( "SQLUTILITY_HEAD", "Pre-Generated SQL Queries" )%></b>
							</td>
						</tr>
						<tr>
							<td>
								<table style="font-size: 11px;  border-right: 1 solid #aaaaaa; border-left: 1 solid #aaaaaa;" width=100%>
									<tr>
										<td colspan=2>
											Click "List" to run one of these pre-generated SQL queries.
										</td>
									</tR>
									<tr onMouseOver="ColumnDataOn(this.style);" onMouseOut="ColumnDataOff(this.style);"> 
										<td align=center><input type='button' value=' List Payments ' onClick='SubmitForm("SELECT * FROM payments");'></td>
									</tr>
									<tr onMouseOver="ColumnDataOn(this.style);" onMouseOut="ColumnDataOff(this.style);"> 
										<td align=center><input type='button' value=' List Shipments ' onClick='SubmitForm("SELECT * FROM shipments");'></td>
									</tr>
								</table>
							</td>
						</tr>
						<tr>
							<td>
								Or, enter your own SQL Query in the form below and click the "Run Query" button.
							</td>
						</tR>
						<tr>
							<td>
								<p><%=LANG_DT( "SQLUTILITY_SQLQ", "SQL Query" )%><br>
								<textarea name="sSQLText" cols="60" rows="5"></textarea></p>
								<p><input type="submit" name="Submit" value=" <%=LANG_DT( "SQLUTILITY_RUN", " Run Query " )%> "></p>
							</td>
						</tr>
					</form>
					</table>
				</td>
			</tr>
		</table>
		<!--#include file="../footer.asp"--> 