Look at it from the database's point of view? What would be causing to
not like your query?
9/10* times I've seen this error. it's because you've got a stray single
quote outside your cfqueryparam tag.
* 7/10 stats made up on the spot.
Mike Kear wrote:
I'm getting an error message during
HI Mike,
Do you have access to the SQL server? Try running using SQL Profiler to see
what is happening on the database end.
Narrow down the Profile Trace to your database and a specific user name. Use
select db_id() to return the database id to use as a parameter of the trace.
Now you can
Hi Mike,
It's a tedious task but I would start by removing the cfqueryparam one
field
At a time and see which one is causing the problem.. its likely going to
be around the 5th input parameter.
Once you have found the offending parameter, check the cfsqltype of the
cfqueryparam and check the