Debugging an Error

Forum|Forum|19 years ago
April 16, 2007
3 replies
255 views

I have my application up and running. But, of course, there's always a problem. About 5% of students are receiving the "Application uses a value of the wrong type for the current operation." once they submit, and their information isn't being sent to the db.

I'm using Access 2003 and the comments field I have formatted as a Memo field. When not including a comment, the data submits fine.

Any ideas?

I've attached my action.cfm page.

This topic has been closed for replies.

A

Anonymous

This is one of VERY FEW reported errors since the survey opened. I just submitted a test survey will ALL characters: ;',./<>?L:"!@#$%^&*()_+= and it submitted fine..... :(

anyone have any clue how to get my cfif/insert statement working. I would really like to use it so that students can't sit there and submit multiple surveys.

D

Dan_Bracuk

Inspiring

Does it fail 100% of the time someone submits comments, or just when the comments include an apostrophe?

A

Anonymous

Have you tried using regular insert statement and specify all fileds to be insterted?

A

Anonymous

yes, but with no success....
not to mention, no success with my cfif statement either :(

here's what I "tried" to use:

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