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