Takes the result of a Zope SQL query, and an ordered list of field names, and outputs a CSV file as the resultant web page. Should be called like this:
return context.sql.ordered-sql2csv(context.sql.exportOrders().dictionaries(), ["fullname","email","phone","address","town","postcode","children","adults","comments"])
container.REQUEST.RESPONSE.setHeader("Content-Type", "text/csv", 0)
sep = ""
for dk in fo:
container.REQUEST.RESPONSE.write(sep + dk)
sep = ","
sep = "\n"
for rec in sql:
for i in range(0,len(fo)):
data=rec[fo[i]]
dl = str(data).split(',')
data1 = " ".join(dl)
container.REQUEST.RESPONSE.write(sep + str(data1))
sep = ","
sep="\n"