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.
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).
Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists -