and both ended up being wrong after I thought about it for a while.
Someone else may be able to post the "right" solution, but in the
interim, you could
<CFQUERY NAME="getrelevantrows">
SELECT user, max(lineupid) as maxlineupid FROM tablename
group by user
</CFQUERY>
<CFLOOP QUERY="getrelevantrows">
<CFQUERY NAME="getspecificrow">
SELECT * FROM tablename
WHERE user=#user# and lineupid=#maxlineupid#
</CFQUERY>
<CFOUTPUT QUERY="getspecificrow">
<!--- output the row data, or user CFLOOP to
construct a new query object to work with
containing all the right data --->
</CFOUTPUT>
</CFLOOP>
I bet there's a better way though. Maybe possible by joining the table
to itself or something...
- Rick
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
