|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
double quote / case sensitivity issues Firebird + Coldfusion
I'm not sure if this is a Firebird, Coldfusion, or JDBC driver issue... but I'll try.
Have a Firebird DB that I just connected in Coldfusion with the latest JDBC firebird driver available. The tables/columns names in the Firebird DB have mixed case. Coldfusion can see any tables named in ALL Caps (ColdFusion generated SQL: SELECT * FROM SLR). Coldfusion can see some tables with mixed case naming and will (by default) include double quotes around the table name in Coldfusion-generated SQL (SELECT * FROM "User"). However, for most tables, the double quotes are omitted from the Coldfusion generated SQL and Coldfusion instead interprets the names as ALL caps when in fact they are mixed case, causing an error: -1:GDS Exception. 335544569. Dynamic SQL Error SQL error code = -204 Table unknown CHALLENGE [the table name is actually Challenge] I would venture to say this is a Coldfusion quirk if tables with ALL caps worked and all other mixed case tables did not. But some of the mixed case named tables DO work and Coldfusion interprets them correctly and automatically applied double quotes to enforce case sensitivity. Why would some tables work with mixed case while others do not?! Could it be something in the creation of the Firebird database? Could it be a problem in translation by the JDBC driver? ![]() |
|
#2
|
|||
|
|||
|
It's definitely not ColdFusion. I'd guess it's a JDBC driver issue but it could also be an issue with the way the database was created. This problem definitely does not exist in any database I have used (Oracle, SQL Server, MySQL, or Access).
__________________
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 > double quote / case sensitivity issues Firebird + Coldfusion |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|