Hi I'm not new to the Dreamweaver side of UltraDev but I am new to the Dev side of it.

I'm trying to create a simple insert record form for a page on my website. I have the DSN set up correctly, it finds it ok, and the test works correctly.

However when I click on the submit button, I get an error saying that I have a syntax error in my INSERT INTO statement. ?????

UltraDev wrote that statement so I'm assuming I have a configuration error somewhere in order for UltraDev to write an invalid statement.

Has anyone ever seen this or had the same problem? Please help.

Thx.

QB

QB,

most likely you have setup the database so that it accepts only specific values for a table cell when you insert a record into the table. When you tell me what kind of database you are using and what the error reported was I might be able to help you.

For example be sure that you don't try to insert text into number columns.

Waldo Smeets - www.UDzone.com Webmaster
------------------------------------------
www.UDzone.com : A Dreamweaver, Ultradev and Fireworks recourse site for developers
by developers.
------------------------------------------

Sorry man, that was dumb of me not to include that info.

I'm using ASP connecting to an Access 2000 database.

Here's the error message I recieve:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.

/PSO/PSOPA/TMP3ysrg9dqzv.asp, line 90

Hope you can help.

Thx

Tony

Well its not the data type. I double checked the field in the table in the Access database and they are all set to text. Then I doubled checked the insert record behavior in UltraDev and all the fields are set to text also.

Anymore ideas? I hope so! <img src=icon_smile.gif border=0 align=middle>

Tony

I had some problem like this before.
Try to check column name in table. Once I had one column name "Note". It's started work, when I rename this column to "Discription".