#Replace(myQuery[oneCol][currentRow],';','<br>','ALL')#
Outputs with none of the ';' replaced with <br>.
And they almost all *do* have a ';' in them.
Here's the pared down entire logic, might be of value...
<cfloop query="myQuery">
<tr>
<cfloop list="#shortColList#" index="oneCol"> <!--- this forces your desired order --->
<cfoutput>
<cfswitch _expression_="#oneCol#">
<cfcase value="Tribe"><td nowrap><a href=""> <cfcase value="IssueDescription"><td><a href=""> <cfcase value="Participants"><td nowrap><a href=""> <cfcase value="ActionItemList">
<cfif Trim(myQuery[oneCol][currentRow]) NEQ "">
<cfquery datasource="Tribal_Matrix" name="getAIs">
SELECT Action_Item_Desc, Target_Due_Dt
FROM v_Tribal_Action_Item
WHERE Action_Item_ID IN(#myQuery[oneCol][currentRow]#)
</cfquery>
<td nowrap>
<cfloop query="getAIs">
<b>#DateFormat(getAIs.Target_Due_Dt,"mm/dd/yyyy")#</b> - #getAIs.Action_Item_Desc#<br>
</cfloop>
</td>
<cfelse>
<td nowrap>No Action Items for this Issue.</td>
</cfif>
</cfcase>
<cfcase value="IssueStatus"><td nowrap><a href=""> <cfcase value="IssueCategory"><td nowrap><a href=""
<cfdefaultcase><td><a href=""
</cfswitch>
</cfoutput>
</cfloop>
Notice that I'm doing the same exact replace in 3 different situations, the other two work fine. Just the Participants one that seems to completely ignore the replace statement somehow. Am I missing a quote or something? I'm sure it's probably something tiny like that...then again, I might be wrong and it could be much much worse than I hope!
Anyway....help and thanks!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
