Hello, I'm getting an error
Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
but the line I am getting the error at is
<cfqueryparam value="#form.comments#" cfsqltype="CF_SQL_VARCHAR">
the field I am passing on from the previous page is
<textarea name="comments" cols="40" rows="3"></textarea>
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.
I saw on another site that if the value is blank it will usually throw up this error but only if it is an interger. It said for varchars it will automatically set it as "" if it is blank. (This was used as a quick fix)
One thread http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_21758614.html
dealt with a similar issue. But again its with intergers. Is it possible the error is on a different line then stated? Or am I missing something that is staring me right in the face?