Case in point: <cfquery name="hotelWine" datasource="#request.dsn#"> SELECT h.hotel_id, h.name, h.location, w.wine_id, w.name, w.type FROM hotel h, hotel_wine hw, wine w WHERE h.hotel_id = hw.hotel_id AND hw.wine_id = w.wine_id </cfquery>
<cfdump var="#hotelWine#"> I wish I had an external IP so I could show you folks this... it's still just spiralling out of control. If I run this query in a sql tool, it brings back all the result set with no problems. ~Todd ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
