Yeah, I know about the statement handle & db handle. as I said my original code is on another system and I can't remember all of it.
thanks for the idea of placeholders, it makes it look much neater. I will give it a try.
Thanks Danny