[Zope] querying status in zsql

2000-11-10 Thread Paul Zwarts
Hi Zopers, 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 ofc

Re: [Zope] querying status in zsql

2000-11-10 Thread Rik Hoekstra
> > 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 of

Re: [Zope] querying status in zsql

2000-11-10 Thread Paul Zwarts
Thanks for that... Although Im not terribly sure what the magic behind the sequence-start is, but it works very well. Cheers, -- Paz Oratrix Development BV http://www.oratrix.com GRiNS SMIL Editor - Rik Hoekstra wrote: > > > > I have a processing script that takes emails and puts them into a

Re: [Zope] querying status in zsql

2000-11-10 Thread Rik Hoekstra
> Thanks for that... Although Im not terribly sure what the magic behind the > sequence-start is, but it works very well. > A short explanation: sql queries return a result object (so does ZCatalog btw), which you can't address directly in DTML (or at least I wouldn't know how ;-) If it the re

Re: [Zope] querying status in zsql

2000-11-12 Thread Dieter Maurer
Rik Hoekstra writes: > A short explanation: sql queries return a result object (so does ZCatalog > btw), which you can't address directly in DTML (or at least I wouldn't know > how ;-) If it the result object is empty it won't have a (sequence) start > in a dtml-in. This is the same code Sear