Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

GetColumnNames() is returning all uppercase names

Posted on 2003-10-30
5
435 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

839 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