Cfquery data formatting

dev support
1

Hello guys.

I’m migrating a big system from CF9 to Lucee 5, the problem is that we have a lot of CFQUERY tags in the system, but Lucee is changing the formats of smalldatetime and bit columns.

Example: CF9 returns 1 OR 0 on BIT columns, and on smalldatetime returns ‘yyyy-mm-dd HH:MM:ss’ formatted date.

Lucee 5 Instead returns True or false on BIT and {It’s yyyy-mm-dd HH:mm:ss} Formatted date on smalldatetime.

There’s a way to change it?

OS: Windows server 2012
Java Version: Lucee 5.3.4.80
Servlet Container|Apache Tomcat/9.0.20|
Java 11.0.3 (AdoptOpenJDK) 64bit|

2

@zurieeeel, Which version of SQL server you are using?

3

SQL Server 2008 R2

4

Does it matter for something?
CF 9 was using Java 7 and probably a very old JDBC driver versus current. My app was written in CF 5 and I have never had to make any modification to BOOLEAN or DATETIME variables.

5

When Debugging these things… I would look at your application page by page
CfDump the expected variables as needed then make the changes.

Its usually some bit of user defined code hiding in a template.