RE: [KCFusion] ASP Problem

[Kelley, Kevin, PRK]

This is little off of subject, but I am working in asp and am displaying results of the below query in an asp page   SELECT * FROM TrainingTitle Where Active = -1 order by  Category, date, TrainingTitle   Below is the output statement I have that works but need a little tweaking   <% While ((Repeat1__numRows <> 0) AND (NOT Recordset1.EOF)) %> <%=(Recordset1.Fields.Item("Category").Value)%> <br> <%=(Recordset1.Fields.Item("TrainingTitle").Value)%>       Enrollment Min/Max: <%=(Recordset1.Fields.Item("MinMax").Value)%>   <%=(Recordset1.Fields.Item("Description").Value)%> <%=(Recordset1.Fields.Item("TrainingOrg").Value)%> - <%=(Recordset1.Fields.Item("EnrollmentPhone").Value)%> <%=(Recordset1.Fields.Item("TLocation").Value)%><br> <%=(Recordset1.Fields.Item("ContactName").Value)%> - <%=(Recordset1.Fields.Item("EnrollmentEmail").Value)%> $<%=(Recordset1.Fields.Item("Cost").Value)%><br> Date:&nbsp;<%=(Recordset1.Fields.Item("date").Value)%><br> <b>Time:</b>&nbsp;<%=(Recordset1.Fields.Item("Time").Value)%></td> </tr> <% If (Recordset1.Fields.Item("Links").Value) <> "" Then %>Reference Link: <a href="" target="_blank">Click Here</a><% End IF %> <br><br> <%   Repeat1__index=Repeat1__index+1   Repeat1__numRows=Repeat1__numRows-1   Recordset1.MoveNext() Wend %>   It displays each record as its own, but I would like to group by category, which I can accomplish easy enough in the query with a group by but not in the display results any suggestions, I have the below examples to illustrate what I am talking about:   Category TrainingTitle  Min/Max Description TrainingOrg – EnrollmentPhone TLocation ContactName - EnrollmentEmail Cost date Time <if>Links<end if>   Category TrainingTitle  Min/Max Description TrainingOrg – EnrollmentPhone TLocation ContactName - EnrollmentEmail Cost date Time <if>Links<end if>   VS   Category   TrainingTitle  Min/Max Description TrainingOrg – EnrollmentPhone TLocation ContactName - EnrollmentEmail Cost date Time <if>Links<end if>   TrainingTitle  Min/Max Description TrainingOrg – EnrollmentPhone TLocation ContactName - EnrollmentEmail Cost date Time <if>Links<end if>   Category   TrainingTitle  Min/Max Description TrainingOrg – EnrollmentPhone TLocation ContactName - EnrollmentEmail Cost date Time <if>Links<end if>   TrainingTitle  Min/Max Description TrainingOrg – EnrollmentPhone TLocation ContactName - EnrollmentEmail Cost date Time <if>Links<end if>     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Reece (Webmaster) Sent: Thursday, July 22, 2004 8:38 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] CFHTTP Problem   What is the error you are getting? At 08:16 AM 7/22/2004 -0500, you wrote: I use the following code and it errors out on me.  Anybody have an idea why this is not working?   <cfif Attributes.MakeImages> <CFHTTP Method = "get"                 URL = "" ','%20','ALL')#"                 resolveurl = 0                 path = "#localTempPath#"                 file = "tmp1.jpg"                 throwonerror = "Yes" </CFHTTP>     <cfset Variables.Temp = ImageResizer.LoadImage("#localTempPath#\tmp1.jpg")>     Thanks ahead of time.   George Quade   Richard Reece Webmaster Sunbeach Communications Inc. Website: http://www.sunbeach.net/ Email: [EMAIL PROTECTED] == Main Office == "San Remo" Belmont Road, St. Michael, Barbados W.I. Monday to Friday: 8:30AM - 5PM Tel: (246) 430-1569 Fax: (246) 228-6330 == Sheraton Centre == Monday to Friday: 9AM - 7PM == Technical Support Hours == Monday to Friday: 7:30AM - 7PM Weekends: 7:30AM - 6PM Tel: (246) 430-1575 Website: http://support.sunbeach.net