[Zope-DB] MS SQL and \
Thu, 20 Sep 2001 14:04:29 -0700
Weird if I just replace \n with +CHAR(10)+ in SQLServer its happy. Quick
hack in sqlvar.py so my SQL looks like "'a = a + \' + CHAR(10) + 'b'" and Im
a happy bunny again.
----- Original Message -----
From: "Andy McKay" <andym@ActiveState.com>
To: "Matthew T. Kromer" <email@example.com>
Sent: Thursday, September 20, 2001 1:07 PM
Subject: Re: [Zope-DB] MS SQL and \
> > Eep!
> > This is a direct consequence of the data being sent into the database as
> > strings, not as positional parameters.
> Yup, wont be the first time.
> > I would guess that ZSql methods
> > can be tweaked by simple re-coding to allow you to embed a line-end
> > character for SQL --
> Hmm I can do that... any chance you know what the right SQL syntax is?
> > but my preferred solution is to try to use bind
> > values instead (which Zope does not support at this time but is on my
> > wish-list to pull some patches and do some other work to support.)
> Absolutely, that would speed things up as well.
> Andy McKay.
> Zope-DB mailing list