Matthew1980 - 7:44 pm on Jul 7, 2010 (gmt 0)
>>I tried what you said - replaced the word from in the text - and the update executed successfully.
Wow! That's a new one on me, there has got to be a less convoluted way of achieving this without find/replace on both sides of the insert/select. Surely you can use a few other functions around the data being inputted and linked into the sql query to see what work knowing now that there is a 'keyword' that triggers an error/failed query.
Is this a shared server or dedicated box that your host uses, and also, local testing of this piece of code, does this produce the same error? It may be worth emailing the tech people at your hosting company to see if they are aware of this, or better still can they provide you with a list of 'trigger' words. I personally haven't yet come across this, so I am rather intrigued as to the total solution to this.