Nope. You can alias the tables like this, though:
<cfquery name="somename" datasource="somedatasource">
SELECT EmPloYeE.Name
FROM Employee EmPloYeE
</cfquery>
This has nothing to do with CF, it's entirely based on the behaviour
of your database server (MySQL in this case).
I'd highly recommend laying out some styleguidelines for your naming
schemes. If you do that (and follow them, of course), this problem
will go away. Here's what I do:
- tables are all lowercase, words separated with underscores
- columns are camelCase with no initial cap
- abbreviations/initials are always caps. i.e. productID, DOB, etc.
Though I'd probably use dateOfBirth rather than DOB.
cheers,
barneyb
On Wed, 9 Feb 2005 11:11:24 -0800 (PST), Discover Antartica
<[EMAIL PROTECTED]> wrote:
> Right now
>
> <cfquery name="somename" datasource="somedatasource">
> SELECT EmPloYeE.Name
> FROM Employee
> </cfquery>
>
> is failing in CF. I have to have the table name with exactly the same case as
> I am referencing it.
>
> This also happens in MySQL. Is there a way to disable this case-sensitivity
> feature in CF and/or MySQL?
>
> merci!
>
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com/
Got Gmail? I have 50 invites.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193918
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
