[Zope] Bug in List/Records ????

[Luis Cortes]

I have the following code for a simple International timesheet application:

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

<dtml-var standard_html_header>


<H1>Timesheet for
<dtml-in "sqlSelectSingleControl()">
        [<dtml-var week_end>]
</dtml-in>

<br>
For  [<dtml-var "AUTHENTICATED_USER">]

</H1>

<form action="dtmlVerifyTimeSheet" method="POST">
<table border=2>

<tr>    <th rowspan="2"> Accounts

<dtml-comment>
================================================================
Place days of week headings
================================================================
</dtml-comment>

<dtml-in "['Monday','Tuesday','Wednesday','Thursday','Friday','Saturday','Sunday']">
        <th colspan="2"> <dtml-var sequence-item>
</dtml-in>

<dtml-comment>
================================================================
place USA or MEX headings
================================================================
</dtml-comment>

<tr>
<dtml-in "1,2,3,4,5,6,7">
        <th>USA<th>MEX
</dtml-in>

<dtml-comment>
================================================================
1.  Place DROP down list of Charge Accounts per row
2.  Place 7 Hour Edit Boxes for usa/mex per row
================================================================
</dtml-comment>


<dtml-let list="DBGetAccts()">

        <dtml-in "1,2,3,4,5,6,7,8,9,10">
        <dtml-let rowid=sequence-item>

                <dtml-comment>
                ================================================================                Charge Accounts per row
                ================================================================                </dtml-comment>


                <tr><td>
                <SELECT NAME="items.acct:records">
                <dtml-in list>
                        <OPTION SELECTED VALUE="<dtml-var aid>">
                                (<dtml-var aid>) <dtml-var description>
                        </OPTION>
                </dtml-in>
                </SELECT>

                <dtml-comment>
                ================================================================
                mex/usa hours per row
                ================================================================                </dtml-comment>


                <dtml-in "1,2,3,4,5,6,7">
                        <td> <input type="float" name="items.usa:records" maxlength = "4" size="4">
                        <td> <input type="float" name="items.mex:records" maxlength = "4" size="4">
                </dtml-in>
        </dtml-let>
        </dtml-in>
</dtml-let>


<dtml-comment>
================================================================
place OK button
================================================================
</dtml-comment>

</table>
<input type = "submit" value="OK">
</form>

<p>
Today is <dtml-var ZopeTime fmt=Date>, the time is <dtml-var ZopeTime fmt=Time>.</P>

<dtml-var standard_html_footer>


>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

Please notice that I have an adjustable number of charge accounts.  What is
nice is that I get an ordered list from my records which looks like:

[acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: ,
mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: ,
usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: ,
usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: ,
mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: ,
usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: ,
usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , acct: 1, mex: , usa: , mex: , usa: , mex: , usa: ,
mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: , mex: , usa: ] 


The problem, if you will carefully notice, is that from acct:1 to the next
acct:1 there are only 6 pairs of mex:, usa:, in the rest there are 7 and in the
last acct:1 to end of list there are 8!  Is this behavior correct???  I really
doubt it, but if it is correct can someone explain it to me???

regards,
Luis.





-- 
======================================================

Luis Cortes

Pollak EPD (915) 621-6113

======================================================