Very basic Data Output question

[roblaw]

I have an MSAccess database with a text field named 'field1'. The value of the
records in that table are formatted as follows: #dynamic# red widgets #dynamic#
blue widgets blue #dynamic# widgets etc.... When I pull the records from the
DB, I am outputting in a list. <cfset dynamic='myValue'> <cfloop
index='theField' query='myQuery'> <cfoutput> #theField# </cfoutput>
</cfloop> My problem is that the output displays as: #dynamic# red widgets
#dynamic# blue widgets blue #dynamic# widgets When I need it to display as:
myDynamic red widgets myDynamic blue widgets blue myDynamic widgets Is there a
formatting option that will allow this database field to output with the
#dynamic# value resolved in the page? Thanks much. roblaw

[ksmith]

Hi Roblaw, Your explanation of what you are trying to do is not clear. But,
the cfloop/query only takes the queryname and optionally the start and end row.
There is no index using the query form of cfloop. Cfoutput takes a query
attribute and will then loop throw each row of your result. So your code
probably needs to look more like:

<cfoutput query="myQuery">
#field1#
</cfoutput>

or possibly:
<cfloop query="myQuery">
<cfoutput>
#myQuery.field1#
</cfoutput>
</cfloop>