[Zope-DB] MS SQL and \

[Andy McKay]

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.

Cheers.
--
  Andy McKay.


----- Original Message -----
From: "Andy McKay" <andym@ActiveState.com>
To: "Matthew T. Kromer" <matt@zope.com>
Cc: <zope-db@zope.org>
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.
>
> Cheers.
> --
>   Andy McKay.
>
>
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db
>