[Zope] MySQL LAST_INSERT_ID...

[Tom Jenkins]

Hi Phil,
Sorry I didn't make things clear (maybe I'll update the list?).  Yes I 
solved my problem and feel really dumb.  I didn't realize that the 
traceback is in the error page as a comment.  Once I found that out, I 
saw immediately that the arguments passed in had a couple of extra 
fields that I didn't use (the master and detail tables share some initial 
fields).  I took them out of the sql statement and the form, but I didn't 
remove them from the argument list.  (Just an FYI, the system allows 
you to add additional detail records, the first one is autogenerated from 
the master)

> Hi Tom,
> 
> I have been on vacation and can't tell whether you have solved your problem.
> 
> If  you are still having problems email me. I am doing exactly what you
> want to do so I will dig through my code and send you some tested examples
> if you like.
> 
> Phil.
> 
> >To followup my last post, I'm getting an exception when trying to use
> >MySQL's  "select LAST_INSERT_ID()" function:

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Tom Jenkins                    DevIS (http://www.devis.com)
Can the denizens of this group enlighten me about what the 
advantages of Python are, versus Perl? "python" is more likely
to pass unharmed through your spelling checker than "perl". 
                  An unknown poster and Fredrik Lundh, 11 Sep 1998