(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