updated - Re: [Zope] ZSQL question - probably a stupid one!

[Dan Jacobs]

OK -

I am doing something wrong here so let me explain what I am trying to do
maybe then someone can advice.

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?

Can I do this from my dtml method (2)?

Then depending on the answer and how it works I might need the first
question answered.

Thanks in advance,

Dan


On Wed, 25 Sep 2002, Dan Jacobs wrote:

> Hi,
>
> I have am using ZSQL against a postgres database using psgcopg.
>
> I have a set of queries which are doing inserts then the last one is doing
> something like this; SELECT currval('blahseq')
>
> I want to be able to set an object name for this value which is different
> to the field name that the SQL will return.
>
> Does this make sense?  How do I do this?
>
> Thanks,
>
> Dan
>
>
>  - Dan Jacobs
>  - 07956 246 659
>
>
> _______________________________________________
> 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