COLDFUSION 10 VENDORERROR -104 SQLSTATE 42601

Forum|Forum|13 years ago
March 22, 2013
1 reply
1249 views

Good Afternon,

My name is Luis, where are from Brasil,

The following problem occurs

After migrarmos version of Coldfusion Coldfusion version 4.5 to 10, everything worked normally.

configure access to DB2 database via JDBC. What is happening is the recordings on the bench with the DATE field,

segie the error attached.

This topic has been closed for replies.

glamorous_Wonder6C1C

Inspiring

Hi Luis,

What is the data type for the column "data"?

Thanks

A

Aegis_Kleais

Inspiring

Luis. You might want to use <CFQUERYPARAM> to help protect your SQL queries

SELECT INTO table_name ( col_1, col_2, etc. )

VALUES ( <cfqueryparam type="cf_sql_varchar" value="text" />, <cfqueryparam type="cf_sql_integer" value="3">, etc. )

Date fields can be kinda pissy if the values put into them don't completely adhere to the right format. I'm not familiar with DB2 databases, but can you dump the value that you are attempting to put into the column so we can see how it is formatted before it's attempting to be inserted?

L

Luis_mackenzieAuthor

Participant

Ok

ok, showed variable before the insert, the dates are different, the old

Coldfusion 4.5 shows the short date.

In the new coldfusion 10 the same date code shows the long

follows the attachment.

Em 23-03-2013 14:41, Aegis Kleais escreveu:

>

Re: COLDFUSION 10 VENDORERROR -104 SQLSTATE 42601
created by Aegis Kleais <http://forums.adobe.com/people/Aegis+Kleais>
in /ColdFusion/ - View the full discussion
<http://forums.adobe.com/message/5172673#5172673

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Explore now

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.