Hello All, I tried using zope 2.7.6 with kinterbasdbda 2.0 and I got the same error I think, but more informative :)
ProgrammingError: (0, 'SQL statement of 2270651 bytes is too long (max 65535 allowed). Consider using parameters to shorten the SQL code, rather than passing large values as part of the SQL string.') So I guess it is the DA that disallows the long statement. So I will "Consider using parameters..." as it says. Otherwise I can look at switching to mxODBC. I wonder if that would disallow such long statements as well? Thanks for the help. Josh Traceback (innermost last): Module ZPublisher.Publish, line 101, in publish Module ZPublisher.mapply, line 88, in mapply Module ZPublisher.Publish, line 39, in call_object Module Shared.DC.Scripts.Bindings, line 306, in __call__ Module Shared.DC.Scripts.Bindings, line 343, in _bindAndExec Module Products.PythonScripts.PythonScript, line 323, in _exec Module None, line 16, in upload_process <PythonScript at /external/dr3/test/quotes/upload_process> Line 16 Module Shared.DC.ZRDB.DA, line 454, in __call__ <SQL instance at 04168BC0> Module Products.kInterbaseDA.db, line 226, in query Module Products.kInterbaseDA.db, line 255, in _executeSQLAndReturnResultRows Module kinterbasdb, line 1592, in execute ProgrammingError: (0, 'SQL statement of 2270651 bytes is too long (max 65535 allowed). Consider using parameters to shorten the SQL code, rather than passing large values as part of the SQL string.') -----Original Message----- From: Andreas Jung [mailto:[EMAIL PROTECTED] Sent: Monday, 21 November 2005 4:36 PM To: Joshua Burvill; zope@zope.org Subject: Re: [Zope] dtml-sqlvar problem with large strings? --On 21. November 2005 16:30:10 +1100 Joshua Burvill <[EMAIL PROTECTED]> wrote: > > Using zope 2.6.4 on win32 with kinterbasdbda (not sure what version), > firebird 1.0 > > This sounds like a bug in the kinterbasedbda. Since this is DA is not used widely I would recommend to buzz the author of the DA directly. When you are on Windows you could consider switching to mxODBC in case your database supports ODBC. -aj _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )