Solved

GetColumnNames() is returning all uppercase names

Posted on 2003-10-30
5
430 Views
Last Modified: 2013-12-24
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.
0
Comment
Question by:jsprenk55
5 Comments
 
LVL 17

Assisted Solution

by:anandkp
anandkp earned 100 total points
ID: 9655574
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
 

Author Comment

by:jsprenk55
ID: 9657339
0
 
LVL 19

Expert Comment

by:cheekycj
ID: 9658873
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
 
LVL 17

Assisted Solution

by:anandkp
anandkp earned 100 total points
ID: 9662034
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
 
LVL 2

Accepted Solution

by:
jonnygo55 earned 100 total points
ID: 9696809
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

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This article explores the design of a cache system that can improve the performance of a web site or web application.  The assumption is that the web site has many more “read” operations than “write” operations (this is commonly the ca…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question