Hi,

I am working on a web app that interfaces with Microsoft SQL Server from Ubuntu 
through SQL Relay. I will be getting data from multiple databases. The issue 
seems to be that either Zope or SQL Relay cannot handle the Decimal type if the 
value is a null. If I do a query like this:

SELECT * from myDatabase

I get the following:

<error>

Site Error

An error was encountered while publishing this resource.

InvalidOperation
Sorry, a site error occurred.

Traceback (innermost last):

    * Module ZPublisher.Publish, line 194, in publish_module_standard
    * Module Products.PlacelessTranslationService.PatchStringIO, line 34, in 
new_publish
    * Module ZPublisher.Publish, line 146, in publish
    * Module Zope2.App.startup, line 222, in zpublisher_exception_hook
    * Module ZPublisher.Publish, line 115, in publish
    * Module ZPublisher.mapply, line 88, in mapply
    * Module ZPublisher.Publish, line 41, in call_object
    * Module Shared.DC.ZRDB.Connection, line 115, in manage_test
    * Module Products.ZSQLRelayDA.db, line 86, in query
    * Module decimal, line 571, in __new__
    * Module decimal, line 2267, in _raise_error

InvalidOperation: (Also, the following error occurred while attempting to 
render the standard error message, please see the event log for full details: 
'@@plone')

</error>

If I change it to "SELECT empid, reg from myDatabase" it will work as long as 
reg is not a NULL. I can get it to work if I use "isnull" functions on all my 
decimal type fields, but I would like to avoid that. Is this a known issue with 
a workaround?

I am using Zope 2.9.4-final on Ubuntu with SQL Relay 0.39.4. 

Mike Driscoll
Applications Specialist
MCIS - Technology Center
_______________________________________________
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 )

Reply via email to