intermittent Invalid parameter binding(s)

[avig]

I use cfqueryparam extensivily in all my code with MSSQL. It always worked and
NEVER errored in CFMX 6.1. I recently upgraded to 7.01, and I get intermittent
errors about once a day (on different random queries). Looking at the error
emails I get, the queries should work. One time they will work, then they
don't. The error I get is Invalid parameter binding(s). Anyone else
experiencing this?

[Doryphores]

I have the same problem here. The same intermittent error occurring since we upgraded from CFMX 7 to CFMX 7.0.1 (could be unrelated to the upgrade).

Have you solved this one yet?

Martin

[avig]

I havn't been able to solve it at all. The only thing I have done is remove the SQL binding.

[Doryphores]

When you say you removed the bindings, do you mean you're not using cfqueryparam anymore?

[avig]

unfortunately yes...It was the only way to stop the errors from happening. I
just didn't have the time to troubleshoot it as I was slammed with projects. I
get all kind of strange things happeneing since up grading from cfmx 6.1 to
7.01. Even JRUN seems to be crashing and restarting every week or so from
memory leaks...UGH...why did I upgrade

[DaveyS]

Sorry i was getting an CF / NNTP error with all those posts.

Did you have DataDirect JDBC 3.5 and the latest sequel link updates installed?
As far as I can tell they're not contained in the 7.01 updater

[avig]

All I did was install the 7.01 installer. I upgraded directly from 6.1. I havn't added any patches at all. I am using MSSQL, so maybe I should update those other things?