jsprenk55
asked on
GetColumnNames() is returning all uppercase names
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
usually when you query a DB in CF, column names are not case sensitive so using getcolumnnames() should not cause any problems. Have you had problems with it?
CJ
CJ
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
http://livedocs.macromedia.com/coldfusion/6/Using_Server-side_ActionScript_in_ColdFusion_MX/query5.htm