[Zope] MySQL & integer IDs

Tom Jenkins TomJenkins@zentuit.com
Sun, 14 Mar 1999 00:14:03 -0500


Hello all, 
First let me start by saying I've finally cleared time to play with zope.  
Its coming along nicely but I've hit a snag.  The following snippet in a 
form:

<TR><TD ALIGN="RIGHT">Staff</TD><TD><SELECT 
NAME="bugs_tbl.staff">
<!--#in qryListStaff -->
<OPTION VALUE="<!--#var user_id-->"><!--#var user_name-->
<!--#/in-->
</SELECT></TD></TR>

using MySQL produces the following HTML:

<TR><TD ALIGN="RIGHT">Staff</TD><TD><SELECT 
NAME="bugs_tbl.staff">
<OPTION VALUE="2L">Alan Johnston
<OPTION VALUE="1L">Tom Jenkins
</SELECT></TD></TR>

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?

TIA

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