>- see footer for list info -< You need to sort this out first. Element USER is undefined in SESSION. The error occurred in D:\inetpub\wwwroot\cfpages\Bullying\_report.cfm: line 23
21 : <tr> 22 : <td valign="top" colspan="4"> 23 : <b>#Session.User#</b> 24 : </td> 25 : <td valign="top" colspan="4"> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Swingewood Sent: 16 October 2006 14:02 To: [email protected] Subject: RE: [CF-Dev] Grouping and formatting ...? >- see footer for list info -< Hmmmm weird ..... I now have the data outputting but not in the way I want. http://www.bgfl.org/cfpages/bullying/_report.cfm?repid=1 I need to get the details of ID 243 on one line ... Regards - Paul >From: "Paul Swingewood" <[EMAIL PROTECTED]> >Reply-To: Coldfusion Development <[email protected]> >To: [email protected] >Subject: RE: [CF-Dev] Grouping and formatting ...? >Date: Mon, 16 Oct 2006 13:53:05 +0100 > >>- see footer for list info -< >This doesn't do what I expected.... It does what I had anyway ..... > >http://www.bgfl.org/cfpages/bullying/_report.cfm?repid=1 > >Regards - Paul > > >>From: "Snake" <[EMAIL PROTECTED]> >>Reply-To: Coldfusion Development <[email protected]> >>To: "'Coldfusion Development'" <[email protected]> >>Subject: RE: [CF-Dev] Grouping and formatting ...? >>Date: Mon, 16 Oct 2006 13:00:34 +0100 >> >> >- see footer for list info -< >>Under each section you just need to do a grouped cfouput, grouping by >>the column that you wish to use as a heading. >> >>E.G. >><cfoutput query="report1"> >><h2>#IncidentIDPK#</h2> >><cfoutput group="IncidentIDPK"> >> yourfields here >></cfoutput> >></cfoutput> >> >> >>Russ >> >>-----Original Message----- >>From: [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] On Behalf Of Paul >>Swingewood >>Sent: 16 October 2006 12:52 >>To: [email protected] >>Subject: [CF-Dev] Grouping and formatting ...? >> >> >- see footer for list info -< >>Hi all I have never really understood grouping etc and could do with a >>little help (Again..!) >> >>I want to display a report like this >> >>Incident Ref No Racist Homophobic Disabilist Religiously >>Motivated Cyber Other >> 414 1 1 1 >> >>0 0 1 >> >>I have 3 tables joined to get the data >> >>tblincidents >>IncidentIDPK >>DFESNO >>IncidentDate >> >>tblIncidentToBullying >>BullyingTypeIDPK >>IncidentIDFK >>BullyingTypeIDFK >> >>tblBullyingTypes >>BullyingTypeIDPK >>BullyingType >>FormPosition >> >> >>It could be (and probably will be) that there are several types of >>bullying for each incident (hence the incident to bullying table. So >>the output might produce something like : >> >>Incident 414 >> >>Racists >>Homophobic >>Other >> >>I then want this to arrange on one line so that its shown (and >>counted) as one incident! >> >>This is waht I have .... >> >> >><!--- Which report do you want? ---> >> >><cfswitch expression="#url.RepID#"> >> <cfcase value="1"> >> <!--- REPORT #1 ---> >> <!--- Get the details of report #1---> >> <cfquery name="Report1" >>datasource="#Application.RacistDSN#"> >> SELECT tblIncidents.IncidentIDPK, >> tblIncidents.DFESNo, >> tblIncidents.IncidentDate, >> tblBullyingTypes.BullyingType >> FROM tblIncidentToBullying >> INNER JOIN tblBullyingTypes ON >>tblIncidentToBullying.BullyingTypeIDFK = tblBullyingTypes.BullyingTypeIDPK >> INNER JOIN tblIncidents ON >>tblIncidentToBullying.IncidentIDFK = tblIncidents.IncidentIDPK >> </cfquery> >> >> <!--- HEADER ---> >> <cfoutput> >> <table border="0" class="EDDIEitemTable" width=95%> >> <tr> >> <td valign="top" colspan="4"> >> <b>#Session.User#</b> >> </td> >> <td valign="top" colspan="4"> >> <b>#Session.DFESNo#</b> >> </td> >> </tr> >> </table> >> </cfoutput> >> >> <!--- Spacer ---> >> <table cellSpacing="0" cellPadding="0" width="95%" >>border="0"> >> <tr><td height="10"></td></tr> >> </table> >> >> <!--- Column Headings ---> >> <table style="PADDING-RIGHT: 0px; >> PADDING-LEFT: 10px; >> PADDING-BOTTOM: 0px; >> PADDING-TOP: 0px" >> cellSpacing="0" cellPadding="0" width="95%" >>border="1"> >> <tr> >> <td align="top"> >> Incident Ref No >> </td> >> <td align="top"> >> Racist >> </td> >> <td align="top"> >> Homophobic >> </td> >> <td align="top"> >> Disabilist >> </td> >> <td align="top"> >> Religiously<br /> >> Motivated >> </td> >> <td align="top"> >> Cyber >> </td> >> <td align="top"> >> Other >> </td> >> </tr> >> <cfoutput Query="Report1"> >> <tr> >> <td align="top"> >> #IncidentIDPK# >> </td> >> <td align="top"> >> 1 >> </td> >> <td align="top"> >> 1 >> </td> >> <td align="top"> >> 1 >> </td> >> <td align="top"> >> 1 >> </td> >> <td align="top"> >> 1 >> </td> >> <td align="top"> >> 1 >> </td> >> </tr> >> </cfoutput> >> </table> >> </cfcase> >></cfswitch> >> >> >>Can anyone help me organise this properly please? >> >>Regards - Paul >> >> >>_______________________________________________ >> >>For details on ALL mailing lists and for joining or leaving lists, go >>to http://list.cfdeveloper.co.uk/mailman/listinfo >> >>-- >>CFDeveloper Sponsors:- >> >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >> >- Lists hosted by www.Gradwell.com -< >> >- CFdeveloper is run by Russ Michaels, feel free to volunteer your >> >help -< >> >> >>_______________________________________________ >> >>For details on ALL mailing lists and for joining or leaving lists, go >>to http://list.cfdeveloper.co.uk/mailman/listinfo >> >>-- >>CFDeveloper Sponsors:- >> >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >> >- Lists hosted by www.Gradwell.com -< >> >- CFdeveloper is run by Russ Michaels, feel free to volunteer your >> >help >>-< > > >_______________________________________________ > >For details on ALL mailing lists and for joining or leaving lists, go >to http://list.cfdeveloper.co.uk/mailman/listinfo > >-- >CFDeveloper Sponsors:- >>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >>- Lists hosted by www.Gradwell.com -< >>- CFdeveloper is run by Russ Michaels, feel free to volunteer your >>help -< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help >-< _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
