Hi Greg Znolk provides some utility api functions for uploading and downloading files using ZSQL methods, the seem to provide what you want to do. You find detailed descriotions on Znolk here: http://magnix.bluedynamics.com:8080/BlueDynamics/products/Znolk and detailed descriptions on uploading and downloading textfiles to ZSQL methods there: : http://magnix.bluedynamics.com:8080/BlueDynamics/products/Znolk/BlueWire you find a test environment and can view the objects there and experiment with the data. hope it helps, if you have problems just contact me phil phil@bluedynamics.com Am Don, 2001-11-08 um 12.07 schrieb Greg McCall:

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

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )