Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
but the line I am getting the error at is
Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
the field I am passing on from the previous page is
<cfqueryparam value="#form.comments#" cfsqltype="CF_SQL_VARCHAR">
I am typing a value into it and it is defined as a "varchar(MAX)" in the database. The only CF_SQL_INTEGER 's I have in my code are 2 that are about 30-35 lines away from where it is giving me this error and they match up with the database correctly.
<textarea name="comments" cols="40" rows="3"></textarea>
Join the community of 500,000 technology professionals and ask your questions.