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.
jsprenk55Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

anandkpCommented:
using "query_name.ColumnList "
Returns a comma-delimited list of the query columns.

U'll get all column names formatted in uppercase & also sorted in ascending order !
I dont think theres a way to bypass this !
I wonder abt GetColumnNames() method .. where did u get this from ?

let me know

K'Rgds
Anand
0
cheekycjCommented:
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
0
anandkpCommented:
Exactly - thats with FLASH ...

U wrote "GetColumnNames() method in a CFML program" :

so i thought u had written a CFM file !
My Apologies for misunderstanding !
0
jonnygo55Commented:
well in your sql statement
you could do something like to have SQL ignore case...

select * from tblColumnNames
where lower(ColumnName) = #lcase(ColumnNametoCompare)#

lcase is cold fusion not sure if that is equivilent in Flash....
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.