• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Traversing Multiple Join Tables: More Info
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Traversing Multiple Join Tables: More Info


  • Subject: Re: Traversing Multiple Join Tables: More Info
  • From: Kevin Xiaowen Ren <email@hidden>
  • Date: Tue, 13 Jul 2004 15:28:25 +1200

HI, Form my point of view, in this many-to- many relationship, you can put "version" field in Table AB.
So,
employee name
----------------------


Skill Name...................................Years Known.......................Using Version..............Software Name


doesn't matter where you put version string on your presentation lay.

hope this helps

kevin
At 19:50 12/07/2004 -0700, you wrote:
Hello --

I thought I might clarify this a little. My tables looks something like:

Table A = Employee
Table B = Skills, includes a "softwareId" field
Table C = Software
Table AB = EmployeeSkills, includes a "yearsKnown" field
Table AC = EmployeeSoftware, includes a "version" field

In my problem, I have the WORep in the Employee page, listing the skills known by that employee; like so:

employee name
----------------------

Skill Name...................................Years Known.......................Software Name..............Using Version

So I bind my WORep to the employee's EmployeeSkills table, and the item to an individual EmployeeSkill. To get the version number, I can traverse back to Employee, and then over to EmployeeSoftware. But I end up with an array of EmployeeSoftwares, and multiple versions. I would need to limit the EmployeeSoftwares array by using the softwareId field from the Skills table.

I can think of a couple of hypothetical solutions:

1) in the employeeskills.java EOGenericRecord subclass, i can make a method that performs an EOFetchSpecification or raw SQL call to get the version field.

2) Make the EmployeeSkills.java WOBuilder interface grab all of the EmployeeSoftware rows, and somehow match it up with the item EmployeeSkill.

But not only do I not really know how to do either, I dont know if it even makes sense.

Any help greatly appreciated!

-Lucas
Portland, OR
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.


References: 
 >Traversing Multiple Join Tables: More Info (From: Lucas Haley <email@hidden>)

  • Prev by Date: Re: WO Developers in FL
  • Next by Date: OT: Any VB developers here?
  • Previous by thread: Traversing Multiple Join Tables: More Info
  • Next by thread: OT: Any VB developers here?
  • Index(es):
    • Date
    • Thread