Hi,
I received the following error within a query 'Invalid data value false exceeds
maxlength setting 1.'
I understand the error but I need to trace which parameter is having this issue
as there are lots. Is there any way of getting coldfusion to tell me?
Thanks,
Richard
Hey guys
Got at bit of a weird thing going on in my code...
Sometimes when I make a certain query, the query will return from the DB
without error, but when I try to use the query I find that the columns have
shifted, so that in a column where I would expect a date there is now a
string.
I received the following error within a query 'Invalid data value false
exceeds maxlength setting 1.'
I understand the error but I need to trace which parameter is having this
issue as there are lots. Is there
any way of getting coldfusion to tell me?
No, I don't think so. You'll
Actually, the error is telling you exactly what is wrong. You are sending a
string value of false to a field that only allows a maximum of 1
character. More than likely, you are trying to send a true/false value to a
char(1) field. Try either converting your true/false value to 1/0. Also, I
do
More than likely, you are trying to send a true/false value to a
char(1) field.
... or even more likely to a boolean field.
~|
Order the Adobe Coldfusion Anthology now!
CF only transmit what the database driver reports.
Many drivers will report an error, but not which field caused the error, which
is quite frustrating.
Sometimes, one can have more details by copying the SQL statement and execute
it in the database itself.
Got at bit of a weird thing going on in my code...
Pretty hard to tell without seing that code...
If you transfer the query result into a list and if there is one empty column,
you might shift all the values after the empty valu indeed.
I've seen this before when the query was previously a SELECT * and modified
to SELECT col1, col2, * ..., or is a SELECT * and the database schema is
modified, or other similar scenario.
Only way I remember resolving this was a CF restart. I think when SELECT *
is used there is some sort of
Somehow, my CF10 version of CFCOMPILE.BAT got wiped out [zero length
file] (in Coldfusion10/cfusion/bin)
would some kind sole send me a copy of the file to rcol...@cox.net.
TNX!!!
~|
Order the Adobe Coldfusion Anthology
this is even stranger.
when I run the compile command, it overwrites the compile.bat file and
makes it zero length.
this used to work:
C:\Windows\System32c:\Coldfusion10\cfusion\bin\cfcompile.bat -deploy
d:\inetpub
\Actavalon\company d:\actavalon\secure_source
Then, on the third or fourth try, it executed???
On 7/29/2014 1:56 PM, Richard Colman wrote:
this is even stranger.
when I run the compile command, it overwrites the compile.bat file and
makes it zero length.
this used to work:
11 matches
Mail list logo