[Zope] MySQL & integer IDs

Tom Jenkins TomJenkins@zentuit.com
Sun, 14 Mar 1999 12:46:36 -0500


> At 06:14 14-3-99 , Tom Jenkins wrote:
> >Now unfortunately I believe the L is causing the insert to fail with an 
> >invalid integer.  I specified user_id as integer unsigned zerofill 
> >auto_increment.  Does anyone know why the 'L' is being return?
> >
> 
> The L value is caused by a long integer to string conversion. You can get
> rid of the L by specifying a C format string, like so:
> 
> <!--#var user_id fmt="%u"-->
> 
thanks guys that was exactly the problem and the above fixed it.  I 
didn't know about the fmt capability.

Anthony: <!--#var user_id fmt="%d"--> works too.

Thanks again,
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Tom Jenkins                    DevIS (http://www.devis.com)
Linux & Samba 2.0 : The best Windows file server
http://www.zdnet.com/sr/stories/issue/0,4537,2196106,00.html                                         
"Do not be overcome by evil, but overcome evil with good." Romans 12:21