dont know why my query got all garbled but I hope this looks better <cfif application.queryStatus IS 1> <cfquery datasource="#productdsn#" name="PriceBreaksQuery" dbtype="ODBC"> SELECT * FROM Pricing </cfquery> <cfset pricebreaks = ArrayNew(2)> <cfloop query="PriceBreaksQuery"> <cfquery datasource="#productdsn#" name="PriceBreaksLoop" dbtype="ODBC"> SELECT * FROM Pricing WHERE Major_Cat = '#Major_Cat#' </cfquery> <cfset looptracker = 0> <cfloop query="PriceBreaksLoop"> <cfset looptracker = (looptracker + 1)> <cfset pricebreaks[Major_Cat][looptracker] = PriceBreakLoop[1][looptraker]> </cfloop> </cfloop> ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
