Specify data to display

[Natomas]

Hi,
I pass form.name="a, b, c" from page 1 to page 2, where a, b, and c represent three corresponding columns in the source data table. On page 2, I want to display the data for a, b, and c. The problem is that the string in form.name may vary depending on the user choice. It can be "a, b, c" or "b, d" or something else. I need help in specifying the column names in a cfloop. Please see the attached code with question marks.

Thanks,
New to this forum

[Dan_Bracuk]

try #report[listitem][currentrow]#

it might work, or it might not.

[Natomas]

It did not work. Thanks anyway!

[-__cfSearching__-]

> <cfquery datasource="#dsn#" name="report">
> select year, group, indicator, #form.name#
> from data
> </cfquery>

That is an invitation to sql injection.

> It did not work.

Did not work how? Without having tried it, it looks right.

[Natomas]

I understand the risk of sql injection. Just use it to illustrate the problem.

#report[listitem][currentrow] did not work because after I substituted it for ??????, the web page came back blank.

[Dan_Bracuk]

quote:

---

Originally posted by: Natomas
I understand the risk of sql injection. Just use it to illustrate the problem.

#report[listitem][currentrow] did not work because after I substituted it for ??????, the web page came back blank.

---

What happens if you put this right before your table?
<cfdump var="#report#">
<cfflush>