[Zope] Z SQL and python script question

[Jim Penny]

On Tue, 29 Jul 2003 08:09:27 -0700 (PDT)
Rex McKanry <rmckanry@yahoo.com> wrote:

> Hi,
> I'm trying to join or add two text boxes from a Zope
> web page to use in a postgresql database search. I
> have written a python script that adds the two strings
> I'm passing for me and am passing the to strings to
> the sql query but am unsure how to call the python
> script from the sql statement. Does any one have any
> ideas??
> 
> Thanks,
> Rex

To the best of my knowledge, you can't.  Call the python script before
the SQL script and pass the resulting value as a parameter, or use the
SQL || operator to do the concatenation.

Jim Penny

> 
> __________________________________
> Do you Yahoo!?
> Yahoo! SiteBuilder - Free, easy-to-use web site design software
> http://sitebuilder.yahoo.com
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
> 
>