[Zope-DB] How to insert csv file data into a MySQL database table

Greg McCall greg@message-us.com
Thu, 8 Nov 2001 22:10:04 +1100

If I have a file in a directory with MySQL database connection in the
The file contains lines with each line containing comma separated fields.
The database works and I can make routines to list, display, edit & delete
the records using Znolk
I can also insert the file from the MySQL command line in a UNIX shell

How do I read each line using an SQL INSERT  (or UPDATE) in Zope.
(python or DTML ?? and how?)

Greg McCall - greg.mccall@telstra.com