Column type datetime issue in QueryNew

language
1

I was checking an error in an CF code in Lucee . The code is much old and was running in older version of Adobe CF (may be in new version as well, but I was not able to check) and also previous version of Lucee.

In this version 5.2.9.31 I am getting an error “invalid CF SQL Type [DATETIME]”. The code is as below:

<cfset local_var.columnList = "subject,timeStart,timeEnd,studentFull"/>
<cfset local_var.typeList = "varchar,datetime,datetime,varchar"/>
<cfset temp = queryNew(local_var.columnList,local_var.typeList)/>

The datetime in the 2nd line is throwing error. If I change the datetime to timestamp, the code run successfully.
Can anyone confirm that the datetime is replaced completely by timestamp?

2

5.2.9.31 is ancient

that code just works in 5.3.9, so yeah

1 Like
3

Thank you @Zackster , I will upgrade Lucee.