>- see footer for list info -< Just tried it again on mine and it looks like they might've fixed it already
Play around with it on yours and see what happens mate -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Swingewood Sent: 16 October 2006 14:56 To: [email protected] Subject: RE: [CF-Dev] Grouping and formatting ...? >- see footer for list info -< BUGGER..! I always use IsDefined ..... Mmmm not very secure though. Of course you wouldn't have got far as you would have to know the correct info to use but scary none the less. Thanks for the extra work .... - lol Regards - Paul >From: "Mark Smyth" <[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 14:45:40 +0100 > > >- see footer for list info -< > >Not related by well worth taking in, noticed this a while ago > >I think Paul must be using isDefined() to validate on the session >variables existence. Although not an error it lets this through > >http://www.bgfl.org/cfpages/bullying/_report.cfm?repid=1&session.user=a >dmin& >session.dfesno=00001 > >Surprising right?? Since CFMX you can scope url variables to mimic >scoped variables... which amazingly foxes isDefined() and opens up a >nice big hole > >Good news is that using structKeyExists() instead to validate scoped >variables does not allow this to happen. > >Just have to get round to telling Adobe about it... > >Mark >PS Paul, it's a 2 second alteration hope you don't mind me posting this up. > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Alex Skinner >Sent: 16 October 2006 14:13 >To: 'Coldfusion Development' >Subject: RE: [CF-Dev] Grouping and formatting ...? > > >- see footer for list info -< >Also have you made sure the data coming back is ordered first by >IncidentIDPK > >Otherwise it wont work > >Alex > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Duncan Cumming >Sent: 16 October 2006 13:27 >To: [email protected] >Subject: RE: [CF-Dev] Grouping and formatting ...? > > >- see footer for list info -< >don't you mean: ><cfoutput query="report1" group="IncidentIDPK"> ><h2>#IncidentIDPK#</h2> <cfoutput> > yourfields here ></cfoutput> ></cfoutput> > >Duncan Cumming >New Media Developer >Customer Relations Management / Education Fife Council 700 4105 / 01592 >414105 > > >>> [EMAIL PROTECTED] 16/10/2006 13:00 >>> > >- 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 >-< > >********************************************************************** >This email and any files transmitted with it are confidential and >intended solely for the use of the individual or entity to whom they >are addressed and should not be disclosed to any other party. >If you have received this email in error please notify your system >manager and the sender of this message. > >This email message has been swept for the presence of computer viruses >but no guarantee is given that this e-mail message and any attachments >are free from viruses. > >Fife Council >Tel: 08451 55 00 00 >************************************************ > >_______________________________________________ > >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 -<
