<% Else %>
  <!--webbot bot="DatabaseRegionStart" s-columnnames="JobNumber,WorkType,WorkDate,StartTime,PayrollNumber,BoxNumber,Hours,Quantity" s-columntypes="200,200,135,200,200,3,5,5" s-dataconnection="BureauManagerSQL" b-tableformat="FALSE" b-menuformat="FALSE" s-menuchoice="JobNumber" s-menuvalue="JobNumber" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="FALSE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns="JobNumber,WorkType,WorkDate,StartTime,PayrollNumber,BoxNumber,Hours,Quantity" s-criteria s-order s-sql="SELECT<br>  JobNumber,<br>  WorkType,<br>  WorkDate,<br>  CONVERT(VARCHAR, StartTime, 108) AS StartTime,<br>  PayrollNumber,<br>  BoxNumber,<br>  Hours,<br>  Quantity<br>FROM<br>  WorkDetails<br>WHERE<br>  JobNumber = '::JobNumber::' AND<br>  PayrollNumber = '::PayrollNumber::' AND<br>  WorkDate = '::WorkDate::' AND<br>  CONVERT(VARCHAR, StartTime, 108) =  CONVERT(VARCHAR, CAST('::StartTime::' AS DATETIME), 108)<br>" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="JobNumber=&amp;PayrollNumber=&amp;WorkDate=&amp;StartTime=" s-norecordsfound="No Work item Found" i-maxrecords="256" i-groupsize="0" botid="18" u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00"><font color="#000000">This is the start of a Database Results region.</font></td></tr></table>" startspan b-WasTableFormat="FALSE" b-ReplaceDatabaseRegion="FALSE" --><!--#include file="../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT   JobNumber,   WorkType,   WorkDate,   CONVERT(VARCHAR, StartTime, 108) AS StartTime,   PayrollNumber,   BoxNumber,   Hours,   Quantity FROM   WorkDetails WHERE   JobNumber = '::JobNumber::' AND   PayrollNumber = '::PayrollNumber::' AND   WorkDate = '::WorkDate::' AND   CONVERT(VARCHAR, StartTime, 108) =  CONVERT(VARCHAR, CAST('::StartTime::' AS DATETIME), 108) "
fp_sDefault="JobNumber=&PayrollNumber=&WorkDate=&StartTime="
fp_sNoRecords="No Work item Found"
fp_sDataConn="BureauManagerSQL"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="JobNumber"
fp_sMenuValue="JobNumber"
fp_sColTypes="&JobNumber=200&WorkType=200&WorkDate=135&StartTime=200&PayrollNumber=200&BoxNumber=3&Hours=5&Quantity=5&"
fp_iDisplayCols=8
fp_fCustomQuery=True
BOTID=18
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="21647" -->       
<%
	JobNumber = FP_FieldVal(fp_rs,"JobNumber")
	WorkType = FP_FieldVal(fp_rs,"WorkType")
	WorkDate = FP_FieldVal(fp_rs,"WorkDate")
	StartTime = FP_FieldVal(fp_rs,"StartTime")
	PayrollNumber = FP_FieldVal(fp_rs,"PayrollNumber")
	BoxNumber = FP_FieldVal(fp_rs,"BoxNumber")
	Hours = FP_FieldVal(fp_rs,"Hours")
	Quantity = FP_FieldVal(fp_rs,"Quantity")
	
%>

<!--webbot bot="atabaseRegionEnd" b-tableformat="FALSE" b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="BODY" preview="<table border=0 width="100%"><tr><td bgcolor="#FFFF00" align="left"><font color="#000000">This is the end of a Database Results region.</font></td></tr></table>" startspan --><!--#include file="../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="atabaseRegionEnd" endspan i-checksum="65064" -->

<% End If %>

<% If JobNumber = 0 Then %>

<p>
fp_sQry="SELECT JobNumber,   WorkType,   WorkDate,   StartTime,   PayrollNumber,   BoxNumber,   Hours,   Quantity FROM   WorkDetails WHERE   JobNumber = '<%= Request("JobNumber") %>' AND   PayrollNumber = '<%= Request("PayrollNumber") %>' AND   WorkDate = '<%= Request("WorkDate") %>' AND   StartTime = '<%= Request("StartTime") %>' "
</p>

<% Else %>