Improving output from submission page

[dmorand]

I'm just seeing if there's a better way I can do this. I want to display the results from my submission page which handles adds, edits, deletes. I want to display the Name, Description, and Date Entered information on the submission page, but to display the info I need to make sure I'm using the right query name.

This is what I have currently:

<cfif URL.op IS "Edit">
    <cfoutput>Record #URL.sysID# Modified</cfoutput>
<cfelseif isDefined("Form.Add")>
    <cfoutput>Record #URL.sysID# Added</cfoutput>
</cfif>
<table class="enterEdit">
<cfif URL.op IS "Edit">
<cfoutput query="editSystem">
<tr><td align="right"><b>Name: <b></td><td>#name#</td></tr>
<tr><td align="right"><b>Description: </b></td><td>#description#</td></tr>
<tr><td align="right"><b>Date Entered: </b></td><td>#DateTime#</td></tr>
</cfoutput>
</cfif>
<cfelseif isDefined("Form.Add")>
<cfoutput query="insertSystem">
<tr><td align="right"><b>Name: <b></td><td>#name#</td></tr>
<tr><td align="right"><b>Description: </b></td><td>#description#</td></tr>
<tr><td align="right"><b>Date Entered: </b></td><td>#DateTime#</td></tr>
</cfoutput>
</cfif>
</table>
 

I'd rather have something like this:

<cfif URL.op IS "Edit">
    <cfoutput query="editSystem">Record #URL.sysID# Modified
<cfelseif isDefined("Form.Add")>
    <cfoutput query="insertSystem">Record #URL.sysID# Added
</cfif>
<table class="enterEdit">
<tr><td align="right"><b>Name: <b></td><td>#name#</td></tr>
<tr><td align="right"><b>Description: </b></td><td>#description#</td></tr>
<tr><td align="right"><b>Date Entered: </b></td><td>#DateTime#</td></tr>
</table>
</cfoutput>
 

I tried doing this but I get an error stating that there's a </cfoutput> tag with no matching <cfoutput> tag. The way I have it works, but I'm just seeing if there's a better way to do this so I don't have to re-enter the same data twice. It's a little redundant.

[acoder]

Since you're using the same field names, give the query the same name so there's no need for an if-else branch.

[dmorand]

Since you're using the same field names, give the query the same name so there's no need for an if-else branch.

Ok, I'll give that a shot. thanks!!