I am using the GetColumnNames() method in a CFML program to acquire the field names of a table. I am then using these field names to build an INSERT command for a Microsoft SQL 7.0 database. The GetColumnNames method is returning the field names in all uppercase letters. Because SQL 7.0 is case sensitive, I am receiving error messages for invalid column names. Is there a way to either:
1. Return the field names with their actual case (field names have both upper and lower case letters)
2. Tell SQL Server to ignore case of field names.
Thanks for any help.