when you do an insert with a ZSQL method you do not get back any info from mysql, you need to do a subsequent search to get 'autogenerated' columns. So do your insert, then do an ZSQL search. The search returns a 'Results' object which has several methods you can use to get at the search results. In a python script try something like: rstat=context.UserActivity.SQL_SearchEvents(userId='111') #substitute your own zsql search print 'rstat= ', rstat print 'rstat.names= ',rstat.names() print 'rstat.tuples= ',rstat.tuples() print 'rstat.asRDB= ',rstat.asRDB() print 'rstat.data_dictionary= ',rstat.data_dictionary() print 'rstat.dictionaries= ',rstat.dictionaries() hth Jonathan ----- Original Message ----- From: Benjamin Menking To: zope@zope.org Sent: Monday, July 17, 2006 1:01 PM Subject: [Zope] ZSQL Method Question New to python/Zope, old-timer on PHP.... I'm using MySQL and a ZSQL method to insert data into the database. ex: insert into org (org_name, org_phone) values ('x', 'y') What I'm trying to figure out is that org_id (also part of the org table, but not specified in the sql statement) is an auto_increment primary key field and in PHP I can use mysql_insert_id() to find out what org_id was set to after the mysql_query() call. Is there a way to retrieve that value with ZSQL method, or must I use some other mechanism? Thanks! -- Ben Menking RHCE IT Security Consulting (864) 420-5603 (864) 751-1638 fax IT and Business Solutions ------------------------------------------------------------------------------ _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )