Re: [sqlalchemy] sanitizing sql with sqlalchemy

2013-01-01 Thread alonn
This is what I thought. that the problem is with the application and not the sql server. unfortunately I try to access the table directly (either through sqlalchemy or directly from mssql management GUI) and both fail. the table just doesn't respond to SELECT, DELETE, TRUNCATE etc On Tuesday,

Re: [sqlalchemy] sanitizing sql with sqlalchemy

2013-01-01 Thread Tomas Vondra
On 1.1.2013 21:57, Werner wrote: > On 01/01/2013 19:34, alonn wrote: >> Actually I don't know what's causing the corruption but the "." looks >> like the only unvalid one in a varchar field. > Why would a "." in a varchar field not be valid? Just consider > something like "Firstname MidInitial. L

Re: [sqlalchemy] sanitizing sql with sqlalchemy

2013-01-01 Thread Werner
On 01/01/2013 19:34, alonn wrote: Actually I don't know what's causing the corruption but the "." looks like the only unvalid one in a varchar field. Why would a "." in a varchar field not be valid? Just consider something like "Firstname MidInitial. LastName", why would that not be valid in

Re: [sqlalchemy] sanitizing sql with sqlalchemy

2013-01-01 Thread alonn
Actually I don't know what's causing the corruption but the "." looks like the only unvalid one in a varchar field. since after the insert the table just stopped working (not responding to SELECT or DELETE) while the rest of the tables works fine so I'm looking for something like html markupsaf

Re: [sqlalchemy] sanitizing sql with sqlalchemy

2013-01-01 Thread Werner
On 31/12/2012 23:24, alonn wrote: I'm using sqlalchemy orm (with turbogears) to write data from a web application to an mssql 2005 Db (used by another application, not maintained by me). after dealing with a serious case of data corruption (basically because of user data including the "." sign)