I have 2 tables, "company" and "user" with a many-to-many relation:
<cfcomponent entityname="company" persistent="true" table="company" output="false"> <cfproperty name="user" cfc="userGateway" fieldtype="many-to-one" fkcolumn="FK_user"> </cfcomponent> <cfcomponent entityname="user" persistent="true" table="user" output="false"> <cfproperty name="companies" cascade="all-delete-orphan" fieldtype="one-to-many" cfc="companyGateway" fkcolumn="FK_user" inverse="true" singularname="company"> </cfcomponent> (I only show the relevant code here) When I want to retrieve a company based on the id of an associated user I do this: <cfquery name="local.company" dbtype="hql"> select c.id from company as c join user as u where u.id=<cfqueryparam value="#arguments.userId#"> </cfquery> I add the join syntax _without_ the columns to join on since that is defined in the components using the cfproperty's fieldtype attribute. An <cfdump var="#local.company#"><cfabort> gives me Message Path expected for join! [ select c.id from company as c join user as u where u.id=? ] QueryString select c.id from company as c join user as u where u.id=? Either my hql is wrong or something is wrong with the mappings but I can't figure out what.. Does anyone have a clue? Coldfusion 9,0,1,274733, Win7,MySQL 5.5.16 Marc ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349880 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm