[Zope] zope sql_delimiter windows

[Dieter Maurer]

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