Hello,sorry for my english I'm italian I have a problem with my update sistem made with dreamweaver mx with asp. I made a form and I put an insert record behaviour. It works when the form is made of textfields but when I add a textarea to my form It doesn't work anymore, The personal web server finds error, It tells me there's a sintax error in the instruction Insert Into
on the line :
MM_editCmd.Execute
My database is access, the field the textarea insert to is a memo field
What could be the problem?
Can you help me to make it work?

The only thing I can think of off hand is that if you are specifying a field in the insert behavior that does not exist on the page.

ie, txtInfo inserts into fldInfo (when txtInfo doesn't exists) Double check the spelling of all form elements.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])

Sorry, I don't understand you very well, what are
fldInfo and txtInfo?
you told me the field doesn't exist, no the field exist
should has been a recordset in the page added to the behavior?

The problems isn't in textarea, but in memo field. The easiest solution is to use text as field type. If not, make sure memo field is the last one in a table. Same thing for SQL statements. Memo field must be last. Don't ask me why. It's the same with SQL Server.

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hello,sorry for my english I'm italian I have a problem with my update sistem made with dreamweaver mx with asp. I made a form and I put an insert record behaviour. It works when the form is made of textfields but when I add a textarea to my form It doesn't work anymore, The personal web server finds error, It tells me there's a sintax error in the instruction Insert Into
on the line :
MM_editCmd.Execute
My database is access, the field the textarea insert to is a memo field
What could be the problem?
Can you help me to make it work?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic
www.farcic.com
TalkZone Manager

Are you telling me memo field must be the last field in a database?
I changed the position of memo field but it still doesn't work!
have I understand well?

Please can you help me?? I must put a textarea in my form to insert a text in the memo field of my database. Why does it give me error??