hi,when i submit a form with memo field, I am limited to 500 characters. I am using cf8 and access 2010 database, I have enabled clob at the datasource.The error I get when I click the submit btn on the form is : Error Executing Database Query.Application uses a value of the wrong type for the current operation. Theerror exists at the form fields line.There is no error if under 500 characters<textarea name="civilUsed" cols="60" rows="21" class="input" id="civilUsed"></textarea>thank youjim

Inspiring

Question

memo form field erro when characters exceed 500

Forum|Forum|15 years ago
August 5, 2010
1 reply
818 views

hi,

when i submit a form with memo field, I am limited to 500 characters. I am using cf8 and access 2010 database, I have enabled clob at the datasource.

The error I get when I click the submit btn on the form is :

Error Executing Database Query.
Application uses a value of the wrong type for the current operation.

Theerror exists at the form fields line.

There is no error if under 500 characters

thank you

jim

This topic has been closed for replies.

J

JR__Bob__Dobbs

Inspiring

Providing your code would help us troubleshoot your problem.

R

rockhikerAuthor

Inspiring

Hi I posted yesterday and you replied. I believe that if I use the query and cfparam vs. cfinsert , this might go away. I'll get back to you after I finish - thank you for responding

Jim

Error Executing Database Query.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded