RE: [KCFusion] ASP Problem

[Jones Matt]

set a "check" variable to an empty value before the loop where you are displaying the category, check to see if the "check" is the same as the category.  if it is display the category, and set the "check" variable = category      -----Original Message----- From: Kelley, Kevin, PRK [mailto:[EMAIL PROTECTED] Sent: Thursday, July 22, 2004 10:30 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] ASP Problem I am using cf on the internet, but my intranet server is asp, so I am locked in.  I know it is a simple fix but I cannot figure it out.  I have done this several times in cf and your suggestion works perfect, but not this time in asp.    Any help would be appreciated   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daryl Banttari Sent: Thursday, July 22, 2004 10:29 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] ASP Problem   Easy!  Just use <cfoutput query="..."  group="..."> .... er... uh... nevermind.   I think I see your problem... ;-)   --Daryl ----- Original Message ----- From: Kelley, Kevin, PRK To: [EMAIL PROTECTED] Sent: Thursday, July 22, 2004 8:42 AM Subject: RE: [KCFusion] ASP Problem   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=""Links").Value)%>" 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 = ""                 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 ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________