Thanks again for help
I followed your advice and created a quick draft in the admin section – it created the same result and did not post successfully.
I can now take Frontier out of the equation and focus on the SQL_Server drivers on PHP, which I have updated, but no success
Thank you so much for your time and assistance.
Fantastic work on this plugin!!
http://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql
http://stackoverflow.com/questions/261455/using-backticks-around-field-names/261476#261476
These threads definitely confirms it is the standard MySQL / PHP behaviour, and that
BACKTICKS(`) are used around identifier names.
It also states
The only problem with backticks is that they are not ANSI-SQL compliant, e.g. they don’t work in SQL Server.
If there is a chance you would have to port your SQL to another database, use double quotes.
I do not know where in WordPress to set this unfortunately
Hi finnj
Thanks for reply
I can assure you, I’ve recreated this 100 times over, there are no backticks submitted by users at all. Also the backticks are added in the SQL statement itself and not in the parameters that get updated.
I’ve also just found this:
After the first column that had the forward slash, all columns following thereafter in the SQL statement, erroneously get the backticks – I don’t know if this will mean anything.
Thanks
