I am trying to duplicate the functionality of Microsoft Merge
reports so that users can create a template which would later
display with information dynamically inserted from a "User" table.
I know (or think) that this should somehow involve the
Evaluate function to dynamically interpret the varibles involved
but it isnt working. Can someone point me in the right direction?
I have a query called "Users" that has the columns
"FirstName" and "LastName". This is my reasoning code wise...
-----------------------------------
<cfset theMessage = "Hello #Users.FirstName#
#Users.LastName#, Welcome to the group">
<cfloop query="Users">
#Evaluate("theMessage")#
</cfloop>
This is what I intended to output
- Hello John Doe, Welcome to the group
- Hello Bob Smith, Welcome to the group
- Hello Jane Smith, Welcome to the group
but this is what actually gets output
- Hello #Users.FirstName# #Users.LastName#, Welcome to the
group
- Hello #Users.FirstName# #Users.LastName#, Welcome to the
group
- Hello #Users.FirstName# #Users.LastName#, Welcome to the
group
anyone have any ideas? thanks.