[Zope] MySQL & integer IDs

[Martijn Pieters]

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"-->

Martijn Pieters

-- 
M.J. Pieters, Web Developer 
| Antraciet http://www.antraciet.nl 
| Tel: +31-35-6254545 Fax: +31-35-6254555 
| mailto:mj@antraciet.nl http://www.antraciet.nl/~mj 
| PGP: http://wwwkeys.nl.pgp.net:11371/pks/lookup?op=get&search=0xA8A32149 
------------------------------------------