CFQuery column names case sensitive
Posted on 2014-10-31
When doing a CFDUMP on CFQUERY, the column names are always displayed in UPPERCASE.
Is it possible to get the column names of CFQUERY is the case they were created on an SQL server ?
CREATE TABLE [dbo].[LOGIN](
[lgId] [int] IDENTITY(1,1) NOT NULL,
[lgUserId] [nvarchar](64) NULL,
[lgPassword] [nvarchar](128) NULL,
[lgRole] [nvarchar](16) NULL,
Is it possible for CFQUERY to return the column names as lgId, lgUserId, lgPassword etc... and not LGID, LGUSERID, LGPASSWORD?