>>Hi everybody,
>>
>>The following piece of code I would assume is supposed to put carriage return between each delete and insert, right?
>>

>>strSQL.AppendFormat("DELETE EventTargets WHERE EventID = {0}\n",
>>                e.Keys["EventID"]);
>>
>>            foreach (ListItem Item in lsbTargets.Items)
>>            {
>>                if (Item.Selected)
>>                {
>>                    strSQL.AppendFormat("INSERT INTO EventTargets VALUES({0},'{1}')\n",
>>                        e.Keys["EventID"], Item.Value);
>>                }
>>            }

>>
>>However, I see DELETE EventTargets where EventID=32INSERT... in the debugger. So, apparently my guess that \n is supposed to be CRLF is wrong.
>>
>>Or do you see what else may be wrong in this code?
>>
>>Thanks in advance.
>
>AppendFormat just adds to the end of a string. It allows you to "parameterize" content of the string. It has nothing to do with CR/LF.

But there's no reason why the string should not include a newline ?