This content has been marked as final. Show 4 replies
Use the replace function. Details are in the cfml reference manual. If you don't have one, the internet does.
The output is in a loop so how would I include that in the loop. Here is what the code looks like
<cfquery dbtype="query" name="getsection">
Select entity, formatted_name, entity_type
Where entity_type = 'S'
order by formatted_name
You use it inside a loop the same way you use it outside a loop. Did the example in the manual not help?
By the way, your loop won't work properly because you are not specifying a row number. You would be better off using the query attribute of cfoutput instead.
Having read what you said and comparing it what Dan is offering to help you, I'm not sure I understand what you're trying to accomplish, but I won't let that stand in the way of me offering a solution:) I added a couple of <cfdump> tags just to show things as they build up.