Tony, I have only experienced the type of problems you describe when dealing with content pasted from a Microsoft product, the most likely candidate being Word. Is this where the problem content is originating from?
Also, what version of the mysql JDBC driver are you using? If it is not a recent version then it may be worth a shot to upgrade. A search of the mail list archives should reveal the property that logs the SQL statements (although I seem to recall that not all operations are logged). HTH, Scott -- Scott Eade Backstage Technologies Pty. Ltd. http://www.backstagetech.com.au > From: "Tony Spencer" <[EMAIL PROTECTED]> > > When I call save on an object Torque doesn't seem to be properly handling > certain characters such as ' and ". I get weird crap after the insert is > performed. For instance: > > ORIGINAL TEXT: > Federal Computer Week named SSB one of the �Top 10 companies to watch� and > concluded, �Of the compliance software we�ve seen, InFocus offers the most > power.� A Government Computer News analyst stated, �The best tools I�ve seen > for Section 508 compliance come from SSB Technologies.� > > TEXT AFTER INSERT (i did a select in mySql to get this) > Federal Computer Week named SSB one of the ?Top 10 companies to watch? and > concluded, ?Of the compliance software we?ve seen, InFocus offers the most > power.? A Government Computer News analyst stated, ?The best tools I?ve seen > for Section 508 compliance > come from SSB Technologies.? > > TEXT AS IT APPEARS WHEN RETRIEVED AGAIN VIA TORQUE > Federal Computer Week named SSB one of the Top 10 companies to watch and > concluded, Of the compliance software weve seen, InFocus offers the most > power. A Government Computer News analyst stated, The best tools Ive seen > for Section 508 compliance come from SSB Technologies. > > Has anyone experienced the same problems? Do you know if there is a debug > property I can turn on to view the SQL generated to create inserts on a > table? Any suggestions? > > I would think that Torque is generating prepared statements which should > handle the quotes properly. > > I'm using MySQL v. 3.23.53 and org.gjt.mm.mysql.Driver. > > Thanks, > Tony -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
