Update Wizzard adds ' around table name
Every time I apply the Data Assist Update Wizard the code incorrectly shows
$WA_table = "`application`";
Instead of
$WA_table = "application";
How can I stop this please?
Every time I apply the Data Assist Update Wizard the code incorrectly shows
$WA_table = "`application`";
Instead of
$WA_table = "application";
How can I stop this please?
The only time I've seen that happen is when a reserved word has been used for a table name or field. It's my guess that the word APPLICATION is one of those words. I can't off the top of my head remember where the list is but I can tell you that the words STATE and DESCRIPTION will result in the same issue. What's interesting is that the codes normally runs ok - with the additional `` around the word.
Hi Les
Thanks for your reply. I will be more careful when selecting table names!
Unfortunately I get an unexpected ' error or no data gets submitted to the database if I leave the ' in place.
I will just carry on amending the code by hand.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.