[Zope] Re: Z SQL test in the ZMI aborts on key error (query keyerror Solution)

[Tres Seaver]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Allen Schmidt wrote:
> Found it.
> Edit lib/python/Shared/DC/dtml/customDefaultReport.dtml
> Replace what is there with the code below (or compare and change)

Allen, your verstion "drops the query on the floor", i.e., it fixes the
KeyError, but then makes it impossible to pass the querystring through
to the next batch.


> This is from our 2.7.5 install.
> 
> 
> <dtml-in %(id)s size=20 start=query_start>
>   <dtml-if sequence-start>
> 
>      <dtml-if previous-sequence>
> 
>        <a
> href="&dtml-URL;&dtml-sequence-query;query_start=&dtml-previous-sequence-start-number;">
> 
>          (Previous <dtml-var previous-sequence-size> results)
>        </a>
> 
>      </dtml-if previous-sequence>
> 
>      %(else no_table)[<table border>
>        %(heading)s
>      %(else)]
> 
>   </dtml-if sequence-start>
> 
>   %(row)s
> 
>   <dtml-if sequence-end>
> 
>      %(else no_table)[</table>%(else)]
> 
>      <dtml-if next-sequence>
>         <a
> href="&dtml-URL;&dtml-sequence-query;query_start=&dtml-next-sequence-start-number;">
> 
>           (Next <dtml-var next-sequence-size> results)
>         </a>
> 
>      </dtml-if next-sequence>
>   </dtml-if sequence-end>
> 
> <dtml-else>
> 
>  There was no data matching this &dtml-title_or_id; query.
> 
> </dtml-in>
> 


- --
===================================================================
Tres Seaver          +1 202-558-7113          tseaver at palladion.com
Palladion Software   "Excellence by Design"    http://palladion.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCpvow+gerLs4ltQ4RAqJCAKCRYvyvas52jGLQc3voUFPl8EBHvACfZWbV
NrxkyNLv6WZjwmEfLWX3Cus=
=o7Jq
-----END PGP SIGNATURE-----