DO NOT REPLY [Bug 27739] - sql insert statement fails on '--' strings

[bu...@apache.org]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=27739>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=27739


danl_thompson@yahoo.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         OS/Version|                            |All




------- Additional Comments From danl_thompson@yahoo.com  2004-11-18 19:05 -------
The -- string is considered an SQL comment to end of line.  However, if the --
occurs within a delimited string, the SQL task still treats it as a comment to
end of line, as this simple task doesn't attempt to parse for string fields in
the sql statement.

A workaround is to use the keepformat="true" flag, but this turns comment
processing off entirely.  It also has a nasty habit of disliking trailing spaces
after the semicolon.  A workaround for this, is to remove all trailing spaces in
any SQL files you want to process using this comment, as well as removing all
comments from the sql file.

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org