ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 27739] - sql insert statement fails on '--' strings
Date Thu, 18 Nov 2004 18:05:10 GMT
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


Mime
View raw message