box_return.xhs

来自「最新版 JCL+JVCL控件！非常不错的控件资源。包含了所能用到的大部分功能！」· XHS 代码 · 共 34 行

<%
  Include("intro.inc");
%>

Bo顃es non retourn閑s:
<p />

<div class="Data">
<table class="Data">
<tr>
  <th>Bo顃e</th>
  <th>Date d'emprunt</th>
  <th>Emprunteur</th>
</tr>
<tr><td align="left">
<%
  Request("SELECT * FROM boxes.xml, loans.xml, loans_box.xml, clients.xml
    WHERE (LoanId = LBLoan) AND (LBBox = BoxId) AND (LoanReturn IS NULL) AND (ClientId = LoanClient)
    ORDER BY Date(LoanDeparture) ");
  Display("templates/boxlist.tpl");
  DisplayEmpty("templates/boxlistempty.tpl");
%>
</td></tr>
</table>
</div>



<p />

<%
  Include("outro.inc");
%>