phillystyle123
asked on
simple recordcount for output query
can't get this: each of the following timeslots repeats 15 times but i'm only showing 1. how can i show the record count for each unique repeating timeslot
eg:
February 6, 2004 8:30 AM (15 timeslots remain)
February 6, 2004 1:30 PM 6 (15 timeslots remain)
February 7, 2004 8:30 AM 6 (15 timeslots remain)
February 7, 2004 1:30 PM 6 (15 timeslots remain)
February 16, 2004 8:30 AM 6 (15 timeslots remain)
February 16, 2004 1:30 PM 6 (15 timeslots remain)
here's my code:
<cfquery name="rsTimes" datasource=#MM_connCalArts _DSN# username=#MM_connCalArts_U SERNAME# password=#MM_connCalArts_P ASSWORD#>
SELECT timeslots_theater.timeslot s, mix_theater.cities_id, cities_theater.cities,
mix_theater.timeslots_id, mix_theater.mix_id, timeslots_theater.id FROM timeslots_theater,
mix_theater, cities_theater WHERE timeslots_theater.id = mix_theater.timeslots_id
AND cities_theater.id = mix_theater.cities_id AND cities_id = '#rsTimes__MMColParam#'
group by timeslots
order by timeslots asc
</cfquery>
>>>>>>>>>>>>>>>>>>>>>>>>>> >
<cfoutput query="rsTimes" group="timeslots">
<li><A HREF="application.cfm?#Tri m(MM_keepU RL & Iif(MM_keepURL NEQ '',DE('&'),DE('')) & 'mix_id=' & rsTimes.mix_id)#" class="craig">#dateformat( rsTimes.ti meslots, 'mmmm d, yyyy')# #timeformat(rsTimes.timesl ots, 'h:MM tt')#</A>
</cfoutput>
eg:
February 6, 2004 8:30 AM (15 timeslots remain)
February 6, 2004 1:30 PM 6 (15 timeslots remain)
February 7, 2004 8:30 AM 6 (15 timeslots remain)
February 7, 2004 1:30 PM 6 (15 timeslots remain)
February 16, 2004 8:30 AM 6 (15 timeslots remain)
February 16, 2004 1:30 PM 6 (15 timeslots remain)
here's my code:
<cfquery name="rsTimes" datasource=#MM_connCalArts
SELECT timeslots_theater.timeslot
mix_theater.timeslots_id, mix_theater.mix_id, timeslots_theater.id FROM timeslots_theater,
mix_theater, cities_theater WHERE timeslots_theater.id = mix_theater.timeslots_id
AND cities_theater.id = mix_theater.cities_id AND cities_id = '#rsTimes__MMColParam#'
group by timeslots
order by timeslots asc
</cfquery>
>>>>>>>>>>>>>>>>>>>>>>>>>>
<cfoutput query="rsTimes" group="timeslots">
<li><A HREF="application.cfm?#Tri
</cfoutput>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.