grouping does not group for squat. It still outputs in the order it was
entered in the database.
<cfquery datasource="#wire.dsn#" name="getclasses">
SELECT
classname,
rh.id as RID,
groupname,
groupid
FROM rh_classes rh
JOIN rh_classes_groups rhg on rh.groupid = rhg.id
where rh.active = 1
</cfquery>
<cfoutput query="getclasses" group="groupid">
<tr>
<td class="smallHeader" colspan="2"><font
color="gray">#groupname#</font></td>
</tr>
<cfoutput>
<tr>
<td class="maincontent"><input type="checkbox" name="check" value="#rid#">
<input type="text" name="qty#rid#" size="3" value="0"
> <td class="maincontent"><font color="##009F87">#classname#</font></td>
</tr>
</cfoutput>
</cfoutput>
Any quick "duhs"? Thanks in advance!
Regards,
Eric J. Hoffman
Managing Partner
Datastream Connexion, LLC
1.888.690.2893
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
