RE: [Zope] How do I create a cursor on a query in Zope
With the old syntax: I can not run a call to a ZSQL Method inside another: <!--#in SQL_Statement size=60 start=query_start--> <!--#in SQL_Statement2 size=60 start=query_start--> <!--#/in--> <!--#/in--> This statement fails every time for me, but the queries run fine separately. -----Original Message----- From: Evan Simpson [mailto:evan@tokenexchange.com] Sent: Thursday, August 26, 1999 10:09 AM To: Marten Quadland Subject: Re: [Zope] How do I create a cursor on a query in Zope Ah, you may be using an older Zope which doesn't support the new syntax. Just replace '<dtml-in ...>' with '<!--#in ...-->' everywhere (and do the same for 'dtml-var'/'#var'). In general, when you see someone writing DTML with '<dtml-foo ...>' tags in it, you can replace them with '<!--#foo ...-->'. ----- Original Message ----- From: Marten Quadland <mquadland@indigonetworks.com>
I'm having trouble getting simply the first option to work.
I'm used to calling sql calls with the - <!--#in SQL_Statement size=60 start=query_start--> <!--#in SQL_Statement2 size=60 start=query_start--> <!--#/in--> <!--#/in-->
Instead of: <dtml-in SQL_get_names> </dtml-in>
A little testing reveals that you'll have to explicitly pass the values from the outer ZSQL to the inner one, as in: <!--#in SQL_Statement size=60 start=query_start--> <!--#in "SQL_Statement2(f1=f1, f2=f2)" size=60 start=query_start--> <!--#/in--> <!--#/in--> where f1 and f2 are fields in the result from SQL_Statement. I'm not sure why this is, since I thought that declared parameters would be automatically be found in the current context. ----- Original Message ----- From: Marten Quadland <mquadland@indigonetworks.com>
With the old syntax:
I can not run a call to a ZSQL Method inside another:
<!--#in SQL_Statement size=60 start=query_start--> <!--#in SQL_Statement2 size=60 start=query_start--> <!--#/in--> <!--#/in-->
This statement fails every time for me, but the queries run fine separately.
participants (2)
-
Evan Simpson -
Marten Quadland