|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
You don't need a fax machine to get faxes. Get a fax-to-email fax number from CallWave. Try it free.
|
|
#1
June 30th, 2004, 09:35 AM
|
|||
|
|||
|
Getting query.ColumnList *not* all upper-case
Is it possible to set an option in a query (or even in the CF server) to obtain field names (using the queryname.ColumnList variable) with the correct case as entered into the database? (Access, in this case.) Documentation says that "by default" column names are converted to uppercase -- I'm hoping that means there's a non-default mode.
Thanks.
|
|
#2
June 30th, 2004, 10:34 AM
|
|||
|
|||
|
I don't believe so, and if you are doing anything that depends on the case of the column names I'd say you're introducting an unwanted dependency between your application and your RDBMS. For example, Oracle stores *everything* as upper case (table names, column names, index names, etc.) whether you want it to or not. So I don't think there's any way to change this behavior.
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Getting query.ColumnList *not* all upper-case |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
