>
> There is no need for such an escape sequence because semicolons
> in strings are not special. Maybe it's an ADO bug.
>
Paul et al - I think his problem is with quotes, not semicolons. The line
"Update tblCompany SET CoName='"\;tester"\;' WHERE CoID=109" is what
leads me to believe this.
Try double-escaping your quotes. A single escape usually only works until
the first time it's referenced in code, at which time it is unescaped and
becomes a straight quote again. I've had problems with this as well, but
\\" seems to work well. A RegExp replace on the fly just before the update
is how I usually handle it in ASP.
Jay Fesco
"Confusing issues since 1963"
Magical Mystery Words: database,sql,query,table
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
