I want to be able to set variables for dept1, dept2, dept3, etc... using CFSET, but I never know how many deparments there will be. Here's what I had in mind, but don't know the proper syntax.
Can something like this be done? Kevin
slanek@ssd.fsi.com
Code:
<CFOUTPUT QUERY="dept">
<CFSET dept & #CurrentRow# = "myVar">
</CFOUTPUT>
slanek@ssd.fsi.com