You can use Web2py DAL to open the mySQL database. No need for separate library. See the Web2py book on DAL constructor. Make a (second) db connection, say db2, and retrieve the rows from db2 using select().
For the rest you're well on your way. Just need to update the standard db for each found row. See http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#count--isempty--delete--update Something like: For row in rows: db(db.name==row.name)update(fieId=row.field, ...) Nico de Groot -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
