[Zope] Tree tag and SQL methods?

Phillip J. Eby pje@telecommunity.com
Sun, 27 Jun 1999 17:25:20 -0500


Can you post the source of your tree tag call as well?  Thanks.

At 07:21 PM 6/27/99 +0200, Alexander Staubo wrote:
>No offense taken -- yes, of course I have tested it. :-)
>
>I have not tested using the #tree tag with the second output though, but
>that would meaningless (the second output should be rendered as leaf
>nodes). I even tried having the second query output _all_ data in the
>table, to no avail. Here's my query:
>
><!--#if "pb == ''"-->
>select distinct publication, count(publication) as pub_cnt
>from articles
>where publication != ''
>group by publication
>order by publication
><!--#else-->
>select title
>from articles
>where publication = <!--#sqlvar pb type=string-->
><!--#/if-->
>
>Here, pb is the publication argument. I assure you, the second part of
>the query does execute correctly.
>
>--
>Alexander Staubo             http://www.mop.no/~alex/
>"`This must be Thursday,' said Arthur to himself, sinking low over
>his beer, `I never could get the hang of Thursdays.'"
>--Douglas Adams, _The Hitchhiker's Guide to the Galaxy_
>
>>-----Original Message-----
>>From: Phillip J. Eby [mailto:pje@telecommunity.com]
>>Sent: 27. juni 1999 18:07
>>To: Alexander Staubo; Zope Mailing List (E-mail)
>>Subject: RE: [Zope] Tree tag and SQL methods?
>>
>>
>>Don't be offended by this suggestion, but, have you tried
>>having the tree
>>print out all the variables that would affect the 'second'
>>query, and then
>>plugging them into manage_test of the query?  My guess is
>>you'll find that
>>there's something you've overlooked as far as how output of
>>the first query
>>gets fed into the second, or else the second is just plain wrong.
>>
>>At 03:36 PM 6/26/99 +0200, Alexander Staubo wrote:
>>>Doesn't improve anything: While the "second" part of the query -- the
>>>one that's supposed to collect the leaf articles -- clearly
>>executes, no
>>>data is displayed. Only the first level -- the publications list -- is
>>>rendered, with "plus" icons. Clicking on the icon runs the
>>query but no
>>>data is there.
>>>
>>
>
>
>_______________________________________________
>Zope maillist  -  Zope@zope.org
>http://www.zope.org/mailman/listinfo/zope
>
>(For developer-specific issues, use the companion list,
>zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )
>