[Zope] REQUEST not available in SQL Methods?

TFE WSD JARVIS JOHN jarvis.sd082@ex.tel.co.jp
Wed, 26 Apr 2000 18:46:13 +0900


I had the same problem. I didn't try <dtml-with> but putting REQUEST in the
"Arguments" field seems to work.

John Jarvis 

> -----Original Message-----
> From:	Alexander Schonfeld [SMTP:alex@garage.co.jp]
> Sent:	Wednesday, April 26, 2000 10:31 AM
> To:	zope@zope.org
> Subject:	Re: [Zope] REQUEST not available in SQL Methods?
> 
> > On Zope 2.1.6, Zodbcda (3.1.0b2 newest... I think), WinNT:
> 
> When I try something like:
> ---
>   <dtml-with REQUEST>
>      select * from asdf
>   </dtml-with>
> ---
> I get errors like this:
> 
> Error type: KeyError Error value: 
> Error type: KeyError Error value: REQUEST ERROR MESSAGE   Zope    
>  Z SQL Method at /hide / testNetworkSQL  
> SQL used:
> Could not render the query template!
> --------------------------------------------------------------------------
> ------
> Error, exceptions.KeyError: REQUEST 
> --------------------------------------------------------------------------
> ------
> Traceback (innermost last):
>   File D:\SONICN~2\lib\python\ZPublisher\Publish.py, line 214, in
> publish_module
>   File D:\SONICN~2\lib\python\ZPublisher\Publish.py, line 179, in publish
>   File D:\SONICN~2\lib\python\Zope\__init__.py, line 202, in
> zpublisher_exception_hook
>     (Object: testNetworkSQL)
>   File D:\SONICN~2\lib\python\ZPublisher\Publish.py, line 165, in publish
>   File D:\SONICN~2\lib\python\ZPublisher\mapply.py, line 160, in mapply
>     (Object: manage_test)
>   File D:\SONICN~2\lib\python\ZPublisher\Publish.py, line 102, in
> call_object
>     (Object: manage_test)
>   File D:\SONICN~2\lib\python\Shared\DC\ZRDB\DA.py, line 331, in
> manage_test
>     (Object: testNetworkSQL)
>   File D:\SONICN~2\lib\python\Shared\DC\ZRDB\DA.py, line 310, in
> manage_test
>     (Object: testNetworkSQL)
>   File D:\SONICN~2\lib\python\Shared\DC\ZRDB\DA.py, line 424, in __call__
>     (Object: testNetworkSQL)
>   File D:\SONICN~2\lib\python\DocumentTemplate\DT_String.py, line 502, in
> __call__
>     (Object: <string>)
>   File D:\SONICN~2\lib\python\DocumentTemplate\DT_With.py, line 132, in
> render
>     (Object: REQUEST)
> KeyError: (see above)
> 
> 
> 
> 
> On Tue, 25 Apr 2000 08:53:32 -0500
> "Jim Sanford" <jsanford@atinucleus.com> wrote:
> 
> > I just  start and end my ZSQL methods with <dtml-with REQUEST> and
> </dtml-with>
> > ----- Original Message ----- 
> > From: Alexander Schonfeld <alex@garage.co.jp>
> > To: <zope@zope.org>
> > Sent: Tuesday, April 25, 2000 4:26 AM
> > Subject: [Zope] REQUEST.set in ZSQL Methods?
> > 
> > 
> > On Zope 2.1.6, Zodbcda (3.1.0b2 newest... I think), WinNT:
> > 
> > I have some old ZSQL Methods which use the REQUEST object to store some
> > variables.
> > 
> > I seem to be getting a name error when I try these with the newer
> > zodbcda... not with the sybaseda or the old Zope and old zodbcda.
> > 
> > For example:
> > ---
> > <!--#unless "_.str(ColumnValue)[0] == '[' and
> > _.str(ColumnValue)[-1] == ']'"-->
> > <!--#call "REQUEST.set('ColumnValue', [ColumnValue])"-->
> > <!--#/unless-->
> > <!--#with REQUEST-->
> > ........
> > ---
> > I get a NameError when it does the REQUEST.set.
> > 
> > Can you believe it!? Zope legacy code... :)  I have lots of these ZSQL
> > Methods, so I don't really want to change all the logic... but if there
> > is a simple way to pass in the REQUEST object or fix the DA that would
> > be nice.  Anyone with similar problems?
> > 
> > Thanks,
> > 
> > Alex.
> >  
> > 1010011010
> > 0  Digital Garage
> > 1  Alex Schonfeld
> > 0  alex@garage.co.jp - pear
> > 1  090-4429-2323
> > 
> > 
> > _______________________________________________
> > 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 )
> > 
> > 
> > 
> > 
> > _______________________________________________
> > 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 )
> > 
> > 
> 
>  
> 1010011010
> 0  Digital Garage
> 1  Alex Schonfeld
> 0  alex@garage.co.jp - pear
> 1  090-4429-2323
> 
> 
> _______________________________________________
> 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 )