HI everybody,, Am stucked... I have a query with 9 rows. I need to store every row into a different distinct variable. my query is listed below
<cfquery name="getcs" datasource="#datasource#"> SELECT COUNT(s.id) AS cscount FROM Society s WHERE s.gr='cs' group by s.asst </cfquery> <cfoutput query="getcs" startrow="1" maxrows="1"> <cfset row1="cscount"> </cfoutput> cfoutput query="getcs" startrow="2" maxrows="2"> <cfset row2="cscpimt" </cfquery> etc.... row9 I have to repeat the above code 9 times which is equivalent to the rows of my query...Is there a way of not doing this?.. thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322855 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
