Does this make more sense? select child.id child.name from company.company child join company.company parent where parent.id = :id
The id of the parent will always be the same as the parentid, as they are joined. Mark On Fri, Oct 24, 2008 at 5:48 PM, David Mineer <[EMAIL PROTECTED]> wrote: > > Actually I guess it would be more correct to say I need parentid = companyid > > On Fri, Oct 24, 2008 at 12:44 AM, David Mineer <[EMAIL PROTECTED]> wrote: >> The :id value that I am passing is a companyid. I want all records >> that have a parentid that = companyid. >> >> Your example just gives me where companyid = companyid. >> >> I need companyid = parentid. >> >> On Fri, Oct 24, 2008 at 12:39 AM, Mark Mandel <[EMAIL PROTECTED]> wrote: >>> >>> Oh I see. >>> >>> Should be: >>> >>> from company.company as c join company.company as p where c.id = :id >>> >>> Mark >>> >>> >>> On Fri, Oct 24, 2008 at 5:37 PM, David Mineer <[EMAIL PROTECTED]> wrote: >>>> Message The property that was searched for could not be found >>>> Detail The property 'parentid' could not be found in the object >>>> 'company.company' >>>> >>>> On Fri, Oct 24, 2008 at 12:25 AM, Mark Mandel <[EMAIL PROTECTED]> wrote: >>>>> >>>>> sorry.. that's what I mean to write. What's wrong with what yuo do below? >>>>> >>>>> Mark >>>>> >>>>> On Fri, Oct 24, 2008 at 5:05 PM, David Mineer <[EMAIL PROTECTED]> wrote: >>>>> > But there is only one object: company.company >>>>> > >>>>> > Id is the pk in company >>>>> > parentid is the fk to id in the same table (company). >>>>> > >>>>> > This tql is one of the things I tried: >>>>> > >>>>> > >>>>> > "from company.company as c join company.company as p where p.parentid = >>>>> > :id >>>>> > order by p.name asc"); >>>>> > >>>>> > >>>>> > >>>>> > On Thu, Oct 23, 2008 at 11:48 PM, Mark Mandel <[EMAIL PROTECTED]> >>>>> > wrote: >>>>> >> >>>>> >> Just do a TQL join but simply alias the object names to different names >>>>> >> >>>>> >> I can't see your object names, but: >>>>> >> >>>>> >> from A as parent join B as child >>>>> >> where >>>>> >> child.foo = :bar >>>>> >> >>>>> >> Mark >>>>> >> >>>>> >> >>>>> >> On Fri, Oct 24, 2008 at 4:24 PM, David Mineer <[EMAIL PROTECTED]> >>>>> >> wrote: >>>>> >> > >>>>> >> > I have a table with a self-join. Company with a column for a parent >>>>> >> > company parentid. >>>>> >> > >>>>> >> > Here is my table definition: >>>>> >> > >>>>> >> > <id name="id" column="companyId" >>>>> >> > type="numeric"/> >>>>> >> > <property name="name" type="string" >>>>> >> > column="companyName" nullable="false"/> >>>>> >> > <property name="phone" type="string" >>>>> >> > column="phone1" nullable="true"/> >>>>> >> > <property name="fax" type="string" >>>>> >> > column="fax" nullable="true"/> >>>>> >> > <property name="licenseNo" >>>>> >> > type="string" >>>>> >> > column="licenseNo" >>>>> >> > nullable="true"/> >>>>> >> > <property name="address1" >>>>> >> > type="string" >>>>> >> > column="address" nullable="true"/> >>>>> >> > <property name="address2" >>>>> >> > type="string" >>>>> >> > column="address2" nullable="true"/> >>>>> >> > <property name="city" type="string" >>>>> >> > column="city" nullable="true"/> >>>>> >> > <property name="state" type="string" >>>>> >> > column="state" nullable="true"/> >>>>> >> > <property name="zip" type="string" >>>>> >> > column="zip" nullable="true"/> >>>>> >> > <property name="web" type="string" >>>>> >> > column="web" nullable="true"/> >>>>> >> > <property name="email" type="string" >>>>> >> > column="email" nullable="true"/> >>>>> >> > <property name="areaId" type="string" >>>>> >> > column="areaId" nullable="false"/> >>>>> >> > <property name="createdate" >>>>> >> > type="date" >>>>> >> > column="createdate" >>>>> >> > nullable="false"/> >>>>> >> > <manytoone name="parent" lazy="true"> >>>>> >> > <link to="company.company" >>>>> >> > column="parentid"/> >>>>> >> > </manytoone> >>>>> >> > >>>>> >> > This works great. Can save the parentid to that field. >>>>> >> > >>>>> >> > But! I also want a list of what I call the "satellites". These are >>>>> >> > an records where the parentid = the current companyid. >>>>> >> > >>>>> >> > So I pass a companyid and I want an array or query of all records >>>>> >> > that >>>>> >> > have that companyid in the parentid field. >>>>> >> > >>>>> >> > I can't simply do a "from company.company where parentid = :id" >>>>> >> > because parentid is a property in the company table. And I can't do >>>>> >> > what I would normally do if the relationship was to another table >>>>> >> > which would have the parentid property. This would be a simple tql >>>>> >> > join query. >>>>> >> > >>>>> >> > How do I return a query or array of all the sattelites as explained >>>>> >> > above? >>>>> >> > >>>>> >> > I did try to have a one to many like this: >>>>> >> > >>>>> >> > <onetomany name="satellites" >>>>> >> > lazy="true"> >>>>> >> > <link to="company.company" >>>>> >> > column="parentid"/> >>>>> >> > <collection type="array"/> >>>>> >> > </onetomany> >>>>> >> > >>>>> >> > But that gives the duplicate column error when I try and save. >>>>> >> > >>>>> >> > Thanks for your help, >>>>> >> > >>>>> >> > -- >>>>> >> > David Mineer Jr >>>>> >> > --------------------- >>>>> >> > The critical ingredient is getting off your >>>>> >> > butt and doing something. It's as simple >>>>> >> > as that. A lot of people have ideas, but >>>>> >> > there are few who decide to do >>>>> >> > something about them now. Not >>>>> >> > tomorrow. Not next week. But today. >>>>> >> > The true entrepreneur is a doer. >>>>> >> > >>>>> >> > > >>>>> >> > >>>>> >> >>>>> >> >>>>> >> >>>>> >> -- >>>>> >> E: [EMAIL PROTECTED] >>>>> >> W: www.compoundtheory.com >>>>> >> >>>>> >> as that. A lot of people have ideas, but >>>>> >> there are few who decide to do >>>>> >> something about them now. Not >>>>> >> tomorrow. Not next week. But today. >>>>> >> The true entrepreneur is a doer. >>>>> >> >>>>> >> >> >>>>> > >>>>> >>>>> >>>>> >>>>> -- >>>>> E: [EMAIL PROTECTED] >>>>> W: www.compoundtheory.com >>>>> >>>>> as that. A lot of people have ideas, but >>>>> there are few who decide to do >>>>> something about them now. Not >>>>> tomorrow. Not next week. But today. >>>>> The true entrepreneur is a doer. >>>>> >>>>> >> >>>> >>> >>> >>> >>> -- >>> E: [EMAIL PROTECTED] >>> W: www.compoundtheory.com >>> >>> >> >>> >> >> >> >> -- >> David Mineer Jr >> --------------------- >> The critical ingredient is getting off your >> butt and doing something. It's as simple >> as that. A lot of people have ideas, but >> there are few who decide to do >> something about them now. Not >> tomorrow. Not next week. But today. >> The true entrepreneur is a doer. >> > > > > -- > David Mineer Jr > --------------------- > The critical ingredient is getting off your > butt and doing something. It's as simple > as that. A lot of people have ideas, but > there are few who decide to do > something about them now. Not > tomorrow. Not next week. But today. > The true entrepreneur is a doer. > > > > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
