Put ; on end of statement <delete id="deletesomething"> -- Delete children delete from thattable where thisid = #value#; -- Delete parent delete from thistable where thisid = #value#; > </delete>
On Tue, 1 Feb 2005 18:46:23 +0100 (CET), Kit Cragin (JIRA) <[email protected]> wrote: > Add ability to preserve newlines within statement bodies. > --------------------------------------------------------- > > Key: IBATISNET-23 > URL: http://issues.apache.org/jira/browse/IBATISNET-23 > Project: iBatis for .NET > Type: New Feature > Versions: DataMaper 1.5, DataMapper 1.1 > Environment: .NET Framework 1.1 > Reporter: Kit Cragin > Priority: Minor > > The following examples do not result in the correct SQL command being sent to > the database: > > 1. Database comments (e.g. "--") interleaved with SQL text. > > <delete id="deletesomething"> > -- Delete children > delete from thattable where thisid = #value# > -- Delete parent > delete from thistable where thisid = #value# > </delete> > > The reason is that new lines are removed so you end up with this SQL command: > "-- Delete children delete from thattable where thisid = @value -- Delete > parent delete from thistable where thisid = @value". > > 2. Interleaved XML comments: > > <delete id="deletesomething"> > <!-- Delete children --> > delete from thattable where thisid = #value# > <!-- Delete parent --> > delete from thistable where thisid = #value# > </delete> > > This doesn't work because newlines are removed and the statements are > concatenated without any whitespace in between: "delete from thattable where > thisid = @valuedelete from thistable where thisid = @value" > > A feature in which new lines are preserved in a multiline statement would > allow the correct SQL command to be sent to the server. > > -- > This message is automatically generated by JIRA. > - > If you think it was sent incorrectly contact one of the administrators: > http://issues.apache.org/jira/secure/Administrators.jspa > - > If you want more information on JIRA, or have a bug to report see: > http://www.atlassian.com/software/jira > >
