Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL dB, unknown column names with spaces

Status
Not open for further replies.

diggy8

IS-IT--Management
May 24, 2002
35
US
I'm working on converting an app from ASP and ColdFusion. It's all powered by SQL stored procedures that I can't change and with one of the procedures, the returned columns are dynamic and some of these columns have a space in the name. One such column is "BAR CODE" and when I evaluate it, get the error...

Code:
Invalid CFML construct found on line 1 at column 5.

ColdFusion was looking at the following text:
CODE

So then I tried evaluating query.[column name] and get the same error. Lastly, I tried just [colum name] and got the same error, but the problem text was the leading "[".

The other confusing part is why it's saying the error is on line 1 when the code is on line 45 of the page.

Please help!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top