[ZCM] [ZC] 2070/ 4 Reject "dtml-in summary variables"

[Collector: Zope Bugs, Features, and Patches ...]

Issue #2070 Update (Reject) "dtml-in summary variables"
 Status Rejected, Zope/bug medium
To followup, visit:
  http://www.zope.org/Collectors/Zope/2070

==============================================================
= Reject - Entry #4 by ajung on Apr 17, 2006 4:06 am

 Status: Pending => Rejected

3rd-party issue
________________________________________
= Comment - Entry #3 by cyhoong on Apr 17, 2006 12:55 am

I have managed to isolate the problem. The problem lies in the Database Adapter. In Zope 2.8.x, I was using psycopg-1.1.21 whereas in Zope-29.x it was switched to the new psycopg-2.x. When I downgraded to the psycopg-1.1.21, the matter is resolved. However, I do not understand why is the error message is raised from DTML conversion not from database adapter?

I will report this to the psycopy list.

Thanks.
________________________________________
= Comment - Entry #2 by camil7 on Apr 13, 2006 7:07 pm

I have tried to reproduce the issue with some gadfly database,
but I had no success.

cyhoong: could You please try to play around with the 
with the formats, e.g. replacing 'fmt="%.2f"' by 'fmt="%s"'
or 'fmt="%r"'
maybe You can figure out that way what odd type of object
came in here.

________________________________________
= Request - Entry #1 by cyhoong on Apr 13, 2006 3:28 am


Uploaded:  "bugReport"
 - http://www.zope.org/Collectors/Zope/2070/bugReport/view
I have a dtml method that list some values from Postgresql 8.x database. This dtml method works in Zope 2.8.x while Zope 2.9.x list error message. I have attached the sample code for your reproduction. My platform is Window XP.

==============================================

Site Error

An error was encountered while publishing this resource.

Error Type: TypeError
Error Value: float argument required

Troubleshooting Suggestions

    * The URL may be incorrect.
    * The parameters passed to this resource may be incorrect.
    * A resource that this resource relies on may be encountering an error.

For more detailed information about the error, please refer to the error log.

If the error persists please contact the site maintainer. Thank you for your patience. 

Event log
===========
2006-04-13T15:10:19 ERROR Zope.SiteErrorLog http://127.0.0.1:9080/Test/test.dtml
Traceback (most recent call last):
  File "e:\Zope-2.9.2\lib\python\ZPublisher\Publish.py", line 115, in publish
    request, bind=1)
  File "e:\Zope-2.9.2\lib\python\ZPublisher\mapply.py", line 88, in mapply
    if debug is not None: return debug(object,args,context)
  File "e:\Zope-2.9.2\lib\python\ZPublisher\Publish.py", line 41, in call_object
    result=apply(object,args) # Type s<cr> to step into published object.
  File "e:\Zope-2.9.2\lib\python\OFS\DTMLMethod.py", line 144, in __call__
    r=apply(HTML.__call__, (self, client, REQUEST), kw)
  File "e:\Zope-2.9.2\lib\python\DocumentTemplate\DT_String.py", line 476, in __call__
    try: result = render_blocks(self._v_blocks, md)
  File "e:\Zope-2.9.2\lib\python\DocumentTemplate\DT_In.py", line 703, in renderwob
    try: append(render(section, md))
  File "e:\Zope-2.9.2\lib\python\DocumentTemplate\DT_Var.py", line 280, in render
    val = fmt % val
TypeError: float argument required
==============================================================