Originally Posted by AndrewGSW
You didn't take-to my first code though? Took me a couple of hours to forge that
. I still don't know whether it works, but expect that it would.
Don't be mad at me.
I did read it, and I do appreciate all of your effort. But honestly, that code was way over my head!!!
It also seemed like you weren't sure about some aspects of it, so that made me a little nervous, because code like that I'd have to take on blind faith.
It is regarded a poor practice to execute SQL statements in a loop, even with relatively small data-sets. Supposing a number of people are running the page at the same time? It's a burden on the server.
I suppose so.
And if one of the query-attempts fails, but previous ones succeeded, how will you handle this situation?
I throw an error message whenever a query fails, so the entire update would halt and they would have to try again or contact the Admin. That is reasonable.
If you are referring to me saying your code was "innovative, yet crazy", then you are welcome.
And back to your comment about the effort you put in, again, I appreciate that.
I would like to use your latest code, but I have also been stuck trying to get this script working for the last 3-4 weeks...
(You may recall that you and Tango helped me with another aspect of this script around Christmas?!)
I'm not sure what to do...