Question
query output skipping every other row
I am using Coldfusion MX 7.0.1, and have two applications
using the same datasource. In one, a SELECT query followed by a
cfoutput lists all rows properly, but the following code (in the
other app) only lists every other row of the query result set, for
some reason:
<cfselect name="Record_Group" multiple="no" size="4"
required="yes" message="Select a Record Group...">
<cfoutput query="RecordGroupQ">
<cfif compare(#RecordGroupQ.RecordNum#,#Edit_origQ.acc_num#) eq 0>
<option value="#RecordGroupQ.RecordNum#" selected>#RecordGroupQ.RecordNum#</option>
<cfelse>
<option value="#RecordGroupQ.RecordNum#">#RecordGroupQ.RecordNum#</option>
</cfif>
</cfoutput>
</cfselect>
The query is in the <head>, and is:
<cfquery name="RecordGroupQ" datasource="arch_card">
SELECT RecordNum FROM RecordGroups ORDER BY RecordNum ASC;
</cfquery>
Has anyone seen anything like this before?
Thanks,
Jason
<cfselect name="Record_Group" multiple="no" size="4"
required="yes" message="Select a Record Group...">
<cfoutput query="RecordGroupQ">
<cfif compare(#RecordGroupQ.RecordNum#,#Edit_origQ.acc_num#) eq 0>
<option value="#RecordGroupQ.RecordNum#" selected>#RecordGroupQ.RecordNum#</option>
<cfelse>
<option value="#RecordGroupQ.RecordNum#">#RecordGroupQ.RecordNum#</option>
</cfif>
</cfoutput>
</cfselect>
The query is in the <head>, and is:
<cfquery name="RecordGroupQ" datasource="arch_card">
SELECT RecordNum FROM RecordGroups ORDER BY RecordNum ASC;
</cfquery>
Has anyone seen anything like this before?
Thanks,
Jason
AdChoices