Re: Eliminating repeated data in CFoutput field

2009-03-19 Thread Azadi Saryev
it won't if you code it properly. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ BobSharp wrote: Thanks for the tip about Grouping Sadly, it would remove the eName column, when I just want it blank. ( ie. output shifts left one column )

Re: Eliminating repeated data in CFoutput field

2009-03-19 Thread Bob Sharp
Thanks guys, some useful tips that led me to this ... http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets.cfm CFquery name=qEmpAssets datasource=bs3578 SELECT concat(e.firstname, ' ', e.lastname) AS eName, LEFT(a.assetdescription,30) AS aTitle,

Re: Eliminating repeated data in CFoutput field

2009-03-19 Thread BobSharp
PM Subject: RE: Eliminating repeated data in CFoutput field Order your query by eName then do something like this: cfoutput query=yourQuery group=eName #yourQuery.eName# cfoutput #yourQuery.aTitle# #yourQuery.cCategory# /cfoutput /cfoutput You'll need to tweak it to fit in your table

Re: Eliminating repeated data in CFoutput field

2009-03-19 Thread Azadi Saryev
your current code, if you have posted it correctly, creates malformed html: since you have the opening tr tag outside of your query output but the closing /tr inside of it, all your table rows after the first one are missing the opening tr tag (check the generated source of the page you posted a

Re: Eliminating repeated data in CFoutput field

2009-03-19 Thread Dave Watts
Thanks for the tip about Grouping Sadly,  it would remove the eName column, when I just want it blank. ( ie.  output shifts left one column ) No, it needn't do that, and grouping is really the correct way to solve this problem. You can find an example here:

Re: Eliminating repeated data in CFoutput field

2009-03-19 Thread BobSharp
/CFoutput /tr /CFoutput /table - Original Message - From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, March 19, 2009 2:23 PM Subject: Re: Eliminating repeated data in CFoutput field Thanks for the tip about Grouping

Re: Eliminating repeated data in CFoutput field

2009-03-19 Thread Nick G
Message - From: Dave Watts dwa...@figleaf.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, March 19, 2009 2:23 PM Subject: Re: Eliminating repeated data in CFoutput field Thanks for the tip about Grouping Sadly, it would remove the eName column, when I just want it blank

Re: Eliminating repeated data in CFoutput field

2009-03-19 Thread BobSharp
Yep ! That's it. http://ttcfm.open.ac.uk/~bs3578/test1/abEmpAssets_02.cfm Thanks - Original Message - From: Nick G ngiova...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Thursday, March 19, 2009 9:14 PM Subject: Re: Eliminating repeated data in CFoutput field You

Re: Eliminating repeated data in CFoutput field

2009-03-19 Thread Peter Boughton
Bob, did you try the code I posted earlier? Using rowspan is the ideal way to do this, and it looks like what I wrote should work fine... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date

Eliminating repeated data in CFoutput field

2009-03-18 Thread BobSharp
rom this output, I would like to eliminate repeated names eName aTitle cCategory Doug Briggs HP Omni 510Notebook PC Nick Heap IBM Netfinity Server Desktop PC Nick Heap HP Omni 510

RE: Eliminating repeated data in CFoutput field

2009-03-18 Thread Adrian Lynch
. Adrian -Original Message- From: BobSharp [mailto:bobsh...@ntlworld.com] Sent: 18 March 2009 22:45 To: cf-talk Subject: Eliminating repeated data in CFoutput field rom this output, I would like to eliminate repeated names eName aTitle

Re: Eliminating repeated data in CFoutput field

2009-03-18 Thread Nick G
Hi Bob, That's not working because cfset eName = / is just setting a empty variable named eName it's not updating the query variable eName. Since your in a cfoutput with a query attribute CF's going to look for a query variable that matches first. IIRC the order of lookup is query, arguments,

Re: Eliminating repeated data in CFoutput field

2009-03-18 Thread Peter Boughton
This is not perfect (should really be using functions, for starters), but I think it will do what you want... cfquery name=qEmployees dbtype=Query SELECT DISTINCT eName FROM qEmpAssets /cfquery table thead tr th Name /th th