like ' ,"; etc?
Kore Peterson
John Croney
<[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]>
net.com> cc:
Subject: SQL INSERT error on large amount of text
04/07/2004
10:44 AM
Please respond
to cf-talk
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]
