> I have a processing script that takes emails and puts them into a table.
> I bring up a table for confirmation and then submit the whole thing by a
> iterative item:records zsql method.
> My problem is that the table requires a unique primary key and quite
> regularly there duplicates. So ofcourse it falls over with the expected
> error. I have tried in the zsql method encapsulating the sql with a
> <dtml-if "checkforexistantrecord"> and then at the bottom of the zsql
> loop I commit so make sure the second time around, the data is checked.
> This does not seem to work.
> So what im left with wondering is, if I can query in the zsql method:
> if error, then exit or go somewhere else
> Is this possible?

yes, this is possible. If I understand your question at least. BTW This is
untested, but I have used something similar before

mailid is the input field/variable for your method

<dtml-in emailitems>
   <dtml-in checkexistant_error(mailid=mailid)> (if this is another zsql
        <dtml-if sequence-start>
               skip or do something else
                upload your email. You may want to call another Zsql method
for this

> sorry to be very vague. The conundrum is the fact that
> the zsql method it an item loop in its own, so i cannot seem to use an
> if statement because it doesnt iterate by the normal <dtml-in> route....
> Any advice?



Zope maillist  -  [EMAIL PROTECTED]
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to