• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 551
  • Last Modified:

Referencing MS SQL Table Names with spaces and dollar signs using coldfusion

I'm running Coldfusion MX 7 and querying SQL Server 2000.  I can query normal table names with no problem.  However, I have a large database with table names formatted as follows
My Company$Customer
My Company$Location
My question is how do I reference a table named in this manner in a SQL select statement?  I've tried it in quotes and replacing the $ with a period and nothing works.  Coldfusion gives me the following error every time: "Invalid Object Name".  There are hundreds of these tables named this way and it isn't something I can change.
0
KCody
Asked:
KCody
  • 2
1 Solution
 
DxpertCommented:
try putting brakets around it [My Company$Customer]
0
 
KCodyAuthor Commented:
That was an easy fix.  Thanks.
0
 
DxpertCommented:
Glad I could help ;-)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now