Woops, I didn't mean to post that query in there. Hehe. Sorry, disregard it.
J ----- Original Message ----- From: "JLH All Turbo" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, August 09, 2002 9:49 AM Subject: Re: SQL Help > Actually let me show you > > SELECT dbo.listings.address1, dbo.listings.city, dbo.listings.address1, > dbo.listings.zip, dbo.listings.year_built, dbo.listings.sq_feet, > dbo.listings.bedrooms, dbo.listings.bathrooms, dbo.listings.lot_size, > dbo.listings.price, dbo.listings.short_description, > dbo.listings.location_id, dbo.listings.agent_id, dbo.styles.style_name, > dbo.locations.id, dbo.locations.location_name > FROM dbo.listings, dbo.styles, dbo.locations > WHERE dbo.listings.style_id = dbo.styles.id AND > dbo.listings.location_id = dbo.locations.id > > ORDER by dbo.listings.location_id, dbo.listings.id ASC > > I have a listings, styles, and locations tables > > I want to pull the info out of LISTINGS where LOCATIONS = <#value#> and > groupby the STYLES. > > Then I want in the output, if 5 styles happen to be selected have each style > have a header with the pertaining LISTING underneath each style header. > > so > > > LOCATION=LOS ANGELES > > HEADER: SINGLE FAMILY HOME > HOUSE1 > HOUSE2 > > HEADER: APARTMENT > HOUSE3 > HOUSE4 > > HEADER: COMMERCIAL LOT > LOT1 > LOT2 > > > I can pretty much get the data out... it's just the CFOUTPUT.. I don't know > how to get the headers to show up... it's organizing the data by the style > it's just... I want each style to have a header when outputted. > > I hope this makes more sense. :-) > > J > > ----- Original Message ----- > From: "Matthew Walker" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Friday, August 09, 2002 9:44 AM > Subject: Re: SQL Help > > > > Make sure you are ordering by LocationName, then > > > > <cfoutput query="..." group="LocationName"> > > <h1>#LocationName#</h1> > > <cfoutput> > > #Ball# > > </cfoutput> > > </cfoutput> > > > > Is that what you mean?? > > > > ----- Original Message ----- > > From: "JLH All Turbo" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Saturday, August 10, 2002 1:36 AM > > Subject: SQL Help > > > > > > > How can I structure a query and it's output to pull all the records out > > that > > > have a certain field = something and have them grouped by another > field... > > > > > > And then in the output put a header for each group? > > > > > > In a DB with baseballs and footballs and different locations for the > > balls. > > > > > > Pull all balls out and group by locations > > > > > > So the output would be something along the lines of > > > > > > LOCATION1NAME > > > baseball1 > > > baseball2 > > > football1 > > > football2 > > > > > > LOCATION2NAME > > > baseball3 > > > baseball4 > > > football3 > > > football4 > > > > > > etc and run through all the locations and all the balls that pertain to > > > those locations. > > > I can get the query down, just outputting the <cfoutput> to change the > > > header of the tables is where I'm running in to problems. > > > > > > Maybe you guys can help? > > > > > > J > > > > > > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
