[Zope] Zope + MySQL problem

[Garry Steedman]

Chris,

have a read of this, it should clear everything up for you:

http://www.zope.org/Members/adustman/Tips/no_el

cheers,

garry

On 7 Nov 2001, at 16:31, Chris Gray wrote:

From:           	Chris Gray <cpgray@library.uwaterloo.ca>
To:             	zope@zope.org
Subject:        	[Zope] Zope + MySQL problem
Date sent:      	Wed, 7 Nov 2001 16:31:09 -0500 (EST)

> 
> I have a working Zope site that I want to move to a more powerful
> machine.  I've set up the new machine (Debian GNU/Linux).  I've moved
> Data.fs and everything looks fine.  I've dumped the mysql database and
> reloaded it and everything looks fine
> 
>  ... 
> 
> except a query to the MySQL database that retrieves an integer record
> id value now retrieves it with the suffixed 'L' for a python long
> integer.  This 'L' goes into a URL and breaks the next step in the
> process since Zope gives an error that '1727L' (or whatever) is not a
> proper integer.
> 
> The code is basically the following inside a dtml-in loop on a
> database query:
>      <a href="collect_stats.html?record_id=&dtml-record_id;">
> This used to render as:
>      <a href="collect_stats.html?record_id=1727">
> and now renders as:
>      <a href="collect_stats.html?record_id=1727L">
> 
> Why?
> 
> Thanks,
> Chris
> 
> 
> _______________________________________________
> 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 )


+-------------------------------------------+
  Garry Steedman      mailto:gs@styrax.com  
  Styrax Associates  http://www.styrax.com/ 

  "The Good Man has no shape."            
+-------------------------------------------+