Help with dynamic output using Form.variable

[jen_ren]

Well here is my situation:

Survey answers insert into access db. Working fine.

Viewing the results:
I have a form that you can choose by who enter it and what answer to a
question you want to view.
My is, I think working fine. Its the output list that is not, all I get is
variable name the amount of times it is in the db instead of getting the
answers to the question.

So, when #Form.question# = FA1 3 times in the answers table. My output is,
minus the <hr> :
FA1
FA1
FA1

What am I not understanding here?

Here is the query:
<cfquery name="yourView" datasource="development">
SELECT '#Form.question#' FROM answers WHERE staffTitle = ('#Form.position#')
</cfquery>
Here is what I am trying to use to get my output:
<cfoutput query="yourview">
<td width="715" class="bullets">
<p>#Form.question#<br></p>
<hr align="left" width="50%" size="1" noshade>
</cfoutput>

[dempster]

It looks like you have a couple of mistakes in your code. To use the form
input to specify a field name in the select, don't use quotes. You just want CF
to substitute the value into the SQL statement (such as SELECT FA1 and not
SELECT 'FA1' ). In your output, you are specifying the text value of the form
field, not the database field with that name. If you use AS in your SQL to give
the field name an alias, this will be easier.

<cfquery name="yourView" datasource="development">
SELECT #Form.question# AS question FROM answers WHERE staffTitle =
('#Form.position#')
</cfquery>
<cfoutput query="yourview">
#question#<br>
</cfoutput>

[jen_ren]

Thanks for helping me see that. It works perfectly now.
Feel like I belong in duhhhhhville!!!! HAHAHAHa
Have a great day:D:brokenheart;