garry saddington wrote at 2006-12-23 22:26 +0000:
I have a Zope application that runs perfectly on Linux. However, my target audience is likely to use Windows so I am trying to port my app. to that platform. Whenever I use a multiple insert Zsql method that includes sql_delimiter, python.exe crashes.
There is no issue with "sql_delimiter" on Windows. In fact, "sql_delimiter" is extremely harmless: it just inserts a delimiter (usually the "\0" character) used to break the complete generated SQL into a sequence of SQL commands sent to the database. This happens in "...db.DB.query". It is completely platform independent.
eg. <dtml-in att> <dtml-var sql_delimiter>
You Windows database client library may not like empty SQL commands (while the Linux library might be more resilient). Try to suppress the first "sql_delimiter" (as it creates an empty SQL command). -- Dieter