Hi, Thanks David, someone was fooling around and created another index that I did not know about. Once removed your statement worked. -----Original Message----- From: David Hassalevris [mailto:bluepaul@earthlink.net] Sent: Thursday, May 22, 2003 11:35 AM To: McDonnell, Larry; 'Zope@Zope. Org' (E-mail) Subject: Re: [Zope] Do While Loop Equivalent If all your keys are null then those become duplicates? Put a unique key in each. If necessary add a primary key that just gets incremental numbers. hth David ----- Original Message ----- From: "McDonnell, Larry" <lmcdonnell@protonenergy.com> To: "David Hassalevris" <bluepaul@earthlink.net>; "'Zope@Zope. Org' (E-mail)" <zope@zope.org> Sent: Thursday, May 22, 2003 8:18 AM Subject: RE: [Zope] Do While Loop Equivalent
Hi,
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)"> </dtml-in>
But an error message:
Error Type: sql.error Error Value: ('23000', -1605, '[Microsoft][ODBC Microsoft Access Driver] The changes 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
</dtml-in> Was that what you wanted? David ----- 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 )