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.