pymssql text type

[marc wyburn]

On Mar 12, 3:36 pm, a... at pythoncraft.com (Aahz) wrote:
> [posted and e-mailed, please reply to group]
>
> In article <851ed9db-2561-48ad-b54c-95f96a7fa... at q9g2000yqc.googlegroups.com>,
> marcwyburn <marc.wyb... at googlemail.com> wrote:
>
> >Hi, I'm trying to pass a text blob to MS SQL Express 2008 but get the
> >follwoing error.
>
> >(<class 'pymssql.OperationalError'>, OperationalError("SQL Server
> >message 102, severity 15, state 1, line 1:\nIncorrect syntax near
> >'assigned'.\n",), <traceback object at 0x044ABDF0>)
>
> >the string it is having an issue with is
>
> >(\r\n\r\n\tLogon ID:\t\t(0x0,0xE892A8)\r\n\r\n\tLogon Type:\t2\r\n\r
> >\n')
>
> What is the code you're trying to execute and what is the full traceback?
> --
> Aahz (a... at pythoncraft.com)           <*>        http://www.pythoncraft.com/
>
> "All problems in computer science can be solved by another level of    
> indirection."  --Butler Lampson

I can't remember what the original code was but will try to recreate
it.  I ended up using re to remove most of the line breaks and tabs.