[Zope] Do While Loop Equivalent

McDonnell, Larry lmcdonnell@protonenergy.com
Thu, 22 May 2003 11:18:30 -0400


Sorry David, Andreas, and Dennis for the short email that did not explain my
problem fully (had to go to a 
meeting). I use dtml mostly but I'm starting to see the power of Python. I
am creating a web based system to collect test data during our manufaturing
process. I can generate a serial number but depending on the part the items
within a this serial number can be 4, 10, 24, 34 items. I need to create
these records first so they can update them as they are testing. With my
zsql method, I am creating records with 3 fields populated using David's
dtml-in method:

<dtml-call "REQUEST.set('cell_number', 0)">
<dtml-in "_.range(10)">
<dtml-call "REQUEST.set('cell_stack_number', cell_number+1)">

<dtml-call expr="create_atp_fields_record(REQUEST)">

But an error message:

Error Type: sql.error
Error Value: ('23000', -1605, '[Microsoft][ODBC Microsoft Access Driver] The
you requested to the table were not successful because they would create
duplicate values 
in the index, primary key, or relationship. Change the data in the field or
fields that 
contain duplicate data, remove the index, or redefine the index to permit
duplicate entries 
and try again.')

I have no indexes or primary key set. Any sugesstions? Thanks.

-----Original Message-----
From: David Hassalevris [mailto:bluepaul@earthlink.net]
Sent: Wednesday, May 21, 2003 4:05 PM
To: McDonnell, Larry; 'Zope@Zope. Org' (E-mail)
Subject: Re: [Zope] Do While Loop Equivalent

<dtml-in "_.range(9)">
... add block of records

Was that what you wanted?
----- Original Message ----- 
From: "McDonnell, Larry" <lmcdonnell@protonenergy.com>
To: "'Zope@Zope. Org' (E-mail)" <zope@zope.org>
Sent: Wednesday, May 21, 2003 12:55 PM
Subject: [Zope] Do While Loop Equivalent

> Hi,
> I have been searching for a while but I am coming up empty. I am writing a
> module that needs to create a block of records in the db so they can be
> updated at a later time. In the good old days, I would use a do while loop
> (do something while x < 10). How can this be done? And as always any
> pointers will be appreciated, thanks.
> Larry McDonnell
> Proton Energy Systems
> 10 Technology Drive
> Wallingford, CT 06492
> (203) 678-2181
> Email:lmcdonnell@protonenergy.com
> www.protonenergy.com
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )