I was wondering if you have any knowledge of Zope returning longs instead of integers on for example: <dtml-in "some_MySQL_ZSQL_Thing()"> <dtml-var id> </dtml-in> Which will produce something like 1L 2L 3L instead of 1 2 3 This happens using exactly the same ZMySQL adapter on different locations, the location "out of order" is running GNU/Debian 2.2 Frozen (i386) with Zope 2.1.4 on top, and the "right one" is running RedHat 6.0 (i386) with Zope 2.1.4 on top. Could this be a MySQL misfeature? Regards, Morten W. Petersen
We've experienced this as well, but we never got to the bottom of this. We've also had other similar, but different; problems with the MySQL-Zope interface that vary from platform to platform. Any ideas as to what's going on here would be gratefully received... Chris "Morten W. Petersen" wrote:
I was wondering if you have any knowledge of Zope returning longs instead of integers on for example:
<dtml-in "some_MySQL_ZSQL_Thing()"> <dtml-var id> </dtml-in>
Which will produce something like
1L 2L 3L
instead of
1 2 3
This happens using exactly the same ZMySQL adapter on different locations, the location "out of order" is running GNU/Debian 2.2 Frozen (i386) with Zope 2.1.4 on top, and the "right one" is running RedHat 6.0 (i386) with Zope 2.1.4 on top.
Could this be a MySQL misfeature?
Regards,
Morten W. Petersen
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
Chris Withers wrote:
We've experienced this as well, but we never got to the bottom of this. We've also had other similar, but different; problems with the MySQL-Zope interface that vary from platform to platform.
Any ideas as to what's going on here would be gratefully received...
Look in the archives for Sybase issues about this. Basically there is a point at which python displays a 'Long Integer' as <whatever>L. This may be the source of the problem. A Search on this and SybaseDA in the archives should reveal it. A search on Long Integer reveals some data regarding MySQLdb, though I can't vouch for it's accuracy (it was poste din February...). -- In flying I have learned that carelessness and overconfidence are usually far more dangerous than deliberately accepted risks. -- Wilbur Wright in a letter to his father, September 1900
participants (3)
-
Bill Anderson -
Chris Withers -
Morten W. Petersen