ColdFusion on knows that an error occurred in that query. The error was
returned to CF from the JDBC drivers which in turn received the error from the
DB server. As I understand it, ColdFusion reported what it was told to report
by a third-party server.
Wil Genovese
Sr. Web Application
: Thursday, June 24, 2010 9:57 PM
To: cf-talk
Subject: Re: Seriously PO'd - cfqueryparam and/or struct dereference flakes
out
It's a bit more code, but if you switch to having a cfargument tag for each
parameter and enforce the type there, you can pass in your struct as an
argument collection. You'll
and/or struct dereference flakes out
The function below was written literally MONTHS ago. Worked fine the whole
time, even today... then suddenly it's throwing the error:
Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
The error points to the line in the WHERE clause, referencing a.articleId.
Next, I
Thanks everyone,
You were all correct - god help me I was actually focusing on the error CF gave
me, trusting that alone. Go figure. What a rotten thing to do! :)
A different value was the culprit, and the suggestion below absolutely applies.
Thank you all so much -- this is what happens
The function below was written literally MONTHS ago. Worked fine the whole
time, even today... then suddenly it's throwing the error:
Invalid data '' for CFSQLTYPE CF_SQL_INTEGER.
The error points to the line in the WHERE clause, referencing a.articleId.
Next, I purposely set the output=true
When CF throws an error on a stored proc, it will usually reference the last
line of the stored proc, not necessarily which line has bad data.
If I were you, I would dump the values that are being sent into the stored proc
and review to see if any of it is null or blank (or string) going into
The line number given is always the last line of the query. Make sure all the
other values are what they are supposed to be.
Wil Genovese
Sr. Web Application Developer/
Systems Administrator
Wil Genovese Consulting
wilg...@trunkful.com
www.trunkful.com
On Jun 24, 2010, at 5:43 PM, Marc
http://acoderslife.com
-Original Message-
From: Marc Funaro [mailto:subscripti...@advantex.net]
Sent: Thursday, June 24, 2010 6:43 PM
To: cf-talk
Subject: Seriously PO'd - cfqueryparam and/or struct dereference flakes out
The function below was written literally MONTHS ago. Worked
-
From: Marc Funaro subscripti...@advantex.net
Date: Thu, Jun 24, 2010 5:43 pm
Subject: Seriously PO'd - cfqueryparam and/or struct dereference flakes out
To: cf-talk cf-talk@houseoffusion.com
The function below was written literally MONTHS ago. Worked fine the whole
time, even today
9 matches
Mail list logo