[Zope] dtml-sqlvar and \n

Chris Withers chrisw@nipltd.com
Sat, 10 Aug 2002 16:26:01 +0100


Michael Fischer v. Mollard wrote:
> I ran into a little inconvenience with <dtml-sqlvar spam type="string"> 
> where spam is like "spam \n eggs" (as string, not the charcter).
> sql_quote escapes this to "spam \\n eggs", which is not actually what I 
> want. Is this intended and if, why? 

I think it's intended. Surely you'd want the \n to be encoded for it to be 
correct SQL?

> And is there a workaround other then 
> usin <dtml-var>?

Well, use dtml-var, what problems do you percieve in doing that?

cheers,

Chris