Dreamweaver MX Insert Record Server Behavior Error

[m_james722386749]

Please help!

I am using dreamweaver MX v6.1

when i try and connect to my sql database in order to use the server behavior's, 'insert record' or 'recordset', it will connect to the database, see the table, but not any of the fields/columns within the table! however when i perform a test on the recordset i can see all of the information within the fields in the table.

the field names in the table on the database relate the names in the form all ok

i can't perform an insert record through dreamweaver if i can't see the columns

i hope this makes sense!

any help would be apreciated, ive been on this for ages lol

[Jason Byrnes]

Most likely, there is a column name that uses a MySQL reserved word that is causing the error.

Double check your column names against this list:
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html


NOTE:
We no longer support for Dreamweaver MX, the earliest version of Dreamweaver we can offer support for is Dreamweaver 8.

[m_james722386749]

[QUOTE=Jason Byrnes;11995]Most likely, there is a column name that uses a MySQL reserved word that is causing the error.

Double check your column names against this list:
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html


Hi, thanks for the reply, ive checked my column names against that list, its not that. Ive also tried creating a really basic form with 3 fields and made a new database and table for it in myphpadmin, the same thing is happening. in the server behaviors i can connect to the database fine, it sees the table, but doesnt see any of the columns! its so annoying!