Hi,
I'm trying to enable my users to add, edit and delete records using the SQL Grid Selected View module from Tressleworks, however, when I try to add a dummy entry, I get this error: ExecuteScalarSQL: Incorrect syntax near 'Name'.
Here's the SQL:
Insert into third_party_phone_list (
Company Name,
Contact Name,
Reference/Account Number,
Telephone,
Telephone 2,
Email Address,
Website,
Login / Username,
Password)
Values (
'Testing create',
'Another name',
'Another reference',
'01256 000000',
'',
'another.email@solarsoft.com',
'www.solarsoft.com',
'',
'')
Last SQL Commands:
0: Select top 1 * From third_party_phone_list
1: Select top 1 * From third_party_phone_list
2: Select top 1 * From third_party_phone_list
3: Insert into third_party_phone_list ( Company Name, Contact Name, Reference/Account Number, Telephone, Telephone 2, Email Address, Website, Login / Username, Password) Values ( 'Testing create', 'Another name', 'Another reference', '01256 000000', '', 'another.email@solarsoft.com', 'www.solarsoft.com', '', '')
Please can someone advise on what I'm doing wrong?
Thanks in advance.
|