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

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 ofcourse

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