Try changing it from cf_sql_tinyint to cf_sql_integer if you haven't
done so already.

If it still happens post a few more lines of code. I have seen errors
like this returned telling you it's one line and in fact it is another.

Phillip B wrote:

> I tried wrapping it with Val() and Trim() and neither helped.
>
> I even tried this <cfqueryparam value="1" cfsqltype="cf_sql_integer">
> and I got the same error.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to