Hey, I don’t know if it is hepful to add a little update. I hope all is well and you can get to this fix for this regression. I know I sure would appreciate this getting fixed. I have a feeling that there are about 10 more customers of mine that just have not complained because they have not used their website admin for a long time.

Thanks for all you do! Have good one

Lucee 5.3.2.77 Error (database)
Message An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as “” or [ ] are not allowed. Change the alias to a valid name.
DatabaseName Microsoft SQL Server
DatabaseVersion 14.00.3335
DriverName Microsoft JDBC Driver 4.0 for SQL Server
DriverVersion 4.0.2206.100

Thanks for the update. I do like Gunter’s suggestion of moving up to 5.2.9.3.1. We are running into all sorts of issues on version 4.5.2. It didn’t cross my mind to at least try to upgrade a little bit to try to resolve other problems we’re running into.

@Zac Spitzer, adding this to the agenda of our next standup. Stay tuned.

I did some investigation concerning this issue back in November, and came to this conclusion (https://dev.lucee.org/t/lucee-5-3-3-62-and-cfinsert-cfupdate/6245/27):
It broke somewhere around 21 Sep 2018 (and in 5.3.1.95), so I downgraded Lucee to 5.2.9.31, and it works fine.
This, together with the webservice problem I experienced (CF / Lucee incompatibility for createObject() / SOAP request), it’s safe to say that I better stick with 5.2.9.31 for now.

@Patrick Quinn any feedback?

@Tim Holt which version did this use to work with before the regression?