[Zope] MySQL & integer IDs

[Tom Jenkins]

(I'm resending this as I didn't see it appear on the list the first time)

 > 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