>>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 ?