[Zope-DB] MS SQL and \

Andy McKay andym@ActiveState.com
Thu, 20 Sep 2001 13:07:02 -0700


> 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.