[Zope] 2 questions about dates in MS Access and Nested dtml-in calls

[McDonnell, Larry]

Hi,

I have two questions. The first is how do I generate an ZSQL Method when the
variables are set to timestamp(19). I am looking to do the camparsion
between date routine. I cannot change the variable to a different type.

My next question is to do with nested dtml-in calls. I need to call two
tables. One table has the detail information I need but the other has a few
fields I need for header information. There are several fields that are in
both, I was going to use invoice number. Currently, I have no input fields.
I want to know if I can create a query without getting an keyerror for this
field. 


<table width="100%" border="1">
<tr>    
    <td>
           <font color="#FF0000" size="-1">Customer
       </td>
    <td>       
	   <font color="#FF0000" size="-1">Sales Order #
      </td>
    <td>       
	   <font color="#FF0000" size="-1">P. O. #
	</td>
    <td>       
	   <font color="#FF0000" size="-1">Part #
	</td>
    <td>       
	   <font color="#FF0000" size="-1">Description
	</td>
    <td>       
	   <font color="#FF0000" size="-1">Qty
	</td>
    <td>       
	   <font color="#FF0000" size="-1">Serial Number
	</td>
    <td>       
	   <font color="#FF0000" size="-1">Shipped Date
	</td>
    <td>       
	   <font color="#FF0000" size="-1">Freight Carrier
	</td>
    <td>       
	   <font color="#FF0000" size="-1">Waybill #
	</td>
    <td>       
	   <font color="#FF0000" size="-1"># of Pkgs/Skids
	</td>
</tr>

<dtml-in lookup_gs_query2>
  


  <tr>
    <td>
           <font color="#0000FF" size="-1"><dtml-var customer>
        </td>
    <td>       
	   <font color="#0000FF" size="-1"><dtml-var order_no>
  
  <dtml-in lookup_gs_query3>
  
    <td>       
	   <font color="#0000FF" size="-1"><dtml-var waybill>
	</td> 
    <td>       
	   <font color="#0000FF" size="-1">,dtml-var date_shipped>
	</td>
</tr>
  </dtml-in>
</dtml-in>
</table>



Larry McDonnell

Proton Energy Systems
50 Inwood Rd.
Rocky Hill, CT 06067
(860) 571-6533 ext. 531
Email:lmcdonnell@protonenergy.com
www.protonenergy.com