updated - Re: [Zope] ZSQL question - probably a stupid one!
Dan Jacobs
dan@danjacobs.com
Wed, 25 Sep 2002 19:16:23 +0100 (BST)
OK, the selec is actually this
SELECT currval('pieceseq')
which is taking the latest value of a sequentially assigned id number.
according to the docs you can only do this within after an insert...
dj
On Wed, 25 Sep 2002, Tim Wilson wrote:
> On Wed, Sep 25, 2002 at 07:06:22PM +0100, Dan Jacobs wrote:
> >
> > I have.
> >
> > 1. a form that submits to a dtml method
> > 2. dtml method does a dtml-call to some ZSQL
> > 3. the ZSQL is doing a load of inserts then 1 select at the end.
> >
> > My new question. How do I display the results of the select at the end?
>
> What about doing the select in a separate ZSQL method that could be
> called from DTML.
>
> -Tim
>
> --
> Tim Wilson | Visit Sibley online: | Check out:
> Henry Sibley HS | http://www.isd197.org | http://www.zope.com
> W. St. Paul, MN | | http://slashdot.org
> wilson@visi.com | <dtml-var pithy_quote> | http://linux.com
>
> _______________________________________________
> Zope maillist - Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> ** No cross posts or HTML encoding! **
> (Related lists -
> http://lists.zope.org/mailman/listinfo/zope-announce
> http://lists.zope.org/mailman/listinfo/zope-dev )
>
- Dan Jacobs
- 07956 246 659