Re: [Zope] ZSQL Method Question

[Jonathan]

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 )

_______________________________________________
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 )