Hi everyone,
I have this query:
SELECT BusinessUnitList.BusinessUnit, BusinessUnitList.ID,
prioritystuff.BID, prioritystuff.FromWhen,
prioritystuff.ToWhen, PriorityStuff.PriorityType,
prioritystuff.THX, prioritystuff.Title, PriorityStuff.StartDate,
PriorityStuff.EndDate,
PriorityStuff.Season, PriorityStuff.ComingYear, PriorityStuff.TBD,
prioritystuff.ID AS PID
FROM BusinessUnitList INNER JOIN prioritystuff ON BusinessUnitList.ID =
prioritystuff.BID
OR BusinessUnitList.ID = prioritystuff.RIG
where prioritytype = 'CP' OR prioritytype = 'Both'
order by startDate
-----------
I want it to do this:
BUSINESSUNIT1
-item1 prioritytype = cp
-item1 prioritytype = both
-item1 prioritytype = cp
BUSINESSUNIT2
-item1 prioritytype = both
-item1 prioritytype = cp
-item1 prioritytype = both
BUSINESSUNIT3
-item1 prioritytype = both
-item1 prioritytype = cp
-item1 prioritytype = cp
------------------
Instead it is doing this:
BUSINESSUNIT1
-item1 prioritytype = cp
-item1 prioritytype = cp
BUSINESSUNIT1
-item1 prioritytype = both
BUSINESSUNIT2
-item1 prioritytype = both
-item1 prioritytype = both
BUSINESSUNIT2
-item1 prioritytype = cp
BUSINESSUNIT3
-item1 prioritytype = cp
-item1 prioritytype = cp
BUSINESSUNIT3
-item1 prioritytype = both
This is my cfcode:
<cfoutput query="GetAll" group="BusinessUnit">
<b>#GetAll.BusinessUnit#</b> <br>
<cfoutput>
#title#<Br>
#priorityType#<Br>
#StartDate#.....
</cfoutput
</cfoutput
thanks for your help
Sal
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.