[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


Hi
If I have a file in a directory with MySQL database connection in the
directory.
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?)

regards
Greg
__________________________________
Greg McCall - greg.mccall@telstra.com
http://www.message-us.com