SOLVED - another one of those DER!!-Slap-the-forehead-moments
It was as Haikal said - staring me in the face but I couldnt see it.
What i needed ot learn was what the significance of the '@P5' was,
and now I know. It was parameter 5 causing the problem - comma
missing from the end of paramete
Thanks Adam, So you agree that the error message is telling me it
thinks there's a problem with the 5th parameter as far as it can
determine it.
(I know that for a database, identifying the exact cause of the
problem is an inexact science, but I'm just trying to identify what
that error message
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 da
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 wha
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