DataAssist adding ' character to table name

I have been trying to use the DataAssist single record update behaviour to update a field.

However all the attempts / testing failed. On checking the support forum I found the suggestion to using die($WA_Sql); to inspect the query string. This demonstrated that the table name was incorrect - having extra ' characters before and after the name.

On checking the code I found:-

$WA_connection = $dbconnection;
$WA_table = "`admin`";
$WA_redirectURL = "admin.php";
$WA_keepQueryString = false;

On changing "`admin`" to "admin" then everything worked OK.

The behaviour of adding the extra ' is consistent. Within Dreamweaver in the Server Behaviours section one can also see the extra 's - as in Update Record ('admin')

Having to manually edit the code is a real time waster - can you think what DataAssist is doing this ?

Many thanks,
Dave Ellis

Dave,

It may because there are certain key words that are used as commands, descriptors, and otherwise - in either mysql or php.

And if it is a reserved word of sorts, the typical practice is that using quotes allows you to continue using the reserved word as you desire provided there is an extra quote string.

For example, the mysql documentation on this can be found here: reserved-words.html

You'll see why - in the same reason - if you name your column "desc" for description, when your select statement is made, it will do the same thing making it look like 'desc' - to denote that you are using a reserved word for your own descriptor.

Hope some of that helps,

Brian