SQL INSERT error on large amount of text

[John Croney]

I am getting a problem in inserting data into a table. I have a form, which is made up of INPUT and TEXTAREA fields. When trying to insert into a memo field from a textarea through <CFQUERY> I get an error [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword.

This only happens when there is a lot of text in the textarea but it would work fine if a small amount of text is submitted.

I was told to try <cfinsert> but after installing ColdFusion I can no longer amend my tables to turn on auto number and I have to now enter text in all fields due to the tables now set that all fields are required.

I also find that after saving a form a couple of times DreamweaverMX start to take very long to save a couple lines of script.

This is driving me up the wall.

Can any one help?

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---