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

Using UNION ALL in a SQL statement in CF and getting too few parameters error.

I am using ColdFusion and MS Access.  I have a UNION ALL query in MS Access that I am attempting to call from a CF page.  I am getting a 'too few parameters' error message.

Can you sometime tell me how to get around this?

  • 2
1 Solution
Rey Obrero (Capricorn1)Commented:
in most cases  'too few parameters' error message is caused by error in the names of the fields from the query..

dkbailey1Author Commented:
I can run the query just fine in MS Access when I do SELECT * from queryname from CF, I get the error message too few parameters.

Thanks for you help, any other suggestions?
dkbailey1Author Commented:
I figured out my problem.  Take the points.  Thanks for your help.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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