Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesFirebird SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old April 5th, 2005, 11:43 AM
hello2u hello2u is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Mar 2005
Posts: 4 hello2u User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 7 m 7 sec
Reputation Power: 0
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?

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > double quote / case sensitivity issues Firebird + Coldfusion


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway