Datassist - Spaces in database field name

Hi all,

I wonder if you could help with a little prob I've been scratching my head over for a couple of days now?

I have inherited a mysql database and been asked to create a web app for it. I used Dataassist to create the "insert, update, search and detail" pages required for my project, but am having issues with the update and insert pages where fields exist with spaces...

Bear with me...

I am aware of using ` with database fields and have used this on other sections of the project with no problem. The issue appears to be on the following line;

$WA_fieldNamesStr = "Title|First Name|Surname|Position|Company|Address 1|Address 2|Town|County|Postcode|Telephone Day|Telephone Evening|Fax|E-mail|Date Registered";

I tried this with asp and mssql and found that the same issue occured unless I set the following;

$WA_fieldNamesStr = "Title|[First Name]|Surname|Position|Company|[Address 1]|[Address 2]|Town|County|Postcode|[Telephone Day]|[Telephone Evening]|Fax|[E-mail]|[Date Registered]";

...yet when I try this in php with mysql (using `) it always fails.

Anybody have any ideas? Unfortunately we can't go asp and we have an access frontend hanging off the DB, so I can't change the field names either.

Any help greatfully received.

Dave

are you sure you are using the "`" character and not the apostrophe "'":
$WA_fieldNamesStr = "Title|`First Name`|Surname|Position|Company|`Address 1`|`Address 2`|Town|County|Postcode|`Telephone Day`|`Telephone Evening`|Fax|`E-mail`|`Date Registered`";

I can confirm that I am using the ` character. When I add it to the `First Name` section of the line above and try an insert I get the following;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'First Name``,`Surname`,`Position`,`Company`,`Address 1`,`Address 2`,`Town`,`Count' at line 1

Regards

Dave

what version of DataAssist are you using?

In version 2.0.8, the insert and update behavior will automatically enclose all columns using the ` character to avoid problems with column names like this.


if you dont edit the code, are you getting an error message?

one thing to double check is your form element names.

they will be named for for the column,so the first name form element will be named "first name":

<input type="text" name="first name" id="first name" value="" size="32" />


spaces are not valid in form element names, so this will need to be changed to:
<input type="text" name="firstname" id="firstname" value="" size="32" />


after renaming all the form elements with spaces in them, you will need to edit the insert and update behaviors to rebind the columns to the correct form elements.