Ben Nadel
On User Experience (UX) Design, JavaScript, ColdFusion, Node.js, Life, and Love.
I am the chief technical officer at InVision App, Inc - a prototyping and collaboration platform for designers, built by designers. I also rock out in JavaScript and ColdFusion 24x7.
Meanwhile on Twitter
Loading latest tweet...
Ben Nadel at the New York ColdFusion User Group (May. 2009) with: Gert Franz and Peter Bell

ColdFusion Error: The Column Name "3a" Is Invalid

By Ben Nadel on
Tags: ColdFusion

I was writing some test code for a query I am working with and I got the error: The column name "3a" is invalid. I was trying to run this line of code:

  • qTest = QueryNew( "id, name, 3a" );

While "3a" might seem like a strange column name, that is indeed the name of a column (along with MANY others that start with a number) in an actual client database. It works fine when writing SQL statements:

  • SELECT
  • id,
  • name,
  • [3a]
  • FROM
  • test

... because I can use the [ ] notation: [3a]. I tried to use the similar notation in the QueryNew() method, but to no avail:

  • qTest = QueryNew( "id, name, [3a]" );

This gives me the same error. I guess you can't simulate poorly named columns in QueryNew(). I would say that's a bug, but is it? If anything it's a flag that says "Don't name your columns with numbers."



Reader Comments

Post A Comment

You — Get Out Of My Dreams, Get Into My Comments
Live in the Now
Oops!
Comment Etiquette: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.